使用C#对SQL Server进行Web API post身份验证

public class User
{
    public string Username { get; set; }
    public string Password { get; set; }
}

public class ApplicationDbContext : DbContext
{
    public DbSet<User> Users { get; set; }

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        optionsBuilder.UseSqlServer("YourConnectionString"); // 替换为你的SQL Server连接字符串
    }
}

[Route("api/[controller]")]
[ApiController]
public class AuthenticationController : ControllerBase
{
    private readonly ApplicationDbContext _context;

    public AuthenticationController(ApplicationDbContext context)
    {
        _context = context;
    }

    [HttpPost]
    public IActionResult Authenticate(User user)
    {
        var authenticatedUser = _context.Users.FirstOrDefault(u => u.Username == user.Username && u.Password == user.Password);

        if (authenticatedUser != null)
        {
            return Ok("Authentication successful");
        }

        return Unauthorized("Invalid username or password");
    }
}

services.AddDbContext<ApplicationDbContext>(options =>
{
    options.UseSqlServer(Configuration.GetConnectionString("DefaultConnection"));
});

services.AddControllers();

app.UseRouting();

app.UseEndpoints(endpoints =>
{
    endpoints.MapControllers();
});