public void Can_retrieve_LastInsertId_from_inserted_table()
{
using (var db = OpenDbConnection())
{
db.CreateTable <ModelWithIdAndName1>(true);
var row1 = new ModelWithIdAndName1()
{
Name = "A", Id = 4
};
var row2 = new ModelWithIdAndName1()
{
Name = "B", Id = 5
};
var row1LastInsertId = db.Insert(row1, selectIdentity: true);
Assert.That(db.GetLastSql(), Does.Match("\\) RETURNING \"?[Ii]d"));
var row2LastInsertId = db.Insert(row2, selectIdentity: true);
Assert.That(db.GetLastSql(), Does.Match("\\) RETURNING \"?[Ii]d"));
var insertedRow1 = db.SingleById <ModelWithIdAndName1>(row1LastInsertId);
var insertedRow2 = db.SingleById <ModelWithIdAndName1>(row2LastInsertId);
Assert.That(insertedRow1.Name, Is.EqualTo(row1.Name));
Assert.That(insertedRow2.Name, Is.EqualTo(row2.Name));
}
}
public void Can_insert_single_quote()
{
using (var db = OpenDbConnection())
{
db.CreateTable <ModelWithIdAndName1>(true);
var row1 = new ModelWithIdAndName1()
{
Name = @"'", Id = 55
};
db.Insert(row1);
var row1LastInsertId = db.LastInsertId();
var insertedRow1 = db.SingleById <ModelWithIdAndName1>(row1LastInsertId);
Assert.That(insertedRow1.Name, Is.EqualTo(row1.Name));
}
}
