点网框架和SQL Server是否必需 [英] Dot net framework and SQL server Required or not

问题描述

嗨 当我搜索部署并创建可执行文件时，有些网络专家说，对于数据库项目，客户端系统必须需要.net框架和SQL Server Express.
然后我怀疑我是否通过从download.com下载安装了许多数据库项目，但他们不会在任何时候都需要安装oracle或SQL Server之类的问题，为什么dot net项目需要，net frame work和sql server的区别是什么?客户端计算机，因为它们很大.但是对于Java项目，它们不会像您那样安装oracle询问.

请澄清我的疑问

Hi when i searching for deployment and creating executable files some dot net persons says it is necessary for the database projects clients system must need .net framework and SQL server express.
Then i have a doubt i installed somany database projects by downloading from download.com but they wont ask any time you have to install oracle or SQL server like that what is the difference why the dot net projects requires ,net frame work and sql server in clients computer because they are huge size.but for the java projects they dont ask like you have to install oracle like that.

please clarify my doubt

推荐答案

让我们将其视为两个问题:
1)是否需要在所有数据库项目中安装SQL Server Express?
2)当Java安装不需要任何东西时，为什么.NET项目需要.NET框架?

仅当使用SQL Server时才需要SQL Server Express.如果使用SQLCE数据库或Access DB，则不需要SQL Server 0 Express.但是，如果是这样，则需要安装它. Access和SQLCE是自包含的，单用户的，相对简单的数据库(1)，因此，对它们的支持都包含在框架或可执行文件中. SQL Server是一个多用户数据库，具有广泛的功能，因此是一个巨大的文件.因此，它作为单独的软件包安装，因此不必每次都安装-每个客户端站点只需安装一次，无论涉及多少用户.该框架包含与数据库软件对话的少量代码.

Java项目确实需要一些东西:Java框架，它可能已经安装在许多PC上-如果不是，那么安装通常会在继续之前提示您. Java运行时框架大约为15至20兆.除非已安装，否则Java程序将无法工作.
.NET项目需要.NET框架(至少已安装在Vista和7 Windows的V3.5上).它有多大?邓诺(Dunno)完全一样，但是如果您一开始没有安装任何内容，则大约为100兆.
为什么这么大?因为.NET的每个版本都包含完整的先前版本，所以期望框架的较早版本的软件将无缝运行-他们甚至都不会注意到较新的版本.




(1)不要太挑剔:我知道Access DB可以用作多用户，但它是PITA，并且会导致更多的问题而不是解决的.

Lets look at this as two questions:
1) Do you need to install SQL server express with all database projects?
2) Why do .NET projects need the .NET framework when Java installations don''t need anything?

SQL server express is only needed if you are using SQL server. If you use a SQLCE database, or an Access DB then you don''t need SQL Server 0 express or not. But if you are, then it needs to be installed. Access and SQLCE are self contained, single user, relatively simple databases(1) and as such the support for them is contained within the framework or within your executable. SQL Server is a multiuser DB, with an enormous range of features, and as such is a huge file. So, it is installed as a separate package so that it doesn''t have to be installed each time - just once per client site, regardless of how many users are involved. The framework contains a small amount of code that talks to the database software.

Java project do need something: the Java framework, which is probably installed on many pcs already - if it isn''t then the installation generally prompts for it before proceeding. The Java runtime framework is around 15 - 20 meg. Java programs will not work unless it is installed.
.NET projects need the .NET framework (which is installed on Vista and 7 Windows already at V3.5 at least). How big is it? Dunno exactly, but about 100 meg if you have nothing installed to start with.
Why so big? Because each version of .NET contains the complete previous version, so that software expecting earlier versions of the framework will work seamlessly - they don''t even notice a later version.




(1) Don''t get picky at the back: I know Access DBs can be used as multiuser, but it''s a PITA and causes more problems than it solves. Been there, done that.

应用程序需要数据库的计算机应安装SQL Server或任何其他数据库.如果此计算机恰好是客户端计算机，则应安装它.

不必具有SQL Express即可运行基于.Net的应用程序.

The computer where application needs the database, should have the SQL server or any other database installed. If this computer happens to be the client computer, it should have it installed.

It is not mandatory to have a SQL express to run a .Net based application.

请参见，至少您需要在客户端上安装.Net框架(应用程序需要的版本).计算机运行.net应用程序.

如果应用程序使用的本地数据库也使用SQL Server数据库，那么您需要安装数据库支持.如果将应用程序配置为使用网络(Internet或Intranet)数据库服务器运行，则无需在客户端计算机上安装数据库.

See, you at least need .Net framework (version required by the application) to be installed on the client computer to run .net application.

If the application is using local database that too SQL Server database then you need to install Database support. If the application is configured to run using network (internet or intranet) database server then you need not install database on the client machine.

这篇关于点网框架和SQL Server是否必需的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！