dotnetcms数据库

using Microsoft.AspNetCore.Mvc;
using System.Data.SqlClient;
using System.Threading.Tasks;

namespace DotNetCms.Controllers
{
    public class HomeController : Controller
    {
        private readonly string _connectionString = "YourConnectionStringHere";

        public async Task<IActionResult> Index()
        {
            using (var connection = new SqlConnection(_connectionString))
            {
                await connection.OpenAsync();
                var query = "SELECT * FROM YourTable";
                using (var command = new SqlCommand(query, connection))
                {
                    using (var reader = await command.ExecuteReaderAsync())
                    {
                        while (await reader.ReadAsync())
                        {
                            // Process the data
                        }
                    }
                }
            }
            return View();
        }
    }
}