How to delete multiple rows using LINQ in linq2db Templates based on two tables?

Question

I've two tables Product and user. Now, i want to delete multiple records at a time with a relation like: i want to delete all the products related to particular user.

I've delete multiple records code in linq2db Templates

using (var db = new DbNorthwind())
{
  db.Product
  .Where(p => p.Discontinued)
  .Delete();
}

But, how to relate that user table to this code?

Source: https://linq2db.github.io/#delete

But, I there it's deleting all the rows On The Go, Not using foreach. — Chanikya, Sep 26 '18 at 10:19

score 8 · Accepted Answer · edited Sep 28 '18 at 03:42

8

You can use the following solution to delete multiple rows using LINQ in linq2db Templates based on two tables:

(
    from p in db.Product
    join u in db.User on ... some join ...
    select p
)
.Delete();

edited Sep 28 '18 at 03:42

Grant Miller

27,532
16
147
165

answered Sep 27 '18 at 22:53

IT.

859
4
11

score -2 · Answer 2 · answered Sep 26 '18 at 17:24

-2

Try this:

using (var db = new DbNorthwind())
{
  var deletionList=db.Product
                     .Where(p => p.Discontinued).AsEnumerable();
  db.Product.RemoveRange(deletionList);
  db.SaveChanges();
}

answered Sep 26 '18 at 17:24

Sumit raj

821
1
7
14

1

This syntax is not for Lin2DB, the OP clearly asked for Linq2DB. @Sumit – nightElf91 Mar 13 '23 at 14:30

How to delete multiple rows using LINQ in linq2db Templates based on two tables?

2 Answers2