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 }; db.Insert(row1); var row1LastInsertId = db.LastInsertId(); db.Insert(row2); var row2LastInsertId = db.LastInsertId(); 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_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 }; db.Insert(row1); var row1LastInsertId = db.LastInsertId(); db.Insert(row2); var row2LastInsertId = db.LastInsertId(); 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)); } }