Error in creating database using EF with a code-first approach

Question

Path is concatenating with database name

CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file 'C:\Users\fahidNinjaDomain.DomainModel.NinjaContext.mdf'. CREATE DATABASE failed. Some file names listed could not be created. Check related errors.

It should be like this

C:\Users\fahid\NinjaDomain.DomainModel.NinjaContext.mdf

How can I solve this using update-database -verbose?

There is a "\" missing in the path. It should be "C:\Users\fahid\...", not C:\Users\fahid..." — Progman

cheny cheny · Accepted Answer · 2020-01-10T14:34:13

The missing \ was caused by a bug from Sql Server. See this question for details: CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file. And download the update here: https://www.microsoft.com/en-us/download/confirmation.aspx?id=56128.

Error in creating database using EF with a code-first approach

1 Answers