Remove some Records from child collection using Lambda expr

Question

Hi All I need to remove some records from child collection where isDeleted==1. I got LINQ to SQL query but not remommended. Thanks in Advance

Ananth Padmanabham vemula · Answer

Hi Pawan Check the below code it might helpful for you... var getdata = (from i in dc.tableName where i. isDeleted == 1 select i); foreach (var dt in getdata) { dc. tableName .DeleteOnSubmit(dt); dc.SubmitChanges(); }