Learning MVC3, connection string

Question

I'm learning MVC3 by covering the famous MusicStore tutorial http://mvcmusicstore.codeplex.com/ The connection string used for EF code first is :

<connectionStrings>
    <add name="MusicStoreEntities"
    connectionString="Data Source=|DataDirectory|MvcMusicStore.sdf"
    providerName="System.Data.SqlServerCe.4.0"/>
</connectionStrings>

I would like to use my localhost SQL Server database (windows authentication) instead. What would be the connection string for it to keep working correctly ? Thanks,

tvanfosson · Accepted Answer · 2011-10-09 23:46:11Z

3

Assuming your DB name is MusicStore:

ConnectionString="Data Source=(local); Initial Catalog=MusicStore; Integrated Security=True;"
Provider="System.Data.SqlClient"

answered Oct 9, 2011 at 23:46

tvanfosson

534k102 gold badges703 silver badges801 bronze badges

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

Comments

Crimsonland · Accepted Answer · 2011-10-10 00:03:59Z

1

Here:

<add name="MusicStoreEntities" connectionString="DATA SOURCE =(Your Server Name); INITIAL CATALOG =MusicStore;Integrated Security=True;" providerName="System.Data.SqlClient"/>

and have a look on

Connection strings for SQL Server 2008

Regards

answered Oct 10, 2011 at 0:03

Crimsonland

2,1943 gold badges25 silver badges43 bronze badges

Collectives™ on Stack Overflow

Learning MVC3, connection string

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related