public void InsertCompositeKey()
{
const int dataKey1ID = 100;
const int dataKey2ID = 200;
const int dataKey3ID = 300;
const string dataTextData = "This is some text data.";
var dataDateCreated = DateTime.Now;
var poco = new CompositeObjectDecorated();
poco.Key1ID = dataKey1ID;
poco.Key2ID = dataKey2ID;
poco.Key3ID = dataKey3ID;
poco.TextData = dataTextData;
poco.DateEntered = dataDateCreated;
Database.Insert(poco);
var verify = Database.SingleOrDefault <CompositeObjectDecorated>(@"
SELECT *
FROM CompositeObjects
WHERE Key1ID = @0 AND Key2ID = @1 AND Key3ID = @2
", dataKey1ID, dataKey2ID, dataKey3ID);
Assert.IsNotNull(verify);
Assert.AreEqual(dataKey1ID, verify.Key1ID);
Assert.AreEqual(dataKey2ID, verify.Key2ID);
Assert.AreEqual(dataKey3ID, verify.Key3ID);
Assert.AreEqual(dataTextData, verify.TextData);
}
public void SaveCompositeKeyNewWithSingleOrDefaultById()
{
const int dataKey1ID = 100;
const int dataKey2ID = 200;
const int dataKey3ID = 300;
const string dataTextData = "This is some text data.";
var dataDateCreated = DateTime.Now;
var poco = new CompositeObjectDecorated();
poco.Key1ID = dataKey1ID;
poco.Key2ID = dataKey2ID;
poco.Key3ID = dataKey3ID;
poco.TextData = dataTextData;
poco.DateEntered = dataDateCreated;
Database.Save <CompositeObjectDecorated>(poco);
var verify = Database.SingleOrDefaultById <CompositeObjectDecorated>(poco);
Assert.IsNotNull(verify);
Assert.AreEqual(dataKey1ID, verify.Key1ID);
Assert.AreEqual(dataKey2ID, verify.Key2ID);
Assert.AreEqual(dataKey3ID, verify.Key3ID);
Assert.AreEqual(dataTextData, verify.TextData);
}
