Do you need to have SQL Server installed on the machine if the connection string is used for the path to the .mdf file?

I am wondering if it is possible to use Linq to SQL with a .mdf file on a machine without an instance of SQL Server installed?

+1


a source to share


3 answers


No, you need to attach the file to some MSSQL instance. You can do this with MsSQL Express.



+1


a source


You have to attach the database to some Sql Server instance. You probably want to do this on a single machine, otherwise you will add network latency (which can be marginal in some cases) when writing to the database.



+1


a source


If the cost of SQL Server is an issue, you can probably use SQL Server Express. It's free. Download for the 2008 version here . Or you can use 2005 version here .

+1


a source







All Articles