I made a C# based application that use SQLCommand, SQLConnection and SQLAdapter (SQL objects) with database named "base1". Problem is that, SQL is installed in my PC along with Visual Studio, so App recieve no problem in connecting itself to base1 for transaction of data.
Now, i want to make setup of this application. I want to add "base1" in this setup so that when new user install this application, app can easily connect with base1.
Just simply use SQL Server CE (Compact Edition). It means you have only db file (.mdf) and two dll files (containing SQL Server CE library) attached additionaly to your app. Of course, then you should use SqlCeConnection instead of SqlConnection class and so on.
See this MSDN article on how to embed SQL Server into your application.
Depending on your needs, you can use LocalDB which is installed with VS every time. So you will always have a server as (localdb)/v11.0 on your computer.
You can use SQLITE to make your application portable.if not you have to add the SQlserver installation to your application install. But this method needs configuration with avery installation in a new computer.
