public void SetGuidPrimaryKey()
{
GuidTest dataTest = new GuidTest();
dataTest.es.Connection.Name = "GuidTest";
switch (dataTest.es.Connection.ProviderMetadataKey)
{
case "esSqlCe":
case "esSqlCe4":
using (esTransactionScope scope = new esTransactionScope())
{
string testGuid = "b3883c65-ff94-47c4-8b0c-76896bedd45a";
dataTest = new GuidTest();
dataTest.es.Connection.Name = "GuidTest";
dataTest.GuidKey = new Guid(testGuid);
dataTest.Save();
Guid?tempKey = dataTest.GuidKey;
dataTest.MarkAsDeleted();
dataTest.Save();
Assert.AreEqual(testGuid, tempKey.Value.ToString());
}
break;
default:
Assert.Ignore("SqlCe only");
break;
}
}
public void GuidDynamicQuery()
{
GuidTestCollection dataTestColl = new GuidTestCollection();
dataTestColl.es.Connection.Name = "GuidTest";
GuidTest dataTest = new GuidTest();
dataTest.es.Connection.Name = "GuidTest";
switch (dataTest.es.Connection.ProviderMetadataKey)
{
case "esSqlCe":
case "esSqlCe4":
using (esTransactionScope scope = new esTransactionScope())
{
dataTest = new GuidTest();
dataTest.es.Connection.Name = "GuidTest";
dataTest.GuidKey = Guid.NewGuid();
dataTest.Save();
Guid tempKey = dataTest.GuidKey.Value;
dataTestColl = new GuidTestCollection();
dataTestColl.es.Connection.Name = "GuidTest";
dataTestColl.Query.Where(dataTestColl.Query.GuidKey == tempKey);
dataTestColl.Query.Load();
Assert.AreEqual(1, dataTestColl.Count);
dataTest = new GuidTest();
dataTest.es.Connection.Name = "GuidTest";
Assert.IsTrue(dataTest.LoadByPrimaryKey(tempKey));
dataTest.MarkAsDeleted();
dataTest.Save();
}
break;
default:
Assert.Ignore("SqlCe only");
break;
}
}