如何使用Entitity Framework Core为sqlite编写代码优先单元测试？

// 实体类
public class Product
{
    public int Id { get; set; }
    public string Name { get; set; }
    public decimal Price { get; set; }
}

// DbContext类
public class AppDbContext : DbContext
{
    public DbSet<Product> Products { get; set; }

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

// 单元测试类
[TestClass]
public class ProductTests
{
    [TestMethod]
    public void AddProduct_ShouldAddProductToDatabase()
    {
        // 使用InMemoryDatabase提供程序创建内存数据库
        var options = new DbContextOptionsBuilder<AppDbContext>()
            .UseInMemoryDatabase(databaseName: "TestDatabase")
            .Options;

        using (var context = new AppDbContext(options))
        {
            // 创建一个新的产品
            var product = new Product { Name = "Test Product", Price = 9.99m };

            // 添加产品到数据库
            context.Products.Add(product);
            context.SaveChanges();
        }

        using (var context = new AppDbContext(options))
        {
            // 从数据库中获取产品
            var savedProduct = context.Products.FirstOrDefault(p => p.Name == "Test Product");

            // 验证产品是否成功添加到数据库
            Assert.IsNotNull(savedProduct);
            Assert.AreEqual("Test Product", savedProduct.Name);
            Assert.AreEqual(9.99m, savedProduct.Price);
        }
    }
}