Multiple Remove

Question

User1622294484 posted

Hey guys ,

I used to use this line of code , in order to remove a line a database

 ctx.chap.Remove(ctx.chap.First(p => p.titre == btn.CommandArgument));
                        ctx.SaveChanges();

But this one , removes only one line 

What I want is to remove all lines where p.titre==btn.CommandArgument

Any idea how can I change this code to make it work ?

Thanks

Answer 1

User-1360095595 posted

If Remove() will accept a list of records try replacing .First with .Select.

Answer 2

User2117486576 posted

assuming ctx is a DbContext you might try this:

ctx.chap.Where(p => p.titre == btn.CommandArguement).ToList().ForEach(o => ctx.chap.Remove(o));

Haven't tried it but I think it will compile.