Connection String for access SQL server using C#

#Connection String to access SQL server *.mdf & *.ldf file.

1. For SQL server database file attachment for installation folder needs *.mdf and *.ldf file using below connection string.

<add name="MovieDBContext" 

connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=Movies;AttachDbFilename=|DataDirectory|\Movies.mdf;Integrated ecurity=True" providerName="System.Data.SqlClient" />


2.Attach a database file on connect to a local SQL Server Express instance

<add name="MovieDBContext"

connectionString="Data Source=.\SQLEXPRESS;Initial catalog=Movies;AttachDbFilename=C:\MyFolder\MyDataFile.mdf;ntegrated Security=True" providerName="System.Data.SqlClient" />