How can I run C# app which contains local SQL Server database on another computer?

c# sql-server database local
Petar Bechev picture Petar Bechev · Jan 29, 2016 · Viewed 11.6k times · Source

I have created a C# program with a SQL Server database. It works fine on my computer but on my friend's PC it doesn't (my friend doesn't have SQL Sever 2008). Is it possible to make it without any installation? And if it can, how can it be done?

This is my connection string:

connectionString="Data Source=\v11.0;AttachDbFilename=|DataDirectory|\MainDatabase.mdf;Integrated Security=True"

Answer

Mike Tsayper picture Mike Tsayper · Jan 29, 2016

SQL Server is for server databases. You can change your project to use SQL Server CE (SQL Server Compact Edition) which is a single-file local database. It is very similar to the "true" SQL Server so it may be the easiest solution. Your code probably wont change except for the connection string.

Related questions

Insert 2 million rows into SQL Server quickly

I have to insert about 2 million rows from a text file. And with inserting I have to create some master tables. What is the best and fast way to insert such a large set of data into SQL Server?

Read More
Received an invalid column length from the bcp client for colid 6

I want to bulk upload csv file data to sql server 2005 from c# code but I am encountering the below error - Received an invalid column length from the bcp client for colid 6. when bulk copy write to database server

Read More
C# Sql Connection String

I'm a 17 year old software engineering student and am having trouble with linking my sql database to my C# Win App. I was able to accomplish this task using a access database but the database needs to be in SQL. …

Read More