前面几节，使用的都是通过EF Code First创建的新数据库，接下来，将开始使用已存在的数据库。

　　1、使用配置文件设置数据库连接

　　App.config

　　数据库连接字符串的name与Data中NorthwindContext.cs类名相同

<?xml version="1.0" encoding="utf-8"?><configuration>  <configSections>    <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=4.3.1.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />  </configSections>  <connectionStrings>    <add name="NorthwindContext" connectionString="Data Source=(local); Database=Northwind; User ID=sa; Password=1;" providerName="System.Data.SqlClient"/>  </connectionStrings></configuration>　　Data中NorthwindContext.cs

1 using System; 2 using System.Collections.Generic; 3 using System.Linq; 4 using System.Text; 5  6 using System.Data.Entity; 7  8 using Northwind.Domain.Entities; 9 using Northwind.Domain.Mapping;10 11 namespace Northwind.Data12 {13     public class NorthwindContext : DbContext14     {15         public DbSet<Category> Categories { get; set; }16         public DbSet<Product> Products { get; set; }17         public DbSet<Supplier> Suppliers { get; set; }18 19         protected override void OnModelCreating(DbModelBuilder modelBuilder)20         {21             modelBuilder.Configurations.Add(new CategoryMap());22             modelBuilder.Configurations.Add(new ProductMap());23             modelBuilder.Configurations.Add(new SupplierMap());24         }25     }26 }　　执行成功后，创建的数据库如下图：

　　2、使用构造函数指定数据库

　　NorthwindContext.cs

1 using System; 2 using System.Collections.Generic; 3 using System.Linq; 4 using System.Text; 5  6 using System.Data.Entity; 7  8 using Northwind.Domain.Entities; 9 using Northwind.Domain.Mapping;10 11 namespace Northwind.Data12 {13     public class NorthwindContext : DbContext14     {15         public NorthwindContext()16         { }17 18         public NorthwindContext(string databaseName)19             : base(databaseName)20         {21 22         }23 24         public DbSet<Category> Categories { get; set; }25         public DbSet<Product> Products { get; set; }26         public DbSet<Supplier> Suppliers { get; set; }27         public DbSet<User> Users { get; set; }28         public DbSet<Role> Roles { get; set; }29 30         protected override void OnModelCreating(DbModelBuilder modelBuilder)31         {32             modelBuilder.Configurations.Add(new CategoryMap());33             modelBuilder.Configurations.Add(new ProductMap());34             modelBuilder.Configurations.Add(new SupplierMap());35             modelBuilder.Configurations.Add(new UserMap());36             modelBuilder.Configurations.Add(new RoleMap());37         }38     }39 }　　Program.cs

using (NorthwindContext db = new NorthwindContext("Northwind")){}　　3、使用构造函数指定数据库连接字符串

　　App.config

1 <?xml version="1.0" encoding="utf-8"?> 2 <configuration> 3   <configSections> 4     <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 --> 5     <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=4.3.1.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" /> 6   </configSections> 7   <connectionStrings> 8     <add name="NorthwindConnectionString" connectionString="Data Source=(local); Database=Northwind; User ID=sa; Password=1;" providerName="System.Data.SqlClient"/> 9   </connectionStrings>10 </configuration>　　NorthwindContext.cs

1 using System; 2 using System.Collections.Generic; 3 using System.Linq; 4 using System.Text; 5  6 using System.Data.Entity; 7  8 using Northwind.Domain.Entities; 9 using Northwind.Domain.Mapping;10 11 namespace Northwind.Data12 {13     public class NorthwindContext : DbContext14     {15         public NorthwindContext()16             : base("name=NorthwindConnectionString")17         { }18 19         public DbSet<Category> Categories { get; set; }20         public DbSet<Product> Products { get; set; }21         public DbSet<Supplier> Suppliers { get; set; }22         public DbSet<User> Users { get; set; }23         public DbSet<Role> Roles { get; set; }24 25         protected override void OnModelCreating(DbModelBuilder modelBuilder)26         {27             modelBuilder.Configurations.Add(new CategoryMap());28             modelBuilder.Configurations.Add(new ProductMap());29             modelBuilder.Configurations.Add(new SupplierMap());30             modelBuilder.Configurations.Add(new UserMap());31             modelBuilder.Configurations.Add(new RoleMap());32         }33     }34 }

最新文章

  1. 漫谈c++11 Thread库之使写多线程程序
  2. jenkins发送带附件（logfile.log和index.html）的邮件配置
  3. Linux配置SSH免密码登陆
  4. int转string
  5. Python学习笔记——Day1
  6. poj 3792 Area of Polycubes
  7. 玩转Web之Jsp（三）-----Jsp+SQLServer 用sql语句实现分页
  8. Android Studio利用异步任务AsyncTask发送post请求获取json数据
  9. JS 用角度换东南西北
  10. hdu 5536 xor题
  11. 关于js的一些基本知识（类,闭包，变量）
  12. js将汉字转为相应的拼音
  13. js较深入的知识点
  14. python 数据分析基础
  15. 008、Docker 组件如何协作（2018-12-25 周二）
  16. Matlab PCA 算法
  17. Matlab 编程
  18. JavaScript-2.内置对象---简单脚本之弹出对话框显示当前时间 ---ShinePans
  19. day5模块学习--hashlib模块
  20. DOS程序员手册（十三）

热门文章

  1. 深夜Python - 第1夜 - for 迷 in 迷思
  2. 9.ActiveMQ理论
  3. java 打印1到n之间的整数
  4. xx市xx项目运维工作方案
  5. 2019-9-11-在-P2P-文件分享应用以文件或文件段为单位的优缺
  6. Spark RDD基本操作
  7. nginx 知识
  8. Web安全之XSS 入门与介绍
  9. 1分钟k线图能反映什么？(转)
  10. C# - Finalize 和 Dispose