ef数据持久化笔记-3-ef基本使用（增删改查）

orm

对象-关系映射
o代表类 r代表关系 m代表类与关系的映射

首先引入数据库
查询

			using (rj1907Entities db = new rj1907Entities())
            {
                List<ruj907bf> girl1907s = db.ruj907bf.Where(o => o.bid.Contains("AB")).ToList();
                foreach (var item in girl1907s)
                {
                    Console.WriteLine(item.bid+" "+item.gid+" "+item.bName+" "+item.Likes);
                    Console.WriteLine(item.girl1907.nickName+" "+item.girl1907.introduce);
                    Console.WriteLine("-----------------------------------------------------");
                }
            }

添加

				girl1907 g = new girl1907();
                g.id = System.Guid.NewGuid().ToString("N");
                g.createDate = DateTime.Now;
                g.nickName = "伽罗";
                g.introduce = "太华";

                db.girl1907.Add(g);
                //将更改保存到数据库
                int rows = db.SaveChanges();
                Console.WriteLine(rows>0?"成功":"失败");

修改

				girl1907 girl1907 = db.girl1907.Where(o => o.nickName == "123").SingleOrDefault();

                girl1907.nickName = "花木兰";
                girl1907.introduce = "水晶猎龙者";
                int rows = db.SaveChanges();
                Console.WriteLine(rows>0?"成功":"失败");

删除

				girl1907 girl1907 = db.girl1907.Where(o => o.nickName == "伽罗").SingleOrDefault();
                db.girl1907.Remove(girl1907);
                int rows = db.SaveChanges();
                Console.WriteLine(rows>0?"成功":"失败");