EF增删改查

来源：互联网发布：手机视频制作软件排名编辑：程序博客网时间：2024/04/27 15:34
static void Main(string[] args)        {            using (DBEntities ef = new DBEntities())            {                //========ef查询==============                var l = from a in ef.aa                        where a.Id == 35                        select a;                foreach (var i in l)                {                    Console.WriteLine("id:{0},name:{1}", i.Id, i.name);                }                //========ef添加==============                var j = new aa                {                    name = "测试ok!"                };                ef.aa.AddObject(j);                int num = ef.SaveChanges();                Console.WriteLine("受影响的行数为 {0}", num);                //========ef删除==============                var jj = ef.aa.Single(xx => xx.Id == 38);                ef.aa.Attach(jj);                ef.aa.DeleteObject(jj);                ef.SaveChanges();                //========ef修改==============                var result = ef.aa.Single(x => x.name == "bbs");                result.name = "hhhhhhhhhhhhhhhhh";                ef.SaveChanges();                                         }        }