ASP.NET中实体数据库模型的增删改查的用法。

                   using (CSEntities ce = new CSEntities())
                    {
                        ///查找///
                        var login = ce.Admins.Select(p => new {p.Admin_ID,p.Area_ID,p.Addtime,p.State}).Where(p=>p.State=="可用"&&p.Admin_ID==8).ToList();
                        //模糊查询
                        var login = ce.Addresses.Select(p => new { p.Name, p.Phone, p.Area_ID }).Where(a => a.Area_ID == 1 && a.Phone.Contains("138")).ToList();
                       //多表查询
                            //var p_id = Convert.ToInt32(context.Request["id"]);
                            var p_id = 111;
                            int i = 0;
                            var list = ce.Order_Goods.Where(p => p.P_ID == p_id).ToList().Select(p => new
                            {
                                xuhao = ++i,
                                p.Product.Product_Name,
                                p.Product.Guige,
                                p.Product_Num,
                                p.Product.Price,
                                zhongliang = p.Product_Num * p.Product.zhongliang
                            });
                            var porder = ce.Porders.Where(p => p.P_ID == p_id).Select(p => new
                            {
                                ShouhuoName = p.User.Addresses.FirstOrDefault(a => a.IsDefault == true).Name,
                                p.User.Yewu.name,
                                p.Price,
                                p.porder_no,
                                p.orderStatus,
                                p.payStatus,
                                p.deliveryStatus,
                                YewuPhone = p.User.Yewu.phone,
                                UserPhone = p.User.Addresses.FirstOrDefault(a => a.IsDefault == true).Phone,
                                p.User.Addresses.FirstOrDefault(a => a.IsDefault == true).Address1,
                               //p.Siji.Area.Area_Name,
                              
                                FuWuPhone = ce.System_Setting.FirstOrDefault().tel


                            });
                            JObject jo = new JObject();
                            JProperty head = new JProperty("head", JsonConvert.DeserializeObject(JsonConvert.SerializeObject(porder)));
                            jo.Add(head);
                            JProperty body = new JProperty("body", JsonConvert.DeserializeObject(JsonConvert.SerializeObject(list)));
                            jo.Add(body);
                            context.Response.Write(jo);
                        }
                        ///修改
                       var login = ce.Admins.FirstOrDefault(p => p.Admin_ID == 20 && p.State == "可用");
                        ogin.State = "不可用";
                        int s = ce.SaveChanges();
                        ///增加
                        string ss = context.Request["username"];
                        ce.Admins.Add(new Data.Admin()
                        {
                           Username = ss,
                          Area_ID = 1,
                          Img = "../uploadImg/20151116190727629388240.png",
                            State = "可用",
                          power = true,
                            Addtime = DateTime.Now,
                          Nickname = "liuk",
                          Password = "dddddddd"
                       });
                        ///删除
                        var login = ce.Admins.Remove(ce.Admins.FirstOrDefault(a => a.Admin_ID == 20 && a.Username == "admindfd"));
                        int s = ce.SaveChanges();
                        if (login.Count > 0)
                        {
                            context.Response.Write("OK");
                            context.Response.Write(JsonConvert.SerializeObject(login));
                        }
                        else
                        {
                            context.Response.Write("wrong");
                        }