c# - 在 Asp.Net 方法中，如何使用 EF 从表中删除行？

Question

我有这个方法:

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

}

我想做的是从这里的三个表中删除:

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; } 

EF6 中是否有我可以用来删除所有行的删除函数，或者我应该以某种方式进行 SQL 调用？

Answer 1

假设您有一个 DbContext 派生类...

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
    }
}