Retrieve specific fields from a database table using LINQ

Adalat Khan

8y1.3kLINQ

I have an Action Method in MVC application that retrieves the list of Students from a database table StudentsInfo using LINQ query. When i retrieve all the columns from the table then the Query works but when i try to retrieve some specific columns from the table then i get the following error message:

The model item passed into the dictionary is of type 'System.Collections.Generic.List`1[<>f__AnonymousType6`1[System.String]]', but this dictionary requires a model item of type 'System.Collections.Generic.IEnumerable`1[MVCApplication.StudentsInfo]'.

What I have tried:

Following is the action Method

public ActionResult GetAllStudents()

{

//Retrieve data from StudentsInfo table

var result = from d in db.StudentsInfo

select new

{

d.StdRegNumber,

d.StdName,

d.StdDoBirth

};

return View(result.ToList());

}

Thanks in advance

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar8y ago
Accepted answer
Hi Adalat,

Your view should have same model refered top of cshtml. if you want to return custom model like only few or more fields then you need to create ViewModel and return that mode from here.

Please need to check this part ,

return View(result.ToList());
return View(result.ToList());





ublic ActionResult GetAllStudents()

{

   var result = from d in db.StudentsInfo

       select new StudentViewModel()

             {

             studentRegNumber = d.StdRegNumber,

studentRegName =d.StdName,

             studentDateofBirth =d.StdDoBirth

             };

      return View(result.ToList());

}



public class StudentViewModel

{

   studentRegNumber int{get;,set;}

   studentRegName string {get;,set;}

   studentDateofBirth Datetim{get;,set;}

}

Your cshtml should be like this
@model IEnumberavle
Adalat Khan8y ago
Thanks to all. The problem has resolved
Jignesh Kumar8y ago
could you please share .cshtml top part where you are referning @modle line and your view name ?
Bryian Tan8y ago
The quick work around to see how it work is to remove the Anonymous return type, select new {}, that will make the model in the view match the return model from the GetAllStudents() .

The idea way todo this is to create a ViewModel object with the properties the view needed, then on the Controller side, do something like below
var result = from d in db.StudentsInfo
select new WhatEverViewModel()
             {
                 StdRegNumber =  d.StdRegNumber,
                 StdName =  d.StdName,
                 StdDoBirth =  d.StdDoBirth
             };
On the view, update the model to
@model IEnumerable<MVCApplication.WhatEverViewModel>
Jaish Mathews8y ago
You need to share your View file too. Most probably, you mentioned model type of Enumerable inside View, but you converted the model to a List type inside Controller file before to pass it to View. So some type mismatch error is throwing. Please check the View declaration section and the actual type your are returning to View