How to perform delete rows on some condition with EF?

"The store update, insert, or delete statement impacted an unexpected amount of rows (0)," says Entity Framework.

I am using Entity Framework to populate a grid control. Sometimes when I make updates I get the following error:...Store update, insert, or delete statement affected an unexpected number of rows (0). Entities may have been modified or deleted since entities were loaded. Refresh ObjectStateManager entries....I can't figure out how to reproduce this....

In Entity Framework, how can I remove many rows? (without foreach)

I'm deleting several items from a table using Entity Framework. There isn't a foreign key / parent object so I can't handle this with OnDeleteCascade....Right now I'm doing this:...var widgets = context.Widgets .Where(w => w.WidgetId == widgetId); foreach (Widget widget in widgets) { context.Widgets.DeleteObject(widget); } context.SaveChan...

Entity Framework deletes related entities in a cascading manner.

I have an issue with deletion in Entity Framework. In short, EF explicitly tries to delete an entity from the database even though I've explcitly configured EF to use cascading deletes in the database....My design:...I have three entity types, ...MainEntity..., ...EntityTypeA... and ...EntityTypeB.... EF has been configured to use cascade deletion ...

how to remove several rows of data using DbContext and Linq to EF

Within a project I have a database table with the following columns...I would like to be able to delete from this table all rows which have a matching SharingAgencyId and ReceivingAgencyId values that I can pass in....What I have tried so far:... public static ICollection<SecurityDataShare> UpdateSharedEntites(long conAgency, long recAgency) ...

Edit Id - Store update, insert, or delete statement affected an unexpected number of rows (0)

So I need to be able to edit my primary key field in my edit page for a row, I get the error...Store update, insert, or delete statement affected an unexpected number of rows (0). Entities may have been modified or deleted since entities were loaded. Refresh ObjectStateManager entries....When I don't change the primary key field I can save ...

Store update, insert, or delete statement affected an unexpected number of rows (0) EntityFramework

I keep getting the following error when I try to save changes made to a context: ...Store update, insert, or delete statement affected an unexpected number of rows (0). Entities may have been modified or deleted since entities were loaded. Refresh ObjectStateManager entries....I have the following classes:...Person...public class Person : IPe...

Delete row in table with self-referencing many-to-many relationship in Entity Framework Code First

I've been scratching my head and reading tons of posts but couldn't figure this out....I have a Person table (see following). Entities in that table can have Children and Parents, who also are in the same table....public class Person { public int ID { get; set; } public int Name { get; set; } public virtual ICollection<Person> Children ...

OrderBy().FirstOrDefault(<condition>) vs. Where(<condition>).OrderBy().FirstOrDefault()

Im using EntitiyFramework 6.1.3 with SQL Server in a C# Project. I've two queries which basically should do the same....1....Exams.GroupBy(x=>x.SubjectID).Select(x => x.OrderBy(y => y.Level.NumericValue).FirstOrDefault(y => y.Date.Value > DateTime.Today)) ...2....Exams.GroupBy(x=>x.SubjectID).Select(x => x.Where(y => y.Date.Value > DateTime.Today)....

E.F.6, DB first, soft delete - condition mapping of computed column

I'd like to implement soft delete feature on application that is using E.F.6 with database first (.edmx) approach. Following tips and tricks from links: ...link1... and ...link2... I managed to do the following:...Added column ...IsDeleted... on table...Added calculated column ...IsDeletedMapping... on table, that has same value as IsDeleted...Add...

To delete a row from a table of only foreign keys using Entity Framework

I have a table ...User { UserId, Name, Age }... and ...License { LicenseId, Name, IsActive }.... Also I have a table ...UserLicense { UserId, LicenseId }... which connects both of these and has the record for all the users who hold a license. A user can hold multiple license and those appear as different rows in the ...UserLicense... table....Now I...