Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to 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
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

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.
  Permalink  
Comments
krishna_goluguri at 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
OriginalGriff at 8-Jan-11 4:48am
   
Krishna, If you don't like it, you don't have to use it!
Instead of .NET you could use native code: but then you have to do a lot more of teh work yourself, which is why .NET was developed. Oh, and you can't run on Linux. Oh, and you can't use anything you learnt on Window mobile.
Yes a DB is a large file, but that's because it is a very complex program. Look at the what is involved in doing just Replication yourself and think how much software they need to do it seamlessly, and generically.
krishna_goluguri at 8-Jan-11 4:53am
   
i am not saying that i dont wanted to use database like that in my early days i downloaded some softwares from download.com like college management system,hospital management system,contact management system like that but they dont prompt me to install any database i simply install them and store my data when ever i require i search for that data.i am asking that way
OriginalGriff at 8-Jan-11 5:00am
   
Krishna, you still can. You don't have to use a "real" DB such as MsSql, or MySql.
You can still use a flat file, and XML file, or a simple database - SQLCE is one example, which will work happily under .NET with no further installation required.
In your early days - and mine - we re-invented the wheel every time. Everything was native code, locked to the OS and the processor. We can (and some do) still do that, but the industry as a whole has moved on. Moved to code re-use, higher reliability though a wide set of "proven" modules. We don't generally develop our own data storage systems, any more than we develop our own floppy disk layouts!
krishna_goluguri at 8-Jan-11 5:09am
   
Thank you now i understood i need SQLCE and Dot net Framework
Rate this: bad
good
Please Sign up or sign in to vote.

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.
  Permalink  
Comments
krishna_goluguri at 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
Rate this: bad
good
Please Sign up or sign in to vote.

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.
  Permalink  
Comments
krishna_goluguri at 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 at 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.

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

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 6,725
1 OriginalGriff 6,696
2 CPallini 5,315
3 George Jonsson 3,589
4 Gihan Liyanage 2,650


Advertise | Privacy | Mobile
Web02 | 2.8.140921.1 | Last Updated 8 Jan 2011
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100