how to setup MVC application to use sql server 2008 r2 express

Question

I am trying to follow the tutorial on the building my first MVC application for here all was good until I needed to run the application an entity framework should have done it's thing and create the data base for me, but for some reason I always get the same error :

The provider did not return a ProviderManifestToken string.

my question: what are the necessary adjustments i need to do in order for the application to work?

here is my web.config file connection string section

<connectionStrings>
<add name="ApplicationServices"
     connectionString="data source=Moran-Laptop;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true"
     providerName="System.Data.SqlClient" />
<add name="MovieDBContext"
     connectionString="Data Source=|DataDirectory|Movies.sdf"
     providerName="System.Data.SqlServerCe.4.0"/>

There are several other stackoverflow threads about this error. Have you tried what they have suggested? http://stackoverflow.com/questions/5423278/ef-4-1-exception-the-provider-did-not-return-a-providermanifesttoken-string — Marc Talbot, Feb 16 '12 at 14:31
Seems like a duplicate of: http://stackoverflow.com/questions/5423278/ef-4-1-exception-the-provider-did-not-return-a-providermanifesttoken-string — Vedran, Feb 16 '12 at 14:32
Have you read through the comments on the linked page? there is several which mention `ProviderManifestToken ` why they had the issue and how they fixed it. I don't mean it in a smart way, just making sure none of their solutions applied to you. — Nope, Feb 16 '12 at 14:33
I have looked for but haven't found any probably because I didn't search for the appropriate search terms. thanks for the reference. — Moran Monovich, Feb 16 '12 at 14:36
now I got it, i think i should have installed the sql compact 4.0 and entity framework 4.3 before I'have started the application. I will start over and try again — Moran Monovich, Feb 16 '12 at 14:56

score 0 · Answer 1 · answered Feb 16 '12 at 14:34

0

I think your data source is not correct. Does it work with:

<add name="ApplicationServices"
     connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true"
     providerName="System.Data.SqlClient" />

answered Feb 16 '12 at 14:34

Zach Green

3,421
4
29
32

I have installed sql server compact 4, but now I am getting another message. seems to me like it has no end. i will find a different tutorial thanks – Moran Monovich Feb 16 '12 at 15:16

score 0 · Answer 2 · answered Feb 16 '12 at 14:38

0

If you inspect the exception you will find out that there is InnerException as well which most probably points to SqlException and its inability to find the database or server. Your ConnectionString expects that you have Sql Server CE database available in your App_Data folder. The tutorial that you are looking does not yet tell you that you have to add a new SQL Server CE database to your App_Data folder. Check part 5 of the tutorial http://www.asp.net/mvc/tutorials/getting-started-with-aspnet-mvc3/getting-started-with-mvc3-part5-cs

answered Feb 16 '12 at 14:38

Huske

9,186
2
36
53

1

the EF should have created this DB automatically for me, I think. – Moran Monovich Feb 16 '12 at 14:44
Inspect the inner exception of the exception that you are receiving. It might be that SQL Server CE was not installed on your computer. – Huske Feb 16 '12 at 14:48

score 0 · Answer 3 · answered Feb 16 '12 at 14:38

0

First off you need to change your connection strings to point to the servers instance of sql server rather than to your laptop

in your connection strings replace Moran-laptop with "server-name\db name" i.e. r2008sqlserver\movies

answered Feb 16 '12 at 14:38

Brian

2,229
17
24

how to setup MVC application to use sql server 2008 r2 express

3 Answers3