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