Ejemplo n.º 1
0
        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();
            }
        }