blocks|key|918432|text|右键单击您的实体框架模式(edmx文件)>转到属性。您将在那里看到连接字符串。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|918433|如果你的实体模型在一个单独的项目中，那么它必须在它自己的设置文件中。|918434|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

Right click on your Entity Framework mode (edmx file) > goto Properties. You'll see the connection string there.

If your Entity Model is in a separate project, then it must be in it's own settings file.

blocks|key|702275|text|约定>配置，对吗？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|702276|默认情况下，EF+Code+fist将在本地SQL+express实例中创建一个数据库。|702277|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

Convention > Configuration, right?

By default, EF Code fist will create a database in your local SQL express instance.

blocks|key|918549|text|如果你正在使用带有DbContext的codefirst方法，你可以在你的web.config中放置一个名称与你的上下文类名相匹配的连接字符串，它将会工作得很好。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|918550|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

If You are using codefirst aproach with DbContext you can place a connection string with name matching your context class name in your web.config and it will work just fine.

blocks|key|702383|text|在App.Config中查找。它也会把它存储在那里。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|702384|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Look in App.Config. It will store it there too.

blocks|key|918630|text|你需要这样的东西：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|918631|<configuration>
++<connectionStrings>
++++<add+name="MyContext"
+++++++++connectionString="Data+Source=.\SQLEXPRESS;Integrated+Security=SSPI;Initial+Catalog=YourDatabaseName"
+++++++++providerName="System.Data.SqlClient"+/>
++</connectionStrings>
</configuration>|code-block|syntax|javascript|918632|或者，如果您的数据库位于App_Data文件夹中：|offset|length|style|CODE|918633|<configuration>
++<connectionStrings>
++++<add+name="MyContext"
+++++++++connectionString="Data+Source=.\SQLEXPRESS;Integrated+Security=SSPI;AttachDBFilename=%7CDataDirectory%7CYourDatabaseFilename.mdf;User+Instance=True"
+++++++++providerName="System.Data.SqlClient"+/>
++</connectionStrings>
</configuration>|918634|用扩展DbContext的类名替换MyContext。|918635|entityMap^0|0|0|C|8|0|0|3|9|H|9|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@$I|V|J|W|K|L]]|9|@]|A|$]]|$1|M|3|N|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|Y|8|@$I|Z|J|10|K|L]|$I|11|J|12|K|L]]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|13|8|@]|9|@]|A|$]]]|R|$]]

You'll need something like this:

<pre><code>&lt;configuration&gt;
 &lt;connectionStrings&gt;
 &lt;add name="MyContext"
 connectionString="Data Source=.\SQLEXPRESS;Integrated Security=SSPI;Initial Catalog=YourDatabaseName"
 providerName="System.Data.SqlClient" /&gt;
 &lt;/connectionStrings&gt;
&lt;/configuration&gt;
</code></pre>

Or if your database resides is <code>App_Data</code> folder:

<pre><code>&lt;configuration&gt;
 &lt;connectionStrings&gt;
 &lt;add name="MyContext"
 connectionString="Data Source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|YourDatabaseFilename.mdf;User Instance=True"
 providerName="System.Data.SqlClient" /&gt;
 &lt;/connectionStrings&gt;
&lt;/configuration&gt;
</code></pre>

Replace <code>MyContext</code> with name of your class that extends <code>DbContext</code>.

blocks|key|918707|text|这是我在尝试连接到现有数据库时发现的“约定重于配置”哲学的一个陷阱(就像您正在做的那样)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|918708|如果您的DbContext类(例如Northwind)位于名称空间(例如MvcProject)中，由于某种原因，EF不会将类的名称与web.config中名为"Northwind“(或"MvcProject.Northwind")的连接字符串进行匹配，然后它只会创建一个默认到本地SQLEXPRESS实例的连接字符串，以及一个名为"MvcProject.Northwind”的数据库。这将是一个空数据库。在你意识到你没有连接到正确的数据库之前，你会试图弄清楚为什么你得不到任何数据。|918709|我解决这个问题的方法(不是很优雅，但这是我找到的修复它的最快方法)：向DbContext类添加一个构造函数，该构造函数使用web.config中的连接字符串的名称调用基类-例如|918710|namespace+MvcProject
{
++++public+class+Northwind+:+DbContext
++++{
++++++++public+Northwind()+:+base("Northwind")+{}
++++}
}|code-block|syntax|javascript|918711|希望这对外面的人有帮助;-)|918712|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|Q|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|R|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

Here's a gotcha I found with the "convention over configuration" philosophy when it comes to trying to connect to existing databases (like you're doing).

If your DbContext class (e.g. Northwind) is in a namespace (e.g. MvcProject), for some reason EF won't match the name of the class with a connection string in web.config named "Northwind" (or "MvcProject.Northwind"), and then it will just create a connection string defaulting to the local SQLEXPRESS instance, with a database called "MvcProject.Northwind". This will be an empty database. And you'll break your head trying to figure out why you're getting no data back, until you realize that you're not connected to the right DB.

The way I got around this (not elegant but it's the quickest way I found to fix it): add a constructor to your DbContext class that calls the base with the name of the connection string in web.config - e.g. 

<pre><code>namespace MvcProject
{
 public class Northwind : DbContext
 {
 public Northwind() : base("Northwind") {}
 }
}
</code></pre>

Hope that helps someone out there ;-)

blocks|key|918772|text|EF无法为我找到连接，但我在base()中使用了连接字符串：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|918773|namespace+MvcProject+
{+++++
++++public+class+Northwind+:+DbContext+++++
++++{+++++++++
++++++++public+Northwind()+:+
++++++++++++base("Data+Source=servername;Initial+Catalog=database;User+ID=yourID;Password=yourPass;Trusted_Connection=False;")+{}
++++}
}++|code-block|syntax|javascript|918774|只是为了测试一下连接，它已经成功了。|918775|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

The EF couldn´t find the connection for me but I used the connection string in the base():

<pre><code>namespace MvcProject 
{ 
 public class Northwind : DbContext 
 { 
 public Northwind() : 
 base("Data Source=servername;Initial Catalog=database;User ID=yourID;Password=yourPass;Trusted_Connection=False;") {}
 }
} 
</code></pre>

Just to test the connection and it´s worked.

blocks|key|918855|text|我遇到了同样的问题，简单地按照web.config文件中的建议将我的连接字符串名称更改为context+db的名称，一切都很顺利。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|918856|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I faced the same problem and simply changed my connection string name as suggested in web.config file as the name of context db and all went well.

I've deleted the connection string from my web.config and Entity Framework is still connecting to the database! Where is the connection string being set? This is an issue because I need to make the live version of my website point to the live database.

EntityFramework - Where is the connection string?

我已经从我的web.config中删除了连接字符串，实体框架仍然连接到数据库！在哪里设置连接字符串？这是一个问题，因为我需要使我的网站的实时版本指向实时数据库。

问EntityFramework -连接字符串在哪里？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问EntityFramework -连接字符串在哪里？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问EntityFramework -连接字符串在哪里？
EN