Click here to Skip to main content
15,898,134 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi Friends,
I want to make a database in an sql server database file. what I want to make my application independent of sql server running of the system, just like MS Access integration with the forms. May be you can understand what I want. Please tell me some way how to go for it.
Regards
Posted

This is an area that i have been looking at for my own projects over the years, and although there are many options, it can be difficult to work out all the features available, requirements, complications etc.

The Microsoft route obviously leaves you with MS SQL Express, but that still relies on installing a database engine on the host machine.

I have searched over the years, for file based solutions, embedded solutions etc. etc. and the only one that appears to jump out as being an option is VistaDB, the latest version consists of a 1MB DLL that you use with your project and provides all the SQL functionality.

I haven't used it yet, so cannot say how good it is or how bad it is, but there is a free trial version you can take for a spin.

[Note, i am not connected with the company in any way, so i am not try to sell anything here!] http://www.vistadb.net/[^]

Maybe worth a look......
 
Share this answer
 
Try: http://code.google.com/p/dblinq2007/[^]

You should be able to use SQLite[^] with LINQ. I've used it (but not with LINQ, just plain INSERT's etc) and its working fine.
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900