ADO.Net Entity Framework/Linq

Question

I'm look at learning a bit more ASP.Net MVC and Linq To Entity.

I'm working on a project using this and am having a problem with the following line of code

ViewData["ProjectName"] = db.Projects.FirstOrDefault(p => p.ProjectId  == task.ProjectId).ProjectName;

It works fine when the record exists but if no record exist it errors because I am trying to examine the ProjectName property of a null object. I realise I could cast the object to a variable and test if its null before storing the ProjectName into the ViewData but am just wondering if there is a neater way of doing this?

I know its a simple question and I could just work around it but if there is a better way of doing this it would be good to know.

Thanks

Gavin

Adrian Zanescu · Accepted Answer · 2009-11-09 15:39:02Z

1

var project = db.Projects.FirstOrDefault(p => p.ProjectId == task.ProjectId);
if (project != null)
{
  ViewData["ProjectName"] = project.ProjectName;
}
else
{
  //........
}

No cast needed.

Or skip the condition altogether and do this:

ViewData["ProjectName"] = db.Projects.Where(p => p.ProjectId == task.ProjectId)
                           .Select(p => p.ProjectName).FirstOrDefault();

edited Nov 9, 2009 at 15:39

answered Jun 3, 2009 at 8:16

Adrian Zanescu

8,0296 gold badges39 silver badges55 bronze badges

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

Collectives™ on Stack Overflow

ADO.Net Entity Framework/Linq

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related