C# EntityFrameworkCore EF Core 入门使用

    /// <summary>
    /// 升级程序上下文DbContext
    /// </summary>
    public class UpgraderDbContext : DbContext
    {
        /// <summary>
        /// 构造器
        /// </summary>
        /// <param name="connString">连接字符串</param>
        public UpgraderDbContext(DbContextOptions<UpgraderDbContext> options) :
            base(options)
        {
            //
        }

        /// <summary>
        /// 创建数据库上下文
        /// </summary>
        /// <param name="configName">app.config的配置名称</param>
        /// <returns></returns>
        public static UpgraderDbContext CreateDbContext(string connString)
        {
            var optionsBuilder = new DbContextOptionsBuilder<UpgraderDbContext>();
            optionsBuilder.UseSqlServer(connString);
            return new UpgraderDbContext(optionsBuilder.Options);
        }


        public DbSet<sys_UpgraderSystemName> sys_UpgraderSystemName { get; set; }

        public DbSet<sys_UpgraderVersion> sys_UpgraderVersion { get; set; }

        public DbSet<sys_UpgraderPackageTable> sys_UpgraderPackageTable { get; set; }

        public DbSet<sys_UpgraderLog> sys_UpgraderLog { get; set; }

    }

var connectionString="Server=192.168.1.9;Database=AutoUpgraderV2;User ID=sa;Password=test; Max Pool Size=512; Pooling=true;Connect Timeout=10;MultipleActiveResultSets=true;TrustServerCertificate=true;";
var context = UpgraderDbContext.CreateDbContext(connectionString);

var q = context .sys_UpgraderLog.AsQueryable();
var list = q.ToList();