EF code-first to create local database in ASP.NET MVC and C#

Question

I am new to ASP.NET MVC. While going through this tutorial https://learn.microsoft.com/en-us/aspnet/mvc/overview/getting-started/getting-started-with-ef-using-mvc/creating-an-entity-framework-data-model-for-an-asp-net-mvc-application

I am getting error

CREATE FILE encountered operating system error 123 (the filename, directory name, or volume label syntax is incorrect.) while attempting to open or create the physical file 'C:\Users\AMIT & AKASH\ContosoUniversity2 AttachDBFilename=|DataDirectory|_ContosoUniversity2.mdf.mdf'.
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.

My connection string

<connectionStrings>
    <add name="SchoolContext" 
         connectionString="Data Source=(LocalDb)\v12.0;Initial Catalog=ContosoUniversity2 AttachDBFilename=|DataDirectory|\ContosoUniversity2.mdf;Integrated Security=SSPI;" 
         providerName="System.Data.SqlClient" />
</connectionStrings>

SchoolInitializer.cs

StudentContext.cs

Don't post code as images, we prefer text that can be googled. — Henk Holterman
– Henk Holterman, Commented Dec 24, 2017 at 8:42

marc_s · Accepted Answer · 2017-12-24 08:29:30Z

1

You most likely just forgot a semicolon after specifying the initial catalog:

<connectionStrings>
    <add name="SchoolContext" 
         connectionString="Data Source=(LocalDb)\v12.0;Initial Catalog=ContosoUniversity2;AttachDBFilename=|DataDirectory|\ContosoUniversity2.mdf;Integrated Security=SSPI;" 
         providerName="System.Data.SqlClient" />
</connectionStrings>

So change:

Initial Catalog=ContosoUniversity2

to

Initial Catalog=ContosoUniversity2;
                                  ^
                                  |
                     add this semicolon!

answered Dec 24, 2017 at 8:29

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

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

Collectives™ on Stack Overflow

EF code-first to create local database in ASP.NET MVC and C#

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related