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.GetLastInsertId(); db.Insert(row2); var row2LastInsertId = db.GetLastInsertId(); var insertedRow1 = db.GetById <ModelWithIdAndName1>(row1LastInsertId); var insertedRow2 = db.GetById <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.GetLastInsertId(); var insertedRow1 = db.GetById <ModelWithIdAndName1>(row1LastInsertId); Assert.That(insertedRow1.Name, Is.EqualTo(row1.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.GetLastInsertId(); var insertedRow1 = db.GetById<ModelWithIdAndName1>(row1LastInsertId); Assert.That(insertedRow1.Name, Is.EqualTo(row1.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.GetLastInsertId(); db.Insert(row2); var row2LastInsertId = db.GetLastInsertId(); var insertedRow1 = db.GetById<ModelWithIdAndName1>(row1LastInsertId); var insertedRow2 = db.GetById<ModelWithIdAndName1>(row2LastInsertId); Assert.That(insertedRow1.Name, Is.EqualTo(row1.Name)); Assert.That(insertedRow2.Name, Is.EqualTo(row2.Name)); } }