How to resolve "Unable To retrieve metadata for MVCApplication.Models.StudentList." during add controller in c# asp.net mvc?

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

, +

Hello,

How to resolve "Unable To retrieve metadata for MVCApplication.Models.StudentList.The specified named connection is either not found in the configuration, not intended to be used with the EntiyClient provider, or not valid" during add controller in c# asp.net mvc 4?

I cant add controller in my application.

i am using Empty MVC Application, i have not choose internet application.

Please help me.

Thanks in advance.

Ankit Agarwal
Software Engineer

Posted 6-Nov-14 23:08pm

ankit.agg1984

Updated 6-Nov-14 23:10pm

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Nathan Minier · Answer 1 · 2014-11-07T01:12:00

Solution 1

This is because you need to create a context object for your data that will inherit from DbContext and add any needed connection details into your web.config. Alternatively, you can create a controller as a class instead and use non-EF data access.

If you want to use EF:

C#

public class StudentContext : DbContext
{
    DbSet<student> { get; set; }
}

Then in the controller creation, select Student as your Model and StudentContext as your context.

Alternatively, if you want to use StudentList, populated from wherever it's populated from, you can create new class and:

C#

public class StudentController : Controller
{

    public StudentContext()
    {
        var list = new StudentList(); // Assuming this is a self-initialized object
    }

    public ActionResult ListStudents()
    {
        return View(list);
    }

    //Other data access methods here
}

And so on.

Edit:
I also would like to direct you to a learner resource Learn MVC (Model View Controller) step by step in 7 days – Day 1[^]

Posted 7-Nov-14 1:12am

Nathan Minier

Updated 7-Nov-14 1:14am

v3

Comments

[no name] 7-Nov-14 7:43am

I m using,

this code in a model class:-

public class StudentListModel
{
public List<studentlist> StudentListCollction { get; set; }
public StudentList StudentListDetail { get; set; }
}
public class StudentList
{
public string Id { get; set; }
public string Name { get; set; }
public string Address { get; set; }
public string Section { get; set; }
public int Marks { get; set; }
}

how can i resolve this error?

Nathan Minier 7-Nov-14 7:47am

You naming conventions are a bit odd. Are you using entity Framework or a different persistence mechanism?

[no name] 7-Nov-14 7:49am

I am using entity framework.

Nathan Minier 7-Nov-14 7:57am

Okay, let's make the syntax more closely match reality:

public class Student
{
public string Id { get; set; }
public string Name { get; set; }
public string Address { get; set; }
public string Section { get; set; }
public int Marks { get; set; }
}

public class StudentContext : DbContext
{
public DbSet<Student> Students { get; set; }
}

Now in your main (project) web.config:

<configuration>
...
<connectionStrings>

<add name="StudentContext" connectionString="Your Connection String" providerName="System.Data.SqlClient" />
</connectionStrings>

</configuration>

Then try to add your controller.

Member 12030170 · Answer 2 · 2015-10-06T10:02:00

You should add the below code in the model :
public int ID { get; set; }

// below given an example :

public class Example

{

public int ID { get; set; } // this code ID helps to retrieve meta data.. And connecting to database

public string Name { get; set;}
}
// or try public int id { get; set; }
// or try public string ID { get ; set ; }
// or try public string id { get ; set ; }
// you should also mention
connectionStrings properly.