private static void editTitle(int index)
{
Task.Run(() =>
{
try
{
Console.WriteLine("Start before " + index);
using (var trans = new System.Transactions.TransactionScope())
{
Console.WriteLine("Starting " + index);
using (var db = new IntelEntities())
{
var item = db.tContents.FirstOrDefault();
item.CNTitle = item.CNTitle + "|" + index;
db.SaveChanges();
Console.WriteLine("Saved " + index);
}
Thread.Sleep(200);
trans.Complete();
Console.WriteLine("Completed " + index);
}
}
catch (Exception ex)
{
Console.WriteLine("Error " + index + " " + ex.Message);
}
});
}
private static void editContent(int index)
{
try
{
Console.WriteLine("Start before " + index);
using (var trans = new System.Transactions.TransactionScope())
{
Console.WriteLine("Starting " + index);
using (var db = new IntelEntities())
{
var category = db.tCategories.FirstOrDefault();
category.IsMultiple = category.IsMultiple;
var item = db.tContents.FirstOrDefault();
item.CNTitle = item.CNTitle + "|" + index;
db.SaveChanges();
// db.SaveChanges和trans.Dispose() 中间会锁死数据库
Console.WriteLine("Saved " + index);
}
index++;
using (var db = new IntelEntities())
{
var item = db.tContents.OrderBy(s => s.ID).Skip(1).FirstOrDefault();
item.CNTitle = item.CNTitle + "|" + index;
db.SaveChanges();
Console.WriteLine("Saved " + index);
}
trans.Complete();
Console.WriteLine("Completed " + index);
}
}
catch (Exception ex)
{
Console.WriteLine("Error " + index + " " + ex.Message);
}
}
private static void addCategory(int index)
{
Task.Run(() =>
{
try
{
Console.WriteLine("Start before " + index);
using (var trans = new System.Transactions.TransactionScope())
{
Console.WriteLine("Starting " + index);
using (var db = new IntelEntities())
{
// 主-外键 添加1
tCategory category = new tCategory()
{
Code = "Code_" + index,
ContentType = 1,
DisplayName = "Name_" + index,
IsAdvanceSearch = true,
IsMultiple = true,
Position = 1,
Sort = 1
};
tCategoryItem item = new tCategoryItem()
{
CategoryID = category.ID,
Code = "Code_Item_" + index,
Sort = 1
};
db.tCategories.Add(category);
db.tCategoryItems.Add(item);
//// 主-外键 添加2
//tCategory category2 = new tCategory()
//{
// Code = "Code_" + index,
// ContentType = 1,
// DisplayName = "Name_" + index,
// IsAdvanceSearch = true,
// IsMultiple = true,
// Position = 1,
// Sort = 1
//};
//tCategoryItem item2 = new tCategoryItem()
//{
// Code = "Code_Item_" + index,
// Sort = 1,
// tCategory = category2
//};
//db.tCategoryItems.Add(item2);
tCategoryItem item2 = new tCategoryItem()
{
Code = "Code_Item_" + index,
Sort = 1
};
tCategory category2 = new tCategory()
{
Code = "Code_" + index,
ContentType = 1,
DisplayName = "Name_" + index,
IsAdvanceSearch = true,
IsMultiple = true,
Position = 1,
Sort = 1,
tCategoryItems = new List <tCategoryItem> {
item2
}
};
db.tCategories.Add(category2);
db.SaveChanges();
Console.WriteLine("Saved " + index);
}
Thread.Sleep(200);
trans.Complete();
trans.Dispose();
Console.WriteLine("Completed " + index);
}
}
catch (Exception ex)
{
Console.WriteLine("Error " + index + " " + ex.Message);
}
});
}