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