how to remove all records from a table after selection?

Question

I can get all the records in a table i need:

 using (Entities db = new Entities())
                {
    db.PROJ_PLOFDataRecord.Where(x => x.Account_Id == 1);
}

I now want to remove them...cant i say something like .RemoveAll()

Possible duplicate question for http://stackoverflow.com/questions/2519866/how-do-i-delete-multiple-rows-in-entity-framework-without-foreach — failedprogramming, Mar 13 '14 at 23:29

BradleyDotNET · Answer 1 · 2014-03-13T23:39:07.393

0

Assuming you are in EF6, try

db.PROJ_PLOFDataRecord.Local.Clear();
db.SaveChanges();

You may need to call db.PROJ_PLOFDataRecord.Load() first to get the Local collection populated.

Here is the documentation for .Local (MSDN)

edited Mar 13 '14 at 23:39

answered Mar 13 '14 at 23:04

BradleyDotNET

doesnt allow me to say .local – John Mar 13 '14 at 23:36
Is it a DbSet, are you using EF6 (I believe 5 works as well)? I attached the documentation in case it helps you determine what you are missing. – BradleyDotNET Mar 13 '14 at 23:40

score 0 · Answer 2 · answered Mar 13 '14 at 23:10

0

You can do this:

yourContext.Database
           .ExecuteSqlCommand("TRUNCATE TABLE <Table>");

answered Mar 13 '14 at 23:10

Hamlet Hakobyan

Yeah. If he has an anemic table with eithe no foreign keys or was not smart enough to set up foreign key relationships that may even work. Bad news is that this would in most cases be a sign of incompetence - or a REALLY rare table. With foreign keys that - fails. -1. – TomTom Mar 13 '14 at 23:34
@John, If you have FK why you want to remove all data from table? – Hamlet Hakobyan Mar 13 '14 at 23:37
+1 I actually think this is an interesting approach. The FK problem might even be ok if ON DELETE CASCADE was set during creation. – BradleyDotNET Mar 13 '14 at 23:41

2 Answers2