如何在C#测试用例中添加模拟数据库表

using NUnit.Framework;
using Moq;

[TestFixture]
public class DatabaseTests
{
    [Test]
    public void TestGetUserById()
    {
        // 创建模拟的数据库表对象
        var mockTable = new Mock<IDatabaseTable>();

        // 设置模拟数据库表的行为和返回值
        mockTable.Setup(table => table.GetUserById(1))
            .Returns(new User { Id = 1, Name = "John" });

        // 创建被测试的对象
        var userRepository = new UserRepository(mockTable.Object);

        // 调用被测试的方法
        var user = userRepository.GetUserById(1);

        // 断言预期的结果与实际结果是否一致
        Assert.AreEqual(1, user.Id);
        Assert.AreEqual("John", user.Name);
    }
}

// 模拟的数据库表接口
public interface IDatabaseTable
{
    User GetUserById(int id);
}

// 用户实体类
public class User
{
    public int Id { get; set; }
    public string Name { get; set; }
}

// 用户仓库类
public class UserRepository
{
    private readonly IDatabaseTable _table;

    public UserRepository(IDatabaseTable table)
    {
        _table = table;
    }

    public User GetUserById(int id)
    {
        return _table.GetUserById(id);
    }
}