如何使用Entity Framework6从.Net应用程序访问雪花数据库

Install-Package EntityFramework -Version 6.4.4

public class Customer
{
    public int Id { get; set; }
    public string Name { get; set; }
    public string Email { get; set; }
}

<connectionStrings>
    <add name="MyDbContext" connectionString="Data Source=your_server;Initial Catalog=your_database;User ID=your_username;Password=your_password;" providerName="System.Data.SqlClient" />
</connectionStrings>

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

    public DbSet<Customer> Customers { get; set; }
}

using (var context = new MyDbContext())
{
    // 查询所有顾客
    var customers = context.Customers.ToList();

    // 添加新顾客
    var newCustomer = new Customer { Name = "John Doe", Email = "john.doe@example.com" };
    context.Customers.Add(newCustomer);
    context.SaveChanges();

    // 更新顾客信息
    var customerToUpdate = context.Customers.FirstOrDefault(c => c.Id == 1);
    if (customerToUpdate != null)
    {
        customerToUpdate.Name = "Updated Name";
        context.SaveChanges();
    }

    // 删除顾客
    var customerToDelete = context.Customers.FirstOrDefault(c => c.Id == 2);
    if (customerToDelete != null)
    {
        context.Customers.Remove(customerToDelete);
        context.SaveChanges();
    }
}