Smart.Mock.Data .NET - mock data library for .NET

What is this?

• ADO.NET mock library

Usage example

// ExecuteNonQuery
using (var con = new MockDbConnection())
{
    con.SetupCommand(cmd => cmd.SetupResult(1));

    var value = await con.ExecuteAsync("UPDATE Test SET NAME = 'UsaUsa' WHERE Id = 1234");

    Assert.Equal(1, value);
}

// ExecuteScalar
using (var con = new MockDbConnection())
{
    con.SetupCommand(cmd => cmd.SetupResult(1));

    var value = await con.ExecuteScalarAsync<int>("SELECT COUNT(*) FROM Test");

    Assert.Equal(1, value);
}

// ExecuteReader
using (var con = new MockDbConnection())
{
    var columns = new[]
    {
        new MockColumn(typeof(int), "Id"),
        new MockColumn(typeof(string), "Name")
    };
    var rows = new List<object[]>
    {
        new object[] { 1, "Employee1" },
        new object[] { 2, "Employee2" },
        new object[] { 3, "Employee3" }
    };
    con.SetupCommand(cmd => cmd.SetupResult(new MockDataReader(columns, rows)));

    var list = (await con.QueryAsync<Employee>("SELECT COUNT(*) FROM Employee")).ToList();

    Assert.Equal(3, list.Count);
}

// ExecuteReader from typed source
using (var con = new MockDbConnection())
{
    var entities = new List<Employee>
    {
        new() { Id = 1, Name = "Employee1" },
        new() { Id = 2, Name = "Employee2" },
        new() { Id = 3, Name = "Employee3" }
    };
    con.SetupCommand(cmd => cmd.SetupResult(MockHelper.CreateReader(entities)));

    var list = (await con.QueryAsync<Employee>("SELECT COUNT(*) FROM Employee")).ToList();

    Assert.Equal(3, list.Count);
}