List not converting to IEnumerable

Question

Below is the error i getting :

The model item passed into the dictionary is of type 'System.Collections.Generic.List[StoredProcedureEF_MVC.tbl_users]', but this dictionary requires a model item of type 'System.Collections.Generic.IEnumerable[StoredProcedureEF_MVC.Models.User]'.

I have tried a lot but don't know where i was doing wrong, no luck from last two days. I am learning MVC, so sorry if you got some stupid mistake.

My Model :

namespace StoredProcedureEF_MVC.Models { [Table("tbl_users")] public class User { [Key] public int UserId { get; set; } [Required] public string Username {get;set;} [Required] public string Email { get; set; } } }

VIEW:

@model IEnumerable<StoredProcedureEF_MVC.Models.User> @{ ViewBag.Title = "Delete"; } @{ var grid = new WebGrid(source: Model); } @grid.GetHtml( columns: grid.Columns( grid.Column("UserID"), grid.Column("Username"), grid.Column("Email"), grid.Column( format: (item) => Html.ActionLink("Delete", "DeleteUser", new {id=item.UserID }) ) ) )

CONTROLLER ACTION:

[HttpGet] public ActionResult Delete() { SPEFMVCEntities conn = new SPEFMVCEntities(); var result = (from p in conn.tbl_users select p).ToList(); return View(result); }

Well presumably conn.tbl_users is declared to return an IQueryable<StoredProcedureEF_MVC.tbl_users>, not an StoredProcedureEF_MVC.Models.User... How did you expect the conversion to be performed from one to the other? — Jon Skeet
– Jon Skeet, Commented Mar 20, 2015 at 6:57
StoredProcedureEF_MVC.tbl_users is not the same type as StoredProcedureEF_MVC.Models.User — user3559349
– user3559349, Commented Mar 20, 2015 at 6:58
Potentially write a projection from one type to the other. Potentially change to only have one type at all. We don't know enough about your system to say. Do you understand the error though? — Jon Skeet
– Jon Skeet, Commented Mar 20, 2015 at 7:05

user758453 · Accepted Answer · 2015-03-20 07:06:42Z

1

try

var result = conn.tbl_users.Select(c => new StoredProcedureEF_MVC.Models.User { UserId = c.UserId, UserName = c.UserName, Email = c.Email }).ToList(); return View(result);

edited Mar 20, 2015 at 7:06

user3559349

answered Mar 20, 2015 at 7:01

user758453

465 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Ruslan Over a year ago

This will work for sure, but I don't think that's the right way to do this.

Jon Skeet Over a year ago

Not even "for sure" - you may need an AsEnumerable in there (or an intermediate projection to an anonymous type, followed by AsEnumerable, followed by this projection) as otherwise the LINQ provider may complain that it doesn't "know" about Models.User.

Ruslan · Accepted Answer · 2015-03-20 06:58:48Z

0

Try to change your controller method to this:

[HttpGet] public ActionResult Delete() { SPEFMVCEntities conn = new SPEFMVCEntities(); var result = (from p in conn.tbl_users select p as StoredProcedureEF_MVC.Models.User).ToList(); return View(result); }

answered Mar 20, 2015 at 6:58

Ruslan

2,8092 gold badges22 silver badges32 bronze badges

2 Comments

test Over a year ago

NO LUCK : ERROR ---Unable to cast the type 'StoredProcedureEF_MVC.tbl_users' to type 'StoredProcedureEF_MVC.Models.User'. LINQ to Entities only supports casting EDM primitive or enumeration types.

Ruslan Over a year ago

And have you tried changing conn.tbl_users to conn.User or conn.Users? Does that work?

Collectives™ on Stack Overflow

List not converting to IEnumerable

2 Answers 2

2 Comments

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Related