无法删除多行具有相同列值的数据库记录？

Question

我有一个表，其中有多个列名相同的行，如下所示，

ID   Column1   Column2   Column3

1     test     value1    katy

2     test     value2    kavita

3     test     value3    henry

4     test     value4    stalin

我使用下面的技术检索记录并尝试删除它们，但是它说，强制转换错误，

TableName DeleteSession = (TableName)from s in Data.TableName where s.Column1 == "test"  select s;

Data.TabelName.DeleteOnSubmit(DeleteSession);
Data.SubmitChanges();

如何删除同名行

Answer 1

尝尝这个

var DeleteSession = (from s in Data.TableName 
                     where s.Column1 == "test"  
                     select s).ToList();

Data.TabelName.DeleteAllOnSubmit(DeleteSession);
Data.SubmitChanges();

换新货

var NewSession = (from s in Data.TableName
                  where s.Column1 == "test"
                  select new Table2Name { Column1 = s.Column1...etc }).ToList

Data.Table2Name.InsertAllOnSubmit(NewSession);
Data.SubmitChanges();