public void SavePerson()
{
var p4 = new PersonIf(4, "武田晴信", new DateTime(1521, 12, 1), 165.47M, 73M, false, "風林火山");
using (var t1 = _db.CreateTran()) {
Assert.That(t1.Save(p4), Is.EqualTo(1));
Assert.That(t1.LastExecutedSql,
Is.EqualTo("INSERT INTO Persons(id,name,birthDay,height,weight,isDaimyou,remarks) " +
"VALUES(4," + N + "'武田晴信','1521-12-01',165.47,73,0," + N + "'風林火山')"));
}
}
public void SavePersonWithPlaceholders()
{
var p4 = new PersonIf(4, "武田晴信", new DateTime(1521, 12, 1), 165.47M, 73M, false, "風林火山");
var ph = new Dictionary <string, string>()
{
{ "Remarks", N + "'人が石垣人が城'" }
};
using (var t1 = _db.CreateTran()) {
// プレースホルダで指定した値が最優先される
Assert.That(t1.Save(p4, ph), Is.EqualTo(1));
Assert.That(t1.LastExecutedSql,
Is.EqualTo("INSERT INTO Persons(id,name,birthDay,height,weight,isDaimyou,remarks) " +
"VALUES(4," + N + "'武田晴信','1521-12-01',165.47,73,0," + N + "'人が石垣人が城')"));
}
}
