Web api整合EF Core

注意这个是 asp.net core，asp.net 出门左转

首先vs创建或者rider创建新项目空的webapi项目，当前项目版本.NET6

建表

添加依赖配置ef core

使用nuget添加或者控制台  ，对应数据库和版本自己确定

Microsoft.EntityFrameworkCore.SqlServers

实体类映射配置和DbContext配置

 public class EfDbContext : DbContext
    {
        public EfDbContext(DbContextOptions<EfDbContext> options) : base(options)
        {

        }

        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            base.OnModelCreating(modelBuilder);
            modelBuilder.ApplyConfigurationsFromAssembly(this.GetType().Assembly);
        }


        public DbSet<Bookcs> Bookcs { get; set; } = default!;



    }

实体类编写

    [Table("tb_bookcs")]
    public class Bookcs
    {
        [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        public int Id { get; set; }

        public string Name { get; set; } = string.Empty;

        public string Description { get; set; } = string.Empty;


    }

主程序启动入口配置

            // 配置数据库
            builder.Services.AddDbContext<EfDbContext>(options =>
                options.UseSqlServer(builder.Configuration.GetConnectionString("sqlServer") ??
                throw new InvalidOperationException("Connection string 'MvcMovieContext' not found."))
                .LogTo(Console.WriteLine, LogLevel.Debug));

　配置文件配置 appSettings.json

  "ConnectionStrings": {
    "sqlServer": "Data Source=localhost;database=bookstore;uid=hyg;pwd=hyg;Trusted_Connection=True;TrustServerCertificate=true"
  },

看完了吗，我只是水了一篇文章。刷下存在感