Add controller error unable to retrieve metadata

Question

I want to add controller in my MVC 4 application in VS2012 as this image:

add controller

Model:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.Entity;

namespace MvcDemo.Models
{
    public class MovieDB
    {
        public int ID { get; set; }
        public string Title { get; set; }
        public string Director { get; set; }
        public DateTime Date { get; set; }
    }
    public class MovieDBContext : DbContext
    {
        public DbSet<MovieDB> Movies { get; set; }
    }
}

Connection strings:

<connectionStrings>

<add name="DefaultConnection" 
connectionString="Data Source=(LocalDb)\v11.0;Initial Catalog=aspnet-MvcDemo-20130315191956;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\aspnet-MvcDemo-20130315191956.mdf"
providerName="System.Data.SqlClient" />

<add name="MovieDBContext"
connectionString="Data Source=|DataDirectory|\Movies.sdf"
providerName="System.Data.SqlServerCe.4.0"/>

</connectionStrings>

After clicking "add", this error occurs:

unable to retrieve metadata for 'MvcDDemo.Models.MovieDB'.Using the
same DbCompiledModel to create contexts against different type of
database servers is not supported.instead,create a 
separate DbCompiledModel for each type of server being used.

Any suggestion?

the obvious part is your context is failing. the not obvious part is **why**. this is usually, in descending order, 1) connection string in web.config, 2) your db 3) since you seem to be using Code First, your initialization method or migration strategy could be the problem. Please explain what you have done to intialize database, what kind of db, anything relevant... — Dave Alperovich, Mar 16 '13 at 05:10
it's definitely a problem with connecting to db, but I don't see it. you're using compact and your connection looks solid. you're using the right context... — Dave Alperovich, Mar 16 '13 at 07:03
In my case I have installed EF6 on my web project and EF5 on my model project. — Ε Г И І И О, Nov 18 '13 at 20:16

score 22 · Accepted Answer · edited May 23 '17 at 11:33

22

In Web.config, set second providerName same as first providerName, and after creating controller, undo that!

from:here

edited May 23 '17 at 11:33

Community

1
1

answered Mar 16 '13 at 07:43

Majid

13,853
15
77
113

In my case, I need to change connectionString="metadata***"。 – Will Wu Jul 11 '15 at 09:18

score 5 · Answer 2 · edited Jun 29 '15 at 07:35

5

Change providerName="System.Data.SqlServerCe.4.0 to providerName="System.Data.SqlClient to fix this error.

edited Jun 29 '15 at 07:35

musicakc

488
1
4
15

answered Mar 18 '13 at 20:30

carlosCeron

55
3

score 5 · Answer 3 · answered Jul 21 '14 at 04:53

My post may help in case someone has the same problem.

I tried experimenting with EF6 and EF5 in the same project, and I noticed that the <entityFramework> tag was messed up, and got the same problem above.

Here is what I did, and it solved the problem:

I removed the <entityFramework> tag from Web.config
Uninstalled entity framework from my MVC app using nuget
Installed entity framework to my MVC app again

After removing the <entityFramework> tag and re-installing EF5 it was fixed, and I can scaffold my controllers again.

score 3 · Answer 4 · answered Oct 19 '18 at 00:07

3

Don't forget to clean and rebuild before you try to scaffold! That was my mistake.

answered Oct 19 '18 at 00:07

Scuba Steve

1,541
1
19
47

score 0 · Answer 5 · edited Aug 27 '13 at 18:42

0

In web.config, delete the AttachDBFilename=|DataDirectory|****.mdf line.

edited Aug 27 '13 at 18:42

Majid

13,853
15
77
113

answered Aug 17 '13 at 10:57

Kateregga John Baptist

11

score 0 · Answer 6 · edited Nov 07 '13 at 20:01

0

User following for providerName = "System.Data.SqlServerCe.4.0"

<add name="MovieDBContext" 
connectionString="Data Source=|DataDirectory|\Movies.sdf"
providerName="System.Data.SqlServerCe.4.0" />

edited Nov 07 '13 at 20:01

Majid

13,853
15
77
113

answered Nov 07 '13 at 19:53

HPP

244
2
12

score 0 · Answer 7 · edited May 23 '17 at 11:47

I had the same issue and below is the change which fixed the issue for me. Had to change localhost to . And Added Initial catalog=Movies.

Before

<add name="MovieDBContext" connectionString="Data Source= localhost\SQLEXPRESS;AttachDbFilename=|DataDirectory|\MoviesDB.mdf;Integrated Security=True" providerName="System.Data.SqlClient"/>

After (fix)

<add name="MovieDBContext" connectionString="Data Source= .\SQLEXPRESS;Initial Catalog=Movies; AttachDbFilename=|DataDirectory|\MoviesDB.mdf;Integrated Security=True" providerName="System.Data.SqlClient"/>

Reference:

ASP .Net MVC 4, Invalid value for key 'attachdbfilename'

score 0 · Answer 8 · answered Jul 25 '21 at 07:20

0

Make sure that the context section has access to the context created in that class library. for example:

Persistence.DbContexts is not Correct you must use this Persistence.DbContexts.DataDbContext

answered Jul 25 '21 at 07:20

Jalal Malekpour

19
8

Add controller error unable to retrieve metadata

8 Answers8

Linked