Linq学习（增、删、改）

1.linq批量删除

string[] allkey = key.Split(',');
var queryDelete = from p in entity.AMS_asset_categories
                  where allkey.Contains(p.category_id)
                  select p;
entity.AMS_asset_categories.RemoveRange(queryDelete.ToList());
int result = entity.SaveChanges();

2.Linq删除一个

entity.AMS_asset_categories.Remove(entity.AMS_asset_categories.Where(p => p.category_id == key).FirstOrDefault())

3.Linq新增

 AMS_asset_types item = new AMS_asset_types();
                        item.asset_type_id = DateTime.Now.ToString("yyMMddHHmsf");
                        item.id = CommonHelper.GetGuid;
                        item.name = dto.name;
                        item.description = dto.description;
                        item.available = dto.available;
                        item.spinyin = SignHelper.ToLongSign(item.name.Trim());
                        item.lpinyin = SignHelper.ToShortSign(item.name.Trim());
                        item.create_date = DateTime.Now;
                        item.create_user = SessionHelper.GetSessionUser().UserId;
                        item.modify_date = DateTime.Now;
                        item.modify_user = SessionHelper.GetSessionUser().UserId;
                        entity.AMS_asset_types.Add(item);
                    entity.SaveChanges();

4.Linq更新

http://blog.csdn.net/g1036583997/article/details/31726153

http://blog.csdn.net/g1036583997/article/details/31785171

5.linq查询部分

 string userid=SessionHelper.GetSessionUser().UserId;
                            var queryhis = context.AMS_Plan_Audit_History.Where(p => p.audit_user_id == userid).Select(e=>e.plan_item_id).ToArray();
                            query = query.Where(p => queryhis.Contains(p.plan_item_id));