1,在Nuget管理中下载EntityFramework
2,配置文件中添加数据库配置
<connectionStrings> <add name="DefaultConnection" connectionString="Data Source=*****;Initial Catalog=CodeFirstDB;User ID=sa;Password=*****;Pooling=False;MultipleActiveResultSets=true" providerName="System.Data.SqlClient"/> </connectionStrings>
3,定义实体类
/// <summary> /// 用户 /// </summary> public class User { public int ID { get;set;} public string NickName { get; set; } public DateTime RegisterTime { get; set; } }
4,定义一个EF上下文类(数据访问)
public class DB:DbContext { public DB() : base("DefaultConnection") { }//初始化一个使用连接名称为"DefaultConnnection"的数据访问上下文类的新实例 public DbSet<User> User { get; set; } protected override void OnModelCreating(DbModelBuilder modelBuilder) { modelBuilder.Conventions.Remove<PluralizingTableNameConvention>();//移除复数表名的契约 } }
5,实例化上下文对象,操作一次表就会在服务器自动创建数据库(db.Database.Create())
class Program { static void Main(string[] args) { DB db = new DB(); db.User.ToList(); Console.ReadKey(); } }