如何在不使用EF的情况下在ASP.NET核心Web API中连接数据库？

using Microsoft.EntityFrameworkCore;

namespace YourNamespace.Data
{
    public class DatabaseContext : DbContext
    {
        public DatabaseContext(DbContextOptions<DatabaseContext> options) : base(options)
        {
        }

        // DbSet 属性用于表示数据库中的表
        // 例如：public DbSet<User> Users { get; set; }
    }
}

using Microsoft.EntityFrameworkCore;
using YourNamespace.Data;

public void ConfigureServices(IServiceCollection services)
{
    services.AddDbContext<DatabaseContext>(options =>
        options.UseSqlServer(Configuration.GetConnectionString("DefaultConnection")));
    
    // 其他服务配置...
}

{
  "ConnectionStrings": {
    "DefaultConnection": "Server=(localdb)\\mssqllocaldb;Database=YourDatabase;Trusted_Connection=True;MultipleActiveResultSets=true"
  },
  
  // 其他配置...
}

using Microsoft.AspNetCore.Mvc;
using YourNamespace.Data;
using System.Data.SqlClient;

namespace YourNamespace.Controllers
{
    [ApiController]
    [Route("api/[controller]")]
    public class UsersController : ControllerBase
    {
        private readonly DatabaseContext _context;

        public UsersController(DatabaseContext context)
        {
            _context = context;
        }

        [HttpGet]
        public IActionResult GetUsers()
        {
            using (SqlConnection connection = new SqlConnection(_context.Database.GetConnectionString()))
            {
                connection.Open();
                SqlCommand command = new SqlCommand("SELECT * FROM Users", connection);
                SqlDataReader reader = command.ExecuteReader();
                
                // 处理查询结果...
            }
            
            // 返回响应...
        }
        
        // 其他操作方法...
    }
}