Specify SQL Server File Locations when using Entity Framework Database.Create()

Question

I have several Entity Framework Code First DbContext objects that use a custom Initializer.

In the initializer, the call to

context.Database.Create();

creates the database in SQL Server.

The Data and Log files are created in directories per the Database Settings in SQL Server.

I would like different DbContext subclasses to have different Data and Log file paths. Can I specify the paths somehow when creating the database, or must I detach/move/attach in a separate step after the database has been created?

bricelam · Accepted Answer · 2012-06-28 18:11:38Z

4

You can always use the AttachDBFilename keyword in the connection string. See the documentation of SqlConnection.ConectionString for more information.

answered Jun 28, 2012 at 18:11

bricelam

30.7k9 gold badges97 silver badges119 bronze badges

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

2 Comments

Eric J. Over a year ago

Any idea how I can specify the LOG file to be in a separate folder?

bricelam Over a year ago

It is not possible from the connection string. The log file will be the same as the filename you specify with "_log.ldf" appended.

Collectives™ on Stack Overflow

Specify SQL Server File Locations when using Entity Framework Database.Create()

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related