I'm working on a ASP.NET MVC project with Entity Framework, and I want to return value of one field from an database, and I won't to return full record, just value of one field.
This what I try :
public JsonResult DUR_json(string FL)
{
var R = from F in DB_Context.Con.FLs where F.CODE_FL == FL select F.DUR_FL.First();
return Json(new { DUR = R });
}
But this code returns the full record, please any help ? Thanks in advance.
You need the bracets
Like this :
var R = (from F in DB_Context.Con.FLs where F.CODE_FL == FL select F.DUR_FL);
Wish this help.
Note : change the from Entity in the title to from database, this will help others to understand.
Just select your field and then return first result:
var R = (from F in DB_Context.Con.FLs
where F.CODE_FL == FL
select F.DUR_FL).First();
Consider using FirstOrDefault() instead of First() if there might be no records with given CODE_FL
DUR_FL
DUR_FL is a navigation property according to your query F.DUR_FL.First() what type DUR_FL has?View : DbExpressionBinding requires an input expression with a collection ResultType. Parameter name: inputDUR_FL is a field in database