使用Entity Framework Core将sqlite数据导出到csv

using System;
using System.IO;
using System.Linq;
using CsvHelper;
using Microsoft.EntityFrameworkCore;

// 定义SQLite数据表的实体类
public class Person
{
    public int Id { get; set; }
    public string Name { get; set; }
    public int Age { get; set; }
}

// 定义数据库上下文类
public class MyDbContext : DbContext
{
    public DbSet<Person> People { get; set; }

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        optionsBuilder.UseSqlite("Data Source=people.db");
    }
}

public class Program
{
    public static void Main()
    {
        // 创建数据库和表
        using (var context = new MyDbContext())
        {
            context.Database.EnsureCreated();
        }

        // 查询数据并导出为CSV
        using (var context = new MyDbContext())
        {
            var people = context.People.ToList();

            using (var writer = new StreamWriter("people.csv"))
            using (var csv = new CsvWriter(writer))
            {
                csv.WriteRecords(people);
            }
        }

        Console.WriteLine("数据已成功导出到people.csv文件。");
    }
}