ASP.NET MVC 5 change database name

Question

Hy!

I'm new to ASP.NET MVC 5. I try to change the default database name. But I don't know how. My goal is to have only one database for the whole application.

My actual working Web.Config:

    <connectionStrings>
        <add name="DefaultConnection" connectionString="DataSource=(LocalDb)\v11.0;AttachDbFilename=|DataDirectory|\aspnet-SqlTest-20131122100021.mdf;Initial Catalog=aspnet-SqlTest-20131122100021;Integrated Security=True"
         providerName="System.Data.SqlClient" />
    </connectionStrings>

This Web.Config file should look like this and should work ^^ (actual I get a error that the database could not be created and the physical name may be incorrect)

    <connectionStrings>
        <add name="DefaultConnection" connectionString="DataSource=(LocalDb)\v11.0;AttachDbFilename=Example.mdf;Initial Catalog=Example;Integrated Security=True"
             providerName="System.Data.SqlClient" />
    </connectionStrings>

Thanks for help :)

Lin · Accepted Answer · 2013-11-22 15:16:40Z

4

You need to add |DataDirectory|\ before Example.mdf, like below:

 <connectionStrings>
    <add name="DefaultConnection" 
    connectionString="DataSource=(LocalDb)\v11.0;AttachDbFilename=|DataDirectory|\Example.mdf;Initial Catalog=Example;Integrated Security=True"
     providerName="System.Data.SqlClient" />
</connectionStrings>

answered Nov 22, 2013 at 15:16

Lin

15.2k4 gold badges50 silver badges49 bronze badges

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

Collectives™ on Stack Overflow

ASP.NET MVC 5 change database name

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