How to delete multiple data using entity framework and asp.net?

Question

Hi I'm now learning about entity framework and still a beginner. Now, I've been having a problem with deleting multiple data in my database. Here is a piece of my database:

Please click to see the image for database

For example i wanted to delete all data that has a brandId of 2. I tried using this code:

 int brandId = (from i in context.brands where i.name == name.Text select i.brandId).First();
var bay2 = (from g in context.logoes where brandId == g.brandId select g).FirstOrDefault();

        if (bay2 != null)
        {
            context.logoes.Remove(bay2);
            context.SaveChanges();
        }

But it only deletes one data, which is logoId 3. It did not delete logoId 4. What am i doing wrong in my query? How to delete all data that has brandId 2 using entity framework?

i believe you could remove multitple logo using RemoveRange.. — Bagus Tesa
– Bagus Tesa, Commented Jul 31, 2017 at 13:35

JuanR · Accepted Answer · 2017-07-31 13:47:47Z

3

This line is pulling only one object:

var bay2 = (from g in context.logoes where brandId == g.brandId select g).FirstOrDefault();

Because of the FirstOrDefault.

Remove the FirstOrDefault. Then use RemoveRange:

var bay2 = (from g in context.logoes where brandId == g.brandId select g).FirstOrDefault();

if (bay2.Any())
{
    context.logoes.RemoveRange(bay2);
    context.SaveChanges();
}

answered Jul 31, 2017 at 13:47

JuanR

7,8811 gold badge23 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Maciej · Accepted Answer · 2017-07-31 13:48:37Z

0

Try to use .ToList() method instead of First(). Then Iterate over this for example list using foreach and delete these objects, or delete whole range.

answered Jul 31, 2017 at 13:48

Maciej

11 silver badge1 bronze badge

Collectives™ on Stack Overflow

How to delete multiple data using entity framework and asp.net?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related