.Net Core6.0 Entity FrameWorkCore与SqlServer创建连接DBcontext上下文

using System;
using System.Collections.Generic;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Metadata;
 
namespace Student.Manage.Api.Models
{
    /// <summary>
    /// 添加Nuget包：
    /// Microsoft.EntityframeworkCore.Core
    /// Microsoft.EntityframeworkCore.SqlServer
    /// Microsoft.EntityframeworkCore.Tools
    /// Microsoft.EntityframeworkCore.Abstractions
    /// Microsoft.EntityframeworkCore.Relational
    /// </summary>
    public partial class TestDBContext : DbContext
    {
        public TestDBContext()
        {
        }
 
        public TestDBContext(DbContextOptions<TestDBContext> options)
            : base(options)
        { 
        }
        /// <summary>
        /// Tb_Student测试实体（与数据库表结构设计保持一致）
        /// </summary>
        public virtual DbSet<Tb_Student> TbStudents { get; set; } = null!;
        /// <summary>
        /// 与数据库建立连接函数
        /// </summary>
        /// <param name="optionsBuilder"></param>
        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            #region 与sqlserver数据库建立连接两种方式
            //第一种 
            //optionsBuilder.UseSqlServer("Data Source=.;Initial Catalog=TestDB;Integrated Security=True;Trust Server Certificate=True"); 
            //第二种（在配置文件中设置数据库连接字符串）
            //"ConnectionStrings": {
            //    "DbDefaultString": "Data Source=.;Initial Catalog=TestDB;Integrated Security=True;Trust Server Certificate=True"
            //}
            optionsBuilder.UseSqlServer("name=ConnectionStrings:DbDefaultString");
            //第三种（）
            //base.OnConfiguring(optionsBuilder);
            #endregion          
        }
 
        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            modelBuilder.Entity<Tb_Student>(entity =>
            {
                entity.ToTable("tb_Student");
 
                entity.Property(e => e.Id)
                    .ValueGeneratedNever()
                    .HasColumnName("id");
 
                entity.Property(e => e.StuAge).HasColumnName("stu_age");
 
                entity.Property(e => e.StuGender)
                    .HasMaxLength(10)
                    .HasColumnName("stu_gender")
                    .IsFixedLength();
 
                entity.Property(e => e.StuGrade)
                    .HasMaxLength(50)
                    .HasColumnName("stu_grade");
 
                entity.Property(e => e.StuName)
                    .HasMaxLength(50)
                    .HasColumnName("stu_name");
 
                entity.Property(e => e.StuRemark)
                    .HasMaxLength(255)
                    .HasColumnName("stu_remark");
            });
 
            OnModelCreatingPartial(modelBuilder);
        }
 
        partial void OnModelCreatingPartial(ModelBuilder modelBuilder);
    }
}

数据库连接字符串获取

工具>连接到数据库