Click here to Skip to main content
15,891,423 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
hello,
i want complete solution and step wise process for creating setup with database ..because when i attached the .mdf file and set datasource my application works fine in my system beacuse i have installed mssql server 2008 but when i apply same thing in clients system,i show error that sql server is not installed while i set the prerequisite during setup creating..plz help me..i couldn't understand the problem.and i don't want to install sql server 2008R2 in other system for my windows form application.please help me ..
Posted
Updated 12-Oct-13 13:51pm
v2
Comments
Mehdy Moini 13-Oct-13 1:58am    
you must have a sql server at least express edition!
RedDk 13-Oct-13 13:47pm    
Respost(3x). What tools are you using, by the way?

1 solution

if you do not want to install sql server to your clients' computers, then you should develop your application with portable database solutions such as sqlite. It is a database system developed for the situations that fit to your case :https://www.sqlite.org/[^]
There are .net adapters for sqlite as well, therefore there is not much of a change in your code while converting it to the latter:http://system.data.sqlite.org/index.html/doc/trunk/www/index.wiki[^].
If you insist on microsoft sql server, the most you can do is to prepare a bootstrapper installer that will also install MS SQL Server Express edition (which is free). But be warned; the installation requires some knowledge on databases (person installing will determine sql instace .etc.

Here are some examples on implementing sqlite.net:
Using SQLite in your C# Application[^]
https://code.google.com/p/sqlite-net/wiki/GettingStarted[^]
http://zetcode.com/db/sqlitecsharp/[^]
http://www.dreamincode.net/forums/topic/157830-using-sqlite-with-c%23/[^]
 
Share this answer
 
v2
Comments
Ashwani iOS 15-Oct-13 7:14am    
Thnks for suggest me..but tell me how to use it in my application.
MCY 15-Oct-13 12:32pm    
I have added some tutorials and example solutions. If you need help on a specific point where your code fails to work, feel free to ask. Else, these examples will clarify basics of sqlite.net.
Ashwani iOS 17-Oct-13 2:27am    
plz provide me tutorial
MCY 17-Oct-13 10:37am    
see the links in the updated 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