Connect Ef To Sql Server Management Studio
I'm using EF code-first and I want it to create the new database in SQL Server Management Studio instance instead of using the integrated SQL Server in Visual Studio. I added this
Solution 1:
try add this section
<entityFramework><defaultConnectionFactorytype="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework"><parameters><parametervalue="connection string......"/></parameters></defaultConnectionFactory></entityFramework><connectionStrings><addname="..."providerName="System.Data.SqlClient"connectionString="......" /></connectionStrings>
you do not have to use <parameters>
property , you can use your currently connection string configuration
Solution 2:
Try
<connectionStrings><clear /><addname="YourEFContextName"connectionString="Data Source=localhost\SqlServerInstanceName; Initial Catalog=DataBaseName; User ID=UserName; password=YourPassword; MultipleActiveResultSets=True;"providerName="System.Data.SqlClient" /></connectionStrings>
The section entityFramework
should be created automatically.
Post a Comment for "Connect Ef To Sql Server Management Studio"