public void TestUpdateFromModel()
{
var model = new TestUserTable {
Username = "******",
Rating = 1337
};
string sql = Query().Update("user").SetFrom(model).Where("id").Is(42).ToParameterizedSql();
sql.Should().Be("update user set username = @0, rating = @1 where id = @2");
}
public void TestInsertFromModel()
{
var model = new TestUserTable {
Username = "******",
Rating = 1337
};
string sql = Query().InsertInto("user").InsertFrom(model).ToParameterizedSql();
sql.Should().Be("insert into user (username, rating) values (@0, @1)");
}
public void TestInsertFromMultipleModels()
{
var model1 = new TestUserTable {
Username = "******",
Rating = 1337
};
var model2 = new TestUserTable {
Username = "******",
Rating = 42
};
string sql = Query().InsertInto("user").InsertFrom(model1, model2).ToParameterizedSql();
sql.Should().Be("insert into user (username, rating) values (@0, @1), (@2, @3)");
}
