【EF Code First】CodeFirst初始配置

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();
        }
    }

  

原文地址:https://www.cnblogs.com/Sunlimi/p/4347526.html