Linq删除

来源:互联网 发布:软件开发工程师学习班 编辑:程序博客网 时间:2024/06/05 16:34

   DataClassesDataContext DC = new DataClassesDataContext();
       
var query = from a in DC.Activities
                   
where a.ZhangHao == "zb09nju"
                   
select a;

       
if(query.Count()>0)
        {
            Activities[] actiObjsArr
=new Activities[query.Count()];
           
int i=0;
           
foreach(Activities item in query)
            {
                actiObjsArr[i]
=item;
               
++i;
            }

           
for (int n= 0; n < i; ++n)
            {
        DC.Activities.Remove(actiObjsArr[n]);
                DC.SubmitChanges();
        }
        }

原创粉丝点击