How can I delete rows from tables using EF when inside an Asp.Net method?

Question

I have this method:

[Route("Delete")]
public IHttpActionResult Delete()
{

}

What I would like to do is to delete from three tables that are here:

public System.Data.Entity.DbSet<SampleSentence> SampleSentences { get; set; } 
public System.Data.Entity.DbSet<Synonym> Synonyms { get; set; } 
public System.Data.Entity.DbSet<WordForm> WordForms { get; set; } 

Is there a delete function in EF6 that I can use to delete all the rows or should I somehow make a SQL call?

Answer 1

Assuming you have a DbContext derived class...

using (var transactionScope = new TransactionScope()) {
    try {
        string sql = @"
DELETE SampleSentence 
DELETE Synonym 
DELETE WordForm
";

        int count = myDbContext.Database.ExecuteSqlCommand(sql);
        if(count > 0) 
            transactionScope.Complete();
    } catch(Exception ex) {
        //Logging
    }
}

Answer 2

You can use this EntityFramework.Extended library, with it help one can write:

context.SampleSentences.Delete();
context.Synonyms.Delete();
context.WordForms.Delete();