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