static void Example_02()
{
try
{
Table<AccessTab> accesTAbles = db.GetTable<AccessTab>();
AccessTab tab = accesTAbles.FirstOrDefault(f => f.intTabID == 56);
tab.StrDescription = "Best New Description by Best";
db.SubmitChanges(ConflictMode.FailOnFirstConflict);
// Console.WriteLine();
//foreach (AccessTab tab in accesTAbles)
//{
// Console.WriteLine("Tab Name : {0}", tab.StrTabName);
//}
}
catch (ChangeConflictException ex)
{
Console.WriteLine(ex.Message);
foreach (ObjectChangeConflict item in db.ChangeConflicts)
{
MetaTable metatable = db.Mapping.GetTable(item.Object.GetType());
AccessTab en = (AccessTab)item.Object;
Console.WriteLine("TABLE name : {0}", metatable.TableName);
}
}
}
static void Example_05(MCSModel dataContext)
{
Table<AccessTab> tabs = dataContext.GetTable<AccessTab>();
Table<AccessUser> users= dataContext.GetTable<AccessUser>();
db.Refresh(RefreshMode.OverwriteCurrentValues);
AccessTab a = tabs.OrderBy(o => o.StrTabName).First(f=>f.intTabID==56);
}
//Исользуем транзакциями
static void Example_06()
{
Table<AccessTab> accessTabs = db.GetTable<AccessTab>();
AccessTab aTab = accessTabs.FirstOrDefault(f => f.intTabID == 2);
aTab.StrDescription = "Best Test 000";
Table<AccessUser> accessUsers = db.GetTable<AccessUser>();
AccessUser aUser = accessUsers.FirstOrDefault(f => f.intAccessID == 6822);
aUser.dCreated = DateTime.Now;
aUser.intTabID = 2;
try
{
using (TransactionScope scope =
new TransactionScope())
{
db.SubmitChanges();
scope.Complete();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
db.Refresh(RefreshMode.OverwriteCurrentValues,accessTabs);
Console.WriteLine("StrDesciption : {0}",aTab.StrDescription);
db.Refresh(RefreshMode.OverwriteCurrentValues, accessUsers);
Console.WriteLine("dCreated : {0}", aUser.dCreated);
}
}
static void Example5(MCSModel dataContext)
{
Table <AccessTab> tabs = dataContext.GetTable <AccessTab>();
Table <AccessUser> users = dataContext.GetTable <AccessUser>();
AccessTab a = tabs.OrderBy(o => o.strTabName).First(f => f.intTabID == 56);
}
static void Example2()
{
try
{
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 metatable = db.Mapping.GetTable(item.Object.GetType());
Model.AccessTab en = (Model.AccessTab)item.Object;
Console.WriteLine("Table Name {0}:", metatable.TableName);
}
}
//foreach (AccessTab tab in accessTables)
//{
// Console.WriteLine("Tab Name:" + tab.strTabName);
//}
}
public static void addExpl02(AccessTab tab)
{
Console.WriteLine(tab.strTabName);
foreach (var user in tab.AccessUser)
{
Console.WriteLine("\t--> " + user.intUserId);
}
}
private static void addExmpl02(AccessTab tab)
{
Console.WriteLine(tab.strTabName);
//foreach (var user in tab.AccessUser)
//{
// Console.WriteLine("\t--> " + user.intUserId);
//}
}
private static void addExample02(AccessTab tab)
{
Console.WriteLine(tab.TabName);
foreach (var user in tab.AccessUsers)
{
Console.WriteLine("\t-->" + user.UserId);
}
}
//Явная загрузка explicit loading
public static void Exmpl02()
{
mcs db = new mcs();
//Загрузка одной вкладки
AccessTab tab = db.AccessTab.Where(w => w.TabId == 1).FirstOrDefault();
//Загрузка связанных данных с этой вкладкой
//db.Entry(tab).Collection(c => c.AccessUsers).Load();
addExample02(tab);
//Console.WriteLine(tab.TabName);
//foreach (var user in tab.AccessUsers)
//{
// Console.WriteLine("\t-->" + user.UserId);
//}
}
//Явная загрузка (точечная загрузка, удобна когда связь медленная)
public static void Expl02()
{
MCS db = new MCS();
//Загрузка одной вкладки
AccessTab tab =
db.AccessTab.Where(w => w.intTabID == 1).FirstOrDefault();
addExpl02(tab);
//Загрузка связанные данные с этой вкладки
// db.Entry(tab).Collection(c => c.AccessUser).Load();
//Console.WriteLine(tab.strTabName);
//foreach (var user in tab.AccessUser)
//{
// Console.WriteLine("\t--> " + user.intUserId);
//}
}
private void ErButton_Click(object sender, RoutedEventArgs e)
{
using (SqlConnection con = new SqlConnection(_connString))
{
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "Select * form AccessTab";
SqlDataReader rdr = cmd.ExecuteReader();
List <AccessTab> accessTabs = new List <AccessTab>;
while (rdr.Read())
{
AccessTab accessTab = new AccessTab();
accessTab.intTabID = Int32.Parse(rdr[0].ToString());
accessTab.strTabName = rdr[1].ToString();
accessTabs.Add(accessTab);
}
AccessTabListView.ItemsSource = accessTabs;
}
}
