static void Main(string[] args)
{
//使用数据上下文进行数据操作，using表示上下文代码的范围，执行完成后内存会自动释放
using (var context = new CourseContext())
{
//.where .orderby .tolist() 注意调用的顺序
var departments = context.Departm201ents.OrderBy(n => n.SortCode).ToList();
foreach (var d in departments)
{
Console.WriteLine("编号{0},部门名称{1},说明{2}", d.SortCode, d.Name, d.Dscn);
}
//Console.WriteLine("修改记录");
//Console.WriteLine("================================");
////修改
//var editDepartment = context.Departments.SingleOrDefault(x => x.Name == "环境与食品检测学院");
//if (editDepartment != null)
//{
// editDepartment.Name = "环境与食品检测学院";
// editDepartment.SortCode = "007";
// context.SaveChanges();
//}
//else
// Console.WriteLine("未找到该记录，不能修改");
//Console.WriteLine("删除记录");
//Console.WriteLine("================================");
////find--用主键查询实体
////var delDept = context.Departments.Find(Guid.Parse("1fc54ff7-b598-459a-be5c-47effd4b9454"));
//var id = Guid.Parse("1794b626-b88c-453f-8ea8-e221fd47e341");
//var delDept = context.Departments.SingleOrDefault(x => x.ID == id);
//context.Departments.Remove(delDept);
//context.SaveChanges();
//var departments1 = context.Departments.OrderBy(n => n.SortCode).ToList();
//foreach (var d in departments1)
// Console.WriteLine("编号{0},部门名称{1},说明{2}", d.SortCode, d.Name, d.Dscn);
Console.WriteLine("添加记录");
Console.WriteLine("================================");
var newDept = new Departments
{
ID = Guid.NewGuid(),
Name = "测试学院",
Dscn = "不可乱来",
SortCode = "888"
};
context.Departments.Add(newDept);
context.SaveChanges();
var departments1 = context.Departments.OrderBy(n => n.SortCode).ToList();
foreach (var d in departments1)
{
Console.WriteLine("编号{0},部门名称{1},说明{2}", d.SortCode, d.Name, d.Dscn);
}
Console.ReadKey();
}
}
