Linq学习（增、删、改）

来源：互联网发布：全能转盘抽奖软件编辑：程序博客网时间：2024/06/07 12:07

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));

0 0