0

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.

Improve this question
1
  • Entity Framework would automagically handle this Commented Jan 29, 2013 at 14:00

4 Answers 4

Reset to default
1

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.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

0

See this MSDN article on how to embed SQL Server into your application.

Improve this answer

Comments

0

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.

http://msdn.microsoft.com/en-us/library/hh510202.aspx

Improve this answer

Comments

0

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.

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.