/// <summary>
    /// 团队成员模型
    /// </summary>
    public class Member
    {
        /// <summary>
        /// 团队成员主键
        /// </summary>
        public int Id { set; get; }
        /// <summary>
        /// 团队成员名
        /// </summary>
        public string FirstName { set; get; }
        /// <summaryhua
        /// 团队成员花名
        /// </summary>
        public string NickName { set; get; }

        /// <summary>
        /// 团队主键
        /// </summary>
        public int TeamId { set; get; }
    }

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

        public DbSet<Member> Members { get; set; }
    }

     public void ConfigureServices(IServiceCollection services)
        {
            // 1、注册上下文到IOC容器
            services.AddDbContext<MemberContext>(options => {
                options.UseSqlServer(Configuration.GetConnectionString("DefaultConnection"));
            });
        }

{
  "Logging": {
    "LogLevel": {
      "Default": "Information",
      "Microsoft": "Warning",
      "Microsoft.Hosting.Lifetime": "Information"
    }
  },
  "AllowedHosts": "*",
  "ConnectionStrings": {
    "DefaultConnection": "Data Source=.;Initial Catalog=memberservice;Persist Security Info=True;User ID=sa;Password=tony"
  }
}

dotnet tool install --global dotnet-ef

dotnet ef migrations add test

dotnet ef database update

    public interface IMemberService
    {
        IEnumerable<Member> GetMembers();
        IEnumerable<Member> GetMembers(int teamId);
    }

    public class MemberServiceImpl : IMemberService
    {
        public readonly IMemberRepository memberRepository;
        public IEnumerable<Member> GetMembers()
        {
            return memberRepository.GetMembers();
        }
        public IEnumerable<Member> GetMembers(int teamId)
        {
            return memberRepository.GetMembers(teamId);
        }
    }

    public interface IMemberRepository
    {
        IEnumerable<Member> GetMembers();
      
        IEnumerable<Member> GetMembers(int teamId);
    
    }

    public class MemberRepository : IMemberRepository
    {
        public MemberContext teamContext;
        public MemberRepository(MemberContext teamContext)
        {
            this.teamContext = teamContext;
        }
      
        public IEnumerable<Member> GetMembers()
        {
            return teamContext.Members.ToList();
        }

        public IEnumerable<Member> GetMembers(int teamId)
        {
            return teamContext.Members.Where(memeber => memeber.TeamId == teamId);
        }
    }

     public void ConfigureServices(IServiceCollection services)
        {
            // 1、注册上下文到IOC容器
            services.AddDbContext<MemberContext>(opt =>
           opt.UseSqlServer(Configuration.GetConnectionString("DefaultConnection")));  //使用SqlServer数据库

            // 2、注册成员service
            services.AddScoped<IMemberService, MemberServiceImpl>();

            // 3、注册成员仓储
            services.AddScoped<IMemberRepository, MemberRepository>();

            services.AddControllers();
        }

    [Route("api/[controller]")]
    [ApiController]
    public class MembersController : ControllerBase
    {
        private readonly IMemberService memberService;

        public MembersController(IMemberService memberService)
        {
            this.memberService = memberService;
        }
        /// <summary>
        /// 查询所有成员信息
        /// </summary>
        /// <param name="teamId">?teamId参数结尾方式</param>
        /// <returns></returns>
        [HttpGet]
        public ActionResult<IEnumerable<Member>> GetMembers(int teamId)
        {
            if (teamId == 0)
            {
                return memberService.GetMembers().ToList();
            }
            else
            {
                return memberService.GetMembers(teamId).ToList();
            }
        }
    }