Program.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using EFQL.Model;
using Microsoft.EntityFrameworkCore;
using System.Linq;

var builder = WebApplication.CreateBuilder(args);

// Add services to the container.
// Learn more about configuring Swagger/OpenAPI at https://aka.ms/aspnetcore/swashbuckle

builder.Services.AddSqlServer<UserContextDB>("Data Source=.;Initial Catalog=Users;Integrated Security=True;TrustServerCertificate=true");

builder.Services.AddEndpointsApiExplorer();
builder.Services.AddSwaggerGen();

var app = builder.Build();

// Configure the HTTP request pipeline.
if (app.Environment.IsDevelopment())
{
    app.UseSwagger();
    app.UseSwaggerUI();
}

app.MapGet("/Hello", () => "Hello World");

app.MapGet("/initial", async (UserContextDB db) =>
{
    await db.Depts.AddRangeAsync(new List<Department>
    {
        new Department{DeptName="Dept1",Description="d1" },
        new Department{DeptName="Dept2",Description="d1" },
        new Department{DeptName="Dept3",Description="d1" },

    });



    await db.Users.AddRangeAsync(new List<User>
    {
        new User{Name="User1",Age=1,Gender="man",DeptId=1 },
        new User{Name="User2",Age=2,Gender="man",DeptId=1 },
        new User{Name="User3",Age=3,Gender="man",DeptId=1 },
        new User{Name="User4",Age=4,Gender="man",DeptId=1 },
        new User{Name="User5",Age=5,Gender="man",DeptId=1 },
        new User{Name="User6",Age=6,Gender="man",DeptId=2 },
        new User{Name="User7",Age=7,Gender="man",DeptId=2 },
        new User{Name="User8",Age=8,Gender="man",DeptId=2 },
        new User{Name="User9",Age=9,Gender="man",DeptId=2 },
        new User{Name="User10",Age=10,Gender="lady",DeptId=3 },
        new User{Name="User11",Age=11,Gender="lady",DeptId=3 },
        new User{Name="User12",Age=12,Gender="lady",DeptId=3 },
        new User{Name="User13",Age=13,Gender="lady",DeptId=3 },
        new User{Name="User14",Age=14,Gender="lady",DeptId=3 },
        new User{Name="User15",Age=15,Gender="lady",DeptId=3 }
    });

    await db.SaveChangesAsync();

    return Results.Ok();
});