public async Task Does_populate_and_return_new_guid_on_insert_Async() { using var db = await OpenDbConnectionAsync(); db.DropAndCreateTable <GuidAutoId>(); var guidA = new GuidAutoId { Name = "A" }; var guidB = new GuidAutoId { Name = "B" }; await db.InsertAsync(guidA); await db.InsertAsync(guidB); Assert.That(guidA.Id, Is.Not.EqualTo(Guid.Empty)); Assert.That(guidB.Id, Is.Not.EqualTo(Guid.Empty)); Assert.That(guidA.Id, Is.Not.EqualTo(guidB)); var dbA = await db.SingleByIdAsync <GuidAutoId>(guidA.Id); Assert.That(dbA.Name, Is.EqualTo(guidA.Name)); var dbB = await db.SingleByIdAsync <GuidAutoId>(guidB.Id); Assert.That(dbB.Name, Is.EqualTo(guidB.Name)); }
public void Does_populate_and_return_new_guid_on_insert_ObjectDictionary() { using var db = OpenDbConnection(); db.DropAndCreateTable <GuidAutoId>(); var guidA = new GuidAutoId { Name = "A" }.ToObjectDictionary(); var guidB = new GuidAutoId { Name = "B" }.ToObjectDictionary(); db.Insert <GuidAutoId>(guidA); db.Insert <GuidAutoId>(guidB, selectIdentity: true); Assert.That(guidA[nameof(GuidAutoId.Id)], Is.Not.EqualTo(Guid.Empty)); Assert.That(guidB[nameof(GuidAutoId.Id)], Is.Not.EqualTo(Guid.Empty)); Assert.That(guidA[nameof(GuidAutoId.Id)], Is.Not.EqualTo(guidB)); var dbA = db.SingleById <GuidAutoId>(guidA[nameof(GuidAutoId.Id)]); Assert.That(dbA.Name, Is.EqualTo(guidA[nameof(GuidAutoId.Name)])); var dbB = db.SingleById <GuidAutoId>(guidB[nameof(GuidAutoId.Id)]); Assert.That(dbB.Name, Is.EqualTo(guidB[nameof(GuidAutoId.Name)])); }
public void Does_populate_and_return_new_guid_on_insert() { using var db = OpenDbConnection(); db.DropAndCreateTable <GuidAutoId>(); var guidA = new GuidAutoId { Name = "A" }; var guidB = new GuidAutoId { Name = "B" }; db.Insert(guidA); db.Insert(guidB); Assert.That(guidA.Id, Is.Not.EqualTo(Guid.Empty)); Assert.That(guidB.Id, Is.Not.EqualTo(Guid.Empty)); Assert.That(guidA.Id, Is.Not.EqualTo(guidB)); var dbA = db.SingleById <GuidAutoId>(guidA.Id); Assert.That(dbA.Name, Is.EqualTo(guidA.Name)); var dbB = db.SingleById <GuidAutoId>(guidB.Id); Assert.That(dbB.Name, Is.EqualTo(guidB.Name)); }
public async Task Does_populate_and_return_existing_guid_on_insert_ObjectDictionary_Async() { using var db = await OpenDbConnectionAsync(); db.DropAndCreateTable <GuidAutoId>(); var aGuid = Guid.NewGuid(); var bGuid = Guid.NewGuid(); var guidA = new GuidAutoId { Id = aGuid, Name = "A" }.ToObjectDictionary(); var guidB = new GuidAutoId { Id = bGuid, Name = "B" }.ToObjectDictionary(); await db.InsertAsync <GuidAutoId>(guidA); await db.InsertAsync <GuidAutoId>(guidB, selectIdentity : true); Assert.That(guidA[nameof(GuidAutoId.Id)], Is.EqualTo(aGuid)); Assert.That(guidB[nameof(GuidAutoId.Id)], Is.EqualTo(bGuid)); Assert.That(guidA[nameof(GuidAutoId.Id)], Is.Not.EqualTo(guidB)); var dbA = await db.SingleByIdAsync <GuidAutoId>(guidA[nameof(GuidAutoId.Id)]); Assert.That(dbA.Name, Is.EqualTo(guidA[nameof(GuidAutoId.Name)])); var dbB = await db.SingleByIdAsync <GuidAutoId>(guidB[nameof(GuidAutoId.Id)]); Assert.That(dbB.Name, Is.EqualTo(guidB[nameof(GuidAutoId.Name)])); }
public async Task Does_populate_and_return_new_guid_on_save_Async() { using (var db = OpenDbConnection()) { db.DropAndCreateTable <GuidAutoId>(); var guidA = new GuidAutoId { Name = "A" }; var guidB = new GuidAutoId { Name = "B" }; await db.SaveAsync(guidA); await db.SaveAsync(guidB); Assert.That(guidA.Id, Is.Not.EqualTo(new Guid())); Assert.That(guidB.Id, Is.Not.EqualTo(new Guid())); Assert.That(guidA.Id, Is.Not.EqualTo(guidB)); var dbA = await db.SingleByIdAsync <GuidAutoId>(guidA.Id); Assert.That(dbA.Name, Is.EqualTo(guidA.Name)); var dbB = await db.SingleByIdAsync <GuidAutoId>(guidB.Id); Assert.That(dbB.Name, Is.EqualTo(guidB.Name)); } }
public void Uses_existing_Guid_Id_if_not_Empty() { using var db = OpenDbConnection(); db.DropAndCreateTable <GuidAutoId>(); var existingGuid = Guid.NewGuid(); var guidA = new GuidAutoId { Id = existingGuid, Name = "A" }; db.Insert(guidA); Assert.That(guidA.Id, Is.EqualTo(existingGuid)); var fromDb = db.SingleById <GuidAutoId>(existingGuid); Assert.That(fromDb.Id, Is.EqualTo(existingGuid)); }
public void Uses_existing_Guid_Id_if_not_Empty_for_row_inserts() { using (var db = OpenDbConnection()) { db.DropAndCreateTable<GuidAutoId>(); var existingGuid = Guid.NewGuid(); var guidA = new GuidAutoId { Id = existingGuid, Name = "A" }; db.Exec(cmd => { cmd.CommandText = db.GetDialectProvider().ToInsertRowStatement(cmd, guidA); db.GetDialectProvider().SetParameterValues<GuidAutoId>(cmd, guidA); cmd.ExecuteNonQuery(); }); var fromDb = db.SingleById<GuidAutoId>(existingGuid); Assert.That(fromDb.Id, Is.EqualTo(existingGuid)); } }