Entity Framework Code First Database Recovery Model

Question

Is is possible to set the Recovery Model mode of an SQL database created using Entity Framework 6? I know it's possible to set it through the following SQL statement:

ALTER DATABASE [Database_Name] SET RECOVERY SIMPLE;

It seems odd that this can't be set as a part of the configuration of the DbContext - the object which creates the database can't seem to control how it's created. I was expecting to find something like the following:

public class MyContext : DbContext
{
    public MyContext(string connectionString) : base(connectionString)
    {
        // This is where I would have expected to be able to set the recovery model type
        Database.RecoveryModel = RecoveryModelType.Simple;
    }
}

My suspicion is that this isn't possible due to EF being (largely) DB provider agnostic and recovery model being MSSQL specific, but I'm hoping that I'm wrong.

@Coding4Fun just because that question has 'recovery' in the title, doesn't mean it's talking about the same thing - it isn't. — AakashM
– AakashM, Commented Jul 3, 2017 at 10:06
@Coding4Fun The linked question doesn't address the question I asked, which is specifically about setting the recovery model type through EF. The database is being created absolutely fine, but the recovery model is always the default; that is, full. — Sok
– Sok, Commented Jul 3, 2017 at 10:06
The fact that this github.com/aspnet/EntityFramework6/blob/master/src/… (which is where CREATE DATABASE is to be found in the EF6 source) doesn't include any mention of "recovery" suggests that the answer is no. — AakashM
– AakashM, Commented Jul 3, 2017 at 13:36

alexsuslin · Accepted Answer · 2018-06-19 15:51:49Z

1

Not in a way you want it to.

EF works with different SQL providers and what is relevant for MS SQL, might be inappropriate for MySQL.

However you can always run raw TSQL and do whatever you want.

answered Jun 19, 2018 at 15:51

alexsuslin

4,2521 gold badge23 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Entity Framework Code First Database Recovery Model

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related