SQL Server Express and Entity Framework

connection-string entity-framework sql-server-express

Question

I'm new to SQL Server Express (not to SQL Server in general) and I have a problem. I'm using Entity Framework (6-beta) in an ASP.NET MVC application.

I created a database using the SQL Server Management Studio. I can connect to the DB using Management Studio and my local Windows user account. I dind't change the default configuration, so the SQL Server stores the data files in :

C:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA

The .mdf file of my database is stored in this folder.

My problem is: When I start the MVC application from Visual Studio, Entity Framework failes to open a connection to the database. The exception text is quite unprecise, but the inner exception reveals that it tries to connect to:

C:\Users\<MyUser>\Workspaces\<Solution>\<Project>\App_Data\<Context>.mdf

My connection string is:

"Data Source=.\SQLEXPRESS; Initial Catalog=<Name>; User Instance=False; Integrated Security=True;"

Does anyone know why Entity Framework tries to connect to this file? What can I do?

1
2
7/23/2013 8:52:35 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

Ok. I found the problem. I edited the wrong web.config file by accident. Asp.Net MVC 5 creates a second web.config file in the Views folder. Of course, the connection string must be inserted in the web.config of the root folder.

2
7/23/2013 8:17:19 PM

Popular Answer

You need a web.config entry on the MVC application project (in case the DBContext is in another referenced project).

The web.config should have an entry like the one below in the connectionstrings section (note YOURCONTEXTNAME should match the name of your DBContext class).

  <add name="YOURCONTEXTNAME" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=YOURDATABASENAME;Integrated Security=SSPI"
       providerName="System.Data.SqlClient" />
Lenny

Related Questions

Date time and SQL Server 2008 and SQL Server 2005

A quick google points me to what looks like the ...solution.......Open your EDMX in a file editor (or “open with…” in Visual Studio and select XML Editor). At the top you will find the storage model and it has an attribute ProviderManifestToken. This has should have the value 2008. Change that to 2005, recompile and everything works....NOTE: ...
datetime datetime2 entity-framework sql-server-2005 sql-server-2008
asked by Richard Harrison

SQL Server Compact does not allow keys and values produced by the server.

When I hit this limitation, I changed the type to uniqueidentifier
compact-framework entity-framework
asked by mostlytech

Connection string for Entity Framework Code First in SQL Server Express

The problem with your connection string here is:...<add name="TrempimModel" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI; AttachDBFilename=|DataDirectory|aspnetdb.sdf; User Instance=true" providerName="System.Data.SqlClient" /> ...You're basically defining what "server" ...
code-first connection-string entity-framework sql-server-express
asked by marc_s

Using Visual Studio to get the database name from a SQL Server Express database

The database name is the name you give your .MDF file as you attach it to the SQL Server (Express) server instance. There is no fixed database name "inside" the MDF that you need to discover - it's totally up to you what you call your database on the server....So if you attach your ...Database1.mdf... like this:...CREATE DATABASE CrazyDatabase ON (...
entity-framework iis-7.5 sql-server sql-server-2008 sql-server-express
asked by marc_s

Running SQL Server CE 4 Queries with Visual Studio 2012 and SQL Server Management Studio 2012

Try using the SQL Server Object Explorer instead of the Server Explorer. That should allow you to do what you wish.
entity-framework sql-server-2012 sql-server-ce visual-studio-2012
asked by Andrew Clear

SQL Server Express 2008, Joins, and Timeout Expired Error Message

Just a guess, but the query runs fast (3 seconds) only when it is cached. Otherwise, it takes a lot longer and exceeds your server timeout setting. Since System.Data.SqlClient is raising the exception, it is likely that the default timeout is only 15 seconds....MSDN: "The default value is 15 seconds"...Alternatively, try the CommandTimeout proper...
entity-framework join sql-server stored-procedures timeout
asked by ExactaBox

Entity Framework 6 with SQL Server 2012 gives System.Data.Entity.Core.ProviderIncompatibleException

Try this. Make sure that the project that your ShoppingCartContext is in, is the start up project or when executing the add-migration command include the parameter -startupprojectname ex. add-migration -startupprojectname yourprojectname
entity-framework-6 sql-server-2012
asked by Jelard Macalino

EF6 and multiple configurations (SQL Server and SQL Server Compact)

EDIT: based On Error details: Did you already try tell EF where the config class is found?...[DbConfigurationType("MyNamespace.MyDbConfiguration, MyAssemblyFullyQualifiedName")] public class MyContextContext : DbContext { } ...If that cant be made work, then see alternative...Use the Context with constructor DbConnection ...public class MYDbContext...
c# configuration entity-framework entity-framework-6
asked by phil soady

Entity Framework 6.1.3 and SQL Server CE 4.0 - No Entity Framework provider found

You need to install the SQL Server Compact Toolbox on the new dev machine, it installs the DDEX provider for you. (You may have to go to the About screen in the Toolbox and clikc the DDEX install button, then restart VS)
ef-database-first entity-framework-6 git sql-server-ce-4
asked by ErikEJ

Entity Framework 6 BulkInsert receiving an invalid column length from the client SQL SERVER 2012 Express

The ...SaveChanges... use a SqlCommand. If the name is longer than the database limit, it will silently be truncated, so no error will be thrown....The ...BulkInsert... use a ...SqlBulkCopy..., if the name is longer than the database limit, an error will be thrown....That explain why you get an error in one case and none in the other case....SqlBul...
c# entity-framework-6 sql-server-2012-express
asked by Jonathan Magnan

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow