public async Task InsertGetUpdateDeleteWithExplicitKeyAsync()
{
using (var connection = GetOpenConnection())
{
var guid = Guid.NewGuid().ToString();
var o1 = new ObjectX {
ObjectXId = guid, Name = "Foo"
};
var originalxCount = (await connection.QueryAsync <int>("Select Count(*) From ObjectX").ConfigureAwait(false)).First();
await connection.InsertAsync(o1).ConfigureAwait(false);
var list1 = (await connection.QueryAsync <ObjectX>("select * from ObjectX").ConfigureAwait(false)).ToList();
list1.Count.IsEqualTo(originalxCount + 1);
o1 = await connection.GetAsync <ObjectX>(guid).ConfigureAwait(false);
o1.ObjectXId.IsEqualTo(guid);
o1.Name = "Bar";
await connection.UpdateAsync(o1).ConfigureAwait(false);
o1 = await connection.GetAsync <ObjectX>(guid).ConfigureAwait(false);
o1.Name.IsEqualTo("Bar");
await connection.DeleteAsync(o1).ConfigureAwait(false);
o1 = await connection.GetAsync <ObjectX>(guid).ConfigureAwait(false);
o1.IsNull();
const int id = 42;
var o2 = new ObjectY {
ObjectYId = id, Name = "Foo"
};
var originalyCount = connection.Query <int>("Select Count(*) From ObjectY").First();
await connection.InsertAsync(o2).ConfigureAwait(false);
var list2 = (await connection.QueryAsync <ObjectY>("select * from ObjectY").ConfigureAwait(false)).ToList();
list2.Count.IsEqualTo(originalyCount + 1);
o2 = await connection.GetAsync <ObjectY>(id).ConfigureAwait(false);
o2.ObjectYId.IsEqualTo(id);
o2.Name = "Bar";
await connection.UpdateAsync(o2).ConfigureAwait(false);
o2 = await connection.GetAsync <ObjectY>(id).ConfigureAwait(false);
o2.Name.IsEqualTo("Bar");
await connection.DeleteAsync(o2).ConfigureAwait(false);
o2 = await connection.GetAsync <ObjectY>(id).ConfigureAwait(false);
o2.IsNull();
}
}
public void InsertGetUpdateDeleteWithExplicitKey()
{
using (var connection = GetOpenConnection())
{
var guid = Guid.NewGuid().ToString();
var o1 = new ObjectX {
ObjectXId = guid, Name = "Foo"
};
var originalxCount = connection.Query <int>("Select Count(*) From ObjectX").First();
connection.Insert(o1);
var list1 = connection.Query <ObjectX>("select * from ObjectX").ToList();
list1.Count.IsEqualTo(originalxCount + 1);
o1 = connection.Get <ObjectX>(guid);
o1.ObjectXId.IsEqualTo(guid);
o1.Name = "Bar";
connection.Update(o1);
o1 = connection.Get <ObjectX>(guid);
o1.Name.IsEqualTo("Bar");
connection.Delete(o1);
o1 = connection.Get <ObjectX>(guid);
o1.IsNull();
const int id = 42;
var o2 = new ObjectY {
ObjectYId = id, Name = "Foo"
};
var originalyCount = connection.Query <int>("Select Count(*) From ObjectY").First();
connection.Insert(o2);
var list2 = connection.Query <ObjectY>("select * from ObjectY").ToList();
list2.Count.IsEqualTo(originalyCount + 1);
o2 = connection.Get <ObjectY>(id);
o2.ObjectYId.IsEqualTo(id);
o2.Name = "Bar";
connection.Update(o2);
o2 = connection.Get <ObjectY>(id);
o2.Name.IsEqualTo("Bar");
connection.Delete(o2);
o2 = connection.Get <ObjectY>(id);
o2.IsNull();
}
}
public async Task InsertGetUpdateDeleteWithExplicitKeyAsync()
{
using (var connection = GetOpenConnection())
{
var guid = Guid.NewGuid().ToString();
var o1 = new ObjectX { ObjectXId = guid, Name = "Foo" };
var originalxCount = (await connection.QueryAsync<int>("Select Count(*) From objectx")).First();
await connection.InsertAsync(o1);
var list1 = (await connection.QueryAsync<ObjectX>("select * from objectx")).ToList();
list1.Count.IsEqualTo(originalxCount + 1);
o1 = await connection.GetAsync<ObjectX>(guid);
o1.ObjectXId.IsEqualTo(guid);
o1.Name = "Bar";
await connection.UpdateAsync(o1);
o1 = await connection.GetAsync<ObjectX>(guid);
o1.Name.IsEqualTo("Bar");
await connection.DeleteAsync(o1);
o1 = await connection.GetAsync<ObjectX>(guid);
o1.IsNull();
const int id = 42;
var o2 = new ObjectY { ObjectYId = id, Name = "Foo" };
var originalyCount = connection.Query<int>("Select Count(*) From objecty").First();
await connection.InsertAsync(o2);
var list2 = (await connection.QueryAsync<ObjectY>("select * from objecty")).ToList();
list2.Count.IsEqualTo(originalyCount+1);
o2 = await connection.GetAsync<ObjectY>(id);
o2.ObjectYId.IsEqualTo(id);
o2.Name = "Bar";
await connection.UpdateAsync(o2);
o2 = await connection.GetAsync<ObjectY>(id);
o2.Name.IsEqualTo("Bar");
await connection.DeleteAsync(o2);
o2 = await connection.GetAsync<ObjectY>(id);
o2.IsNull();
}
}