Code first Entity framework connection string

Question

While creating Entity using code First approach , how can i create .mdf in VS. What should be my connection string ?

my connectionstring

<add name="MovieDBContext"
        connectionString="Data Source=|DataDirectory|Movies.mdf"
        providerName="System.Data.EntityClient"/>

Am getting error in DataSource while creating controller. wat should the Data Source for .MDF ?

Matt Whetton · Accepted Answer · 2013-02-22 08:11:12Z

1

If you're trying to use LocalDb (i.e. mdf)

The providerName needs to be "System.Data.SqlClient" for a start.
Then your connection string needs a bit more info, like this:

"Data Source=(LocalDb)\v11.0;Initial Catalog=yourDbName;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\Movies.mdf"

If you wantng to use SqlServerCe (sdf) then:

answered Feb 22, 2013 at 8:11

Matt Whetton

6,8265 gold badges39 silver badges59 bronze badges

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

1 Answer 1