使用EF.Functions.Contains()的单元测试方法

[TestMethod]
public void TestContainsFunction()
{
    // 准备测试环境
    using (var context = new YourDbContext())
    {
        // 初始化数据库
        context.Database.EnsureCreated();

        // 插入测试数据
        var data = new List<YourEntity>
        {
            new YourEntity { Id = 1, Name = "Apple" },
            new YourEntity { Id = 2, Name = "Banana" },
            new YourEntity { Id = 3, Name = "Orange" }
        };
        context.YourEntities.AddRange(data);
        context.SaveChanges();
    }

    // 编写测试方法
    using (var context = new YourDbContext())
    {
        // 创建查询
        var query = context.YourEntities.Where(e => EF.Functions.Contains(e.Name, "le"));

        // 执行查询
        var result = query.ToList();

        // 断言
        Assert.AreEqual(2, result.Count);
        Assert.IsTrue(result.Any(e => e.Name == "Apple"));
        Assert.IsTrue(result.Any(e => e.Name == "Orange"));
    }
}