我有一个表,其中有多个具有相同列名的行,如下所示,
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();
如何删除具有相同列名的行
试试这个
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();
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句