将EF连接到SQL Server Management studio [英] Connect EF to SQL Server Management studio

问题描述

我正在使用EF代码优先，我希望它在SQL Server Management Studio实例中创建新数据库，而不是在Visual Studio中使用集成的SQL Server。

我添加到我的 web.config ：

 的ConnectionStrings> 
< add name =BillFo
 connectionString =Data Source = SELANL293; Initial Catalog = Billfo; Integrated Security = True/> 
< / connectionStrings> 
  

但它没有帮助。没有任何事情发生，集成SQL Server中没有任何事情，我的SQL Server Management Studio中没有任何内容。如何使它在Management Studio中创建我的数据库，然后在Visual Studio中创建SQL Server？

解决方案

尝试

 < connectionStrings> 
< clear /> 
< add name =YourEFContextNameconnectionString =Data Source = localhost\SqlServerInstanceName; Initial Catalog = DataBaseName; User ID = UserName; password = YourPassword; MultipleActiveResultSets = True; providerName =System.Data.SqlClient/> 
< / connectionStrings> 
  

应该自动创建 entityFramework 部分。

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 to my web.config:

<connectionStrings>
    <add name="BillFo" 
         connectionString="Data Source=SELANL293;Initial Catalog=Billfo;Integrated Security=True"/>
</connectionStrings>

But it doesn't help. No nothing happens, nothing in the integrated SQL Server and nothing in my SQL Server Management Studio. How do I make it create my database in Management Studio rather then the SQL Server in Visual Studio?

解决方案

Try

<connectionStrings>
    <clear />
    <add name="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.

这篇关于将EF连接到SQL Server Management studio的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！