LINQ 删除多行问题

我想从Activities这个表中删除所有zhanghao == "zb07nju"的行，但是总是弹出"Sequence contains more than one element "，请问怎么办？

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

 

  • skyworld - 1年前 

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

        foreach(var item in query)
        {
            DC.Activities.DeleteAllOnSubmit(item);
        }

        if(query.Count()>0)
        {
            DC.SubmitChanges();
        }
    这样试下

  • skyworld - 1年前 

    var query =(from a in DC.Activities
                    where a.ZhangHao == "zb09nju"
                    select new { a.ZhangHao,a.DateTime,a.Description}).SingleOrDefault();