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));
}
}
