public void AddsEntityToDatabase_ReturnsCompositeKey()
{
var m = new Multikey {
Key2 = "key", Value = "foo"
};
var key = Db.Insert(m).Result;
Assert.AreEqual(1, key.Key1);
Assert.AreEqual("key", key.Key2);
Dispose();
}
//[Ignore] // TODO add MultiKey support for oracle
public void UsingCompositeKey_DeletesFromDatabase()
{
Multikey m1 = new Multikey {
Key2 = "key", Value = "bar"
};
var key = Db.Insert(m1);
Multikey m2 = Db.Get <Multikey>(new { key.Key1, key.Key2 });
Db.Delete(m2);
Assert.IsNull(Db.Get <Multikey>(new { key.Key1, key.Key2 }));
Dispose();
}
public void UsingCompositeKey_ReturnsEntity()
{
var m1 = new Multikey {
Key2 = "key", Value = "bar"
};
var key = Db.Insert(m1).Result;
var m2 = Db.Get <Multikey>(new { key.Key1, key.Key2 }).Result;
Assert.AreEqual(1, m2.Key1);
Assert.AreEqual("key", m2.Key2);
Assert.AreEqual("bar", m2.Value);
Dispose();
}
public void UsingCompositeKey_DeletesFromDatabase()
{
var m1 = new Multikey {
Key2 = "key", Value = "bar"
};
var key = Db.Insert(m1).Result;
var m2 = Db.Get <Multikey>(new { key.Key1, key.Key2 }).Result;
var result = Db.Delete(m2).Result;
Assert.IsTrue(result);
var aux = Db.Get <Multikey>(new { key.Key1, key.Key2 });
aux.AsyncState.Should().BeNull();
Dispose();
}
public void UsingCompositeKey_UpdatesEntity()
{
var m1 = new Multikey {
Key2 = "key", Value = "bar"
};
var key = Db.Insert(m1).Result;
var m2 = Db.Get <Multikey>(new { key.Key1, key.Key2 }).Result;
m2.Key2 = "key";
m2.Value = "barz";
Db.Update(m2);
var m3 = Db.Get <Multikey>(new { Key1 = 1, Key2 = "key" }).Result;
Assert.AreEqual(1, m3.Key1);
Assert.AreEqual("key", m3.Key2);
Assert.AreEqual("barz", m3.Value);
Dispose();
}
