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)

MVC DataBaseFirst串連資料庫