MVC DataBaseFirst连接数据库

1.配置连接字符串，可以配置多个

    

<add name="MetaSearchConnectionString" connectionString="Data Source=(local);Initial Catalog=MetaSearchDB;Persist Security Info=True;User ID=sa;Password=12345012345;Pooling=true;Min Pool Size=20;Max Pool Size=50000;" providerName="System.Data.SqlClient" />

2.添加数据模型

    

    

    选择WebConfig中设置好的连接串，下方的Entitie名称即是要使用的实体名

    

    

3.数据库中连接串变为如下两部分

<!--现存数据库连接串-->
    <add name="MetaSearchConnectionString" connectionString="Data Source=(local);Initial Catalog=MetaSearchDB;Persist Security Info=True;User ID=sa;Password=12345012345;Pooling=true;Min Pool Size=20;Max Pool Size=50000;" providerName="System.Data.SqlClient" />
    <add name="MetaSearchDBEntities1" connectionString="metadata=res://*/DBEntities.DB1.csdl|res://*/DBEntities.DB1.ssdl|res://*/DBEntities.DB1.msl;provider=System.Data.SqlClient;provider connection string="data source=(local);initial catalog=MetaSearchDB;persist security info=True;user id=sa;password=12345012345;pooling=True;min pool size=20;max pool size=50000;multipleactiveresultsets=True;application name=EntityFramework"" providerName="System.Data.EntityClient" />

4.生产的数据库表关系图

    

生产的实体类和表的model如下

    

5.使用

    和CodeFirst一样，使用方法

    

MetaSearchDBEntities1 dben = new MetaSearchDBEntities1();
            var a = dben.M_MonitorSword.ToList();

来自为知笔记(Wiz)