MVC Selecting data with linq and passing to model

Question

I am currently learning ASP.NET MVC and along with LINQ

I have followed a few tutorials and have a good concept of MVC. I have run into a problem though. I am trying to select a specific row from my table and sent it to the view but I am getting an error.

The code for the select is:

                Movie Mov = new Movie();

        Mov =  from movies in _db.Movies
                    where movies.Title == "Ghostbusters"
                     select movies;

And the error is:

    Error   2   Cannot implicitly convert type 'System.Linq.IQueryable<MvcApplication2.Models.Movie>' to 'MvcApplication2.Models.Movie'. An explicit conversion exists (are you missing a cast?)    C:\Users\user\Desktop\MvcApplication2\MvcApplication2\Controllers\HomeController.cs 22  25  MvcApplication2

Thanks

Indi · Accepted Answer · 2013-12-04 13:25:21Z

3

Your Linq Query is an IQueriable. That means it is not an object (or objects) of Movie but a sql query to select Movie objects. You need to convert it to an object (or objects) and pass it to the view.

So try this;

 Movie Mov = (from movies in _db.Movies
                where movies.Title == "Ghostbusters"
                 select movies).FirstOrDefault();

 return View(Mov);

edited Dec 4, 2013 at 13:25

answered Dec 4, 2013 at 13:18

Indi

33.9k7 gold badges61 silver badges80 bronze badges

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

1 Comment

Mat J Over a year ago

You don't need that ToList there as it will bring the entire rows to memory.

Roy Dictus · Accepted Answer · 2013-12-04 13:17:06Z

0

You are assigning a query, and not a query result, to Mov.

Do like so:

Mov = (from ... select ...).First();

And by the way, since you're going to fill in Mov with a value from the query, you don't need to initialize it with = new Movie().

answered Dec 4, 2013 at 13:17

Roy Dictus

33.3k9 gold badges64 silver badges77 bronze badges

Collectives™ on Stack Overflow

MVC Selecting data with linq and passing to model

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related