Program.cs

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

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

using Microsoft.AspNetCore.Mvc;
using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.Configuration;
using postgres1;

var builder = WebApplication.CreateBuilder(args);

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

builder.Services.AddDbContext<BloggingContext>(options =>
           options.UseNpgsql("Host=localhost;Database=BlogDB;Username=51aspx;Password=51aspx"));

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("/initial", async (BloggingContext db) =>
{
    await db.Blogs.AddRangeAsync(new Blog[]
    {
        new Blog{
            Url = "http://blogs.msdn.com/p1",
            Posts=new List<Post>{ new Post { Title = "Hello World1", Content = "C# EFCore Postgresql1" } } },
        new Blog{
            Url = "http://blogs.msdn.com/p2",
            Posts=new List<Post>{ new Post { Title = "Hello World2", Content = "C# EFCore Postgresql2" } } },
        new Blog{
            Url = "http://blogs.msdn.com/p3",
            Posts=new List<Post>{ new Post { Title = "Hello World3", Content = "C# EFCore Postgresql3" } } },
        new Blog{
            Url = "http://blogs.msdn.com/p4",
            Posts=new List<Post>{ new Post { Title = "Hello World4", Content = "C# EFCore Postgresql14" } } },
        new Blog{
            Url = "http://blogs.msdn.com/p5",
            Posts=new List<Post>{ new Post { Title = "Hello World5", Content = "C# EFCore Postgresql5" } } }
    });
    await db.SaveChangesAsync();
    return Results.Ok();

});

app.MapGet("/posts/{id}", async (BloggingContext db, [FromQuery] int id) => await db.Posts.FindAsync(id));
app.MapGet("/blog/{id}", async (BloggingContext db, [FromQuery] int id) => await db.Blogs.FindAsync(id));


app.MapGet("/blogs", async (BloggingContext db) => await db.Blogs.ToListAsync());
app.MapGet("/posts", async (BloggingContext db) => await db.Posts.ToListAsync());
app.MapGet("/posts/Paginations", async (BloggingContext db, int pageSize, int pageNum) =>
{
    int totalPages =await  db.Posts.CountAsync() / pageSize + 1;