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