public void InsertUniqueIdentifier() { using (var db = GetSqlDatabase()) { var p = new PersonUniqueIdentifier { GuidId = Guid.NewGuid(), FirstName = "Alice", LastName = "Jones" }; Assert.True(db.Insert(p)); var gp = db.Get <PersonUniqueIdentifier>(p.GuidId); Assert.Equal(p.FirstName, gp.FirstName); Assert.Equal(p.LastName, gp.LastName); } }
public async Task InsertUniqueIdentifierAsync() { using (var connection = GetSqlDatabase()) { var p = new PersonUniqueIdentifier { GuidId = Guid.NewGuid(), FirstName = "Alice", LastName = "Jones" }; Assert.True(await connection.InsertAsync(p)); var gp = await connection.GetAsync <PersonUniqueIdentifier>(p.GuidId); Assert.Equal(p.FirstName, gp.FirstName); Assert.Equal(p.LastName, gp.LastName); } }
public void DeleteUniqueIdentifier() { using (var db = GetSqlDatabase()) { var p = new PersonUniqueIdentifier { GuidId = Guid.NewGuid(), FirstName = "Alice", LastName = "Jones" }; Assert.True(db.Insert(p)); Assert.True(db.Delete <PersonIdentity>(p.GuidId)); var gp = db.Get(p); Assert.Null(gp); } }
public async Task DeleteUniqueIdentifierAsync() { using (var connection = GetSqlDatabase()) { var p = new PersonUniqueIdentifier { GuidId = Guid.NewGuid(), FirstName = "Alice", LastName = "Jones" }; Assert.True(await connection.InsertAsync(p)); Assert.True(await connection.DeleteAsync <PersonIdentity>(p.GuidId)); var gp = await connection.GetAsync(p); Assert.Null(gp); } }