static void Example05()
{
Table <AccessTab> tabs = db.GetTable <AccessTab>();
AccessTab aTab = tabs.FirstOrDefault(f => f.intTabID == 1);
aTab.StrDescription = "Test 005";
Table <AccessUser> accessUsers = db.GetTable <AccessUser>();
AccessUser aUser = accessUsers.FirstOrDefault(f => f.intAccessId == 6822);
aUser.dCreated = DateTime.Now;
//aUser.intTabID
try
{
using (System.Transactions.TransactionScope scope =
new System.Transactions.TransactionScope())
{
db.SubmitChanges();
scope.Complete();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
db.Refresh(RefreshMode.OverwriteCurrentValues, tabs);
Console.WriteLine("StrDescription: {0}", aTab.StrDescription);
db.Refresh(RefreshMode.OverwriteCurrentValues, accessUsers);
Console.WriteLine("dCreated: {0}", aUser.dCreated);
}
}
static void Exampl01()
{
try
{
db.CommandTimeout = 30;
Table <AccessTab> accessTables = db.GetTable <AccessTab>();
AccessTab tab = accessTables.FirstOrDefault(f => f.intTabID == 56);
tab.StrDescription = "some descr";
db.SubmitChanges(ConflictMode.FailOnFirstConflict);
}
catch (ChangeConflictException ex)
{
Console.WriteLine(ex.Message);
foreach (ObjectChangeConflict item in db.ChangeConflicts)
{
MetaTable metatab = db.Mapping.GetTable(item.Object.GetType());
AdoNetModule_05_LinkToSql.AccessTab en = (AdoNetModule_05_LinkToSql.AccessTab)item.Object;
Console.WriteLine("Table name {0}: " + metatab.TableName);
}
}
//foreach(AccessTab tab in accessTables)
//{
// Console.WriteLine("Tab Name: " + tab.StrTabName);
//}
}
static void Example04(MCSModel1 dataContext)
{
Table <AccessTab> tabs = dataContext.GetTable <AccessTab>();
Table <AccessUser> users = dataContext.GetTable <AccessUser>();
db.Refresh(RefreshMode.KeepChanges);
AccessTab a = tabs.OrderBy(o => o.StrTabName).First(f => f.intTabID == 56);
}