EFC学习笔记

EF Core  代码

全局过滤代码.  可以实现自动过滤比如店铺和作废的信息.

 

1. 创建实体类

    /// <summary>
    ///  学生类
    /// </summary>
    public class Student
    {
        /// <summary>
        /// ID
        /// </summary>
        [Key]
        public Guid ID { get; set; } = Guid.NewGuid();
        /// <summary>
        /// 名字
        /// </summary>
        [StringLength(50)]
        [Required]
        public string Name { get; set; }
        /// <summary>
        /// 年龄
        /// </summary>
        public int Age { get; set; }
        /// <summary>
        /// 性别
        /// </summary>
        public EmSex Sex { get; set; } = EmSex.未填;
    }
    public enum EmSex
    {
        男 = 0,
        女 = 1,
        未填 = 2
    }

2.创建数据上下文, 并额外添加一个给基类传递数据库连接参数的构造函数

    //要到NuGet中下载支持
    //Microsoft.EntityFrameworkCore
    class AppDbContext:DbContext
    {
        //定义一个基类的连接参数构造函数
        public AppDbContext(DbContextOptions options) : base(options)
        { }

        public DbSet<Student> Students{ get; set; }

    }

3.实例化并调用, 并添加一条数据

            Product product = new Product();
            product.Name = "商品1";
            product.Price = 100;
            product.Weight = 100;


            //这里是给数据上下文创建连接参数,  需要到NuGet中下载
            //Microsoft.EntityFrameworkCore.SqlServer
            DbContextOptionsBuilder contextOptionsBuilder = new DbContextOptionsBuilder();
            
            //给连接提供连接参数
            contextOptionsBuilder.UseSqlServer("data source=121.199.2.203,52066;uid=sa;pwd=aliSqlHuang6825;initial catalog=Y_EFC_Test;Persist Security Info=true");
            
            //保存修改.
            AppDbContext appDbContext = new Ap