Delete an Object Without Retrieving it in Entity Framework 6.0

Sign in to leave a comment.

• NS

  Nadeem Shehzad11y agoPosted May 20, 2015, 11:27 AM

  Will option #1 perform cascade delete like Remove on the Dbset, or leave the records orphans in the child tables
• AK

  Andrew Klinman11y agoPosted Mar 28, 2015, 8:26 PM

  I tried the #1 approach and it doesn't seem to work. I don't get an error, and if I refresh my grid by querying, the row is gone. However, when I run the program again, the row is back, and of course it's still in the DB.
  • 

    Jignesh Trivedi11y agoPosted Apr 5, 2015, 11:58 PM

    Have you resolved the issue?
  • AK

    Andrew Klinman11y agoPosted Mar 28, 2015, 8:35 PM

    Oops, never mind. The DB I was looking at in VS server explorer wasn't the one the EXE was actually pointing to (which was under my "data" directory where the EXE was running from. Also, I had it set to "copy always", so it was overwriting the DB that had the record deleted with the "clean" one that still had the test records. DOH!
• 

  Ramesh Maruthi12y agoPosted Jul 21, 2014, 10:19 AM

  Thanks Jignesh Sir !! Let me try with this :)
• 

  Ramesh Maruthi12y agoPosted Jul 18, 2014, 11:21 AM

  Jignesh now days I am working on entity framework 6.0.1 , How this scenario works for bulk delete without retrieving from a database ? for an example I pass an array of ids , how does this work ? And if use where with parallel linq, I think it takes the same time DepartmentMaster deptDelete = Context.DepartmentMaster.Where (s =>s.DepartmentID == 9)); Context.DepartmentMasters.Remove(deptDelete); Context.SaveChanges(); SOrry if am wrong
  • 

    Jignesh Trivedi12y agoPosted Jul 20, 2014, 11:59 PM

    Hi, If you have Ids of all records that you want to delete than you can pass all Ids to delete 's where condition using second method like Context.Database.ExecuteSqlCommand("Delete DepartmentMasters where DepartmentId in ({0} )", new object[] { string.Join (",", Ids) }); hope this will help you.
• 

  Mahesh Chand12y agoPosted Jul 17, 2014, 5:49 PM

  Nice to see Jignesh working with EF6.
  • 

    Jignesh Trivedi12y agoPosted Jul 20, 2014, 11:59 PM

    Thanks Mahesh