Dot net framework and SQL server Required or not

Question

5.00/5 (1 vote)

See more:

.NET3.5

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

Posted 7-Jan-11 19:25pm

krishna_goluguri

Add a Solution

3 solutions

Solution 1

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.

Posted 7-Jan-11 21:40pm

dan!sh

Comments

krishna_goluguri 8-Jan-11 4:43am

Then if the client have the database project he needs to install dot net frame work and sql server which is lorger than (dot net framework 3.5 ~200MB and SQL Server Express 55MB)is it true?
why ms not considered about we have to include the files which are required in our project not all like framework and sql express i think

Solution 2

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.

Posted 7-Jan-11 21:45pm

AnupKumarYadav

Comments

krishna_goluguri 8-Jan-11 4:43am

Then if the client have the database project he needs to install dot net frame work and sql server which is lorger than (dot net framework 3.5 ~200MB and SQL Server Express 55MB)is it true?
why ms not considered about we have to include the files which are required in our project not all like framework and sql express i think

AnupKumarYadav 9-Jan-11 7:08am

See Initially with Windows XP .Net framework was not shipped, now a days all MS O/S are coming with .Net Framework installed but the actual version & service packs may differ. suppose You are developing for .Net framework 4.0 and the operating system is having .net framework 3.5 then also you have to include the .Net framework 4.0.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2011-01-07T21:56:00

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.