Skip to content Skip to sidebar Skip to footer

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"