如何在ASP.NET MVC中使用EntityFramework6.Npgsql从Postgres数据库中获取数据？

using System.Data.Entity;

public class ApplicationDbContext : DbContext
{
    public ApplicationDbContext() : base("name=DefaultConnection")
    {
    }

    public DbSet<YourModel> YourModels { get; set; }

    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        modelBuilder.HasDefaultSchema("public");
        base.OnModelCreating(modelBuilder);
    }
}

<connectionStrings>
    <add name="DefaultConnection" connectionString="Server=your_server;Port=your_port;Database=your_database;User Id=your_username;Password=your_password;" providerName="Npgsql" />
</connectionStrings>

public class YourModel
{
    public int Id { get; set; }
    public string Name { get; set; }
    // 其他属性...
}

public class HomeController : Controller
{
    private readonly ApplicationDbContext _context;

    public HomeController()
    {
        _context = new ApplicationDbContext();
    }

    public ActionResult Index()
    {
        var data = _context.YourModels.ToList();
        return View(data);
    }
}