How to handle multiple table deletion operation in linq

See more:

LINQ

Linq2Sql

Hi ,

my current requirment is , based on scnerio i have to keep deleting particular ids data from multiple tables.

now my question is will it affect performance by doing in linq.

What i am doing is , first checking in linq for particular records in table. If exisist i am deleting those records then moving next to next table.

am i handling this scnerio correctly ?

What I have tried:

//CallOrder Deletion
                var callOrderData = _db.CallOrders.Where(c => c.CallID == callId).ToList();
                if (callOrderData != null && callOrderData.Count > 0)
                {
                    _db.CallOrders.DeleteAllOnSubmit(callOrderData);
                    _db.SubmitChanges();
                }

                //Call Attachment
                var callAttachmentData = _db.CallAttachments.Where(c => c.CallID == callId).ToList();
                if (callAttachmentData != null && callAttachmentData.Count > 0)
                {
                    _db.CallAttachments.DeleteAllOnSubmit(callAttachmentData);
                    _db.SubmitChanges();
                }

and so on ..

there are about 7 tables in a line where i have to check.