I am trying to get the no. of days by subtracting 2 dates, but both these trials say - 'DataSet does not support system.Nullable<> - Using C#, Linq To Entities
public DataTable GetData()
{
var qry = from a in MyDB.tblBranch.Where(a=>a.branchid==1)
join e in MyDB.tblEmp on a.Eid equals e.Eid
select new
{
days = System.Data.Objects
.EntityFunctions.DiffDays(a.ExitDate,a.EnterDate)
//days = System.Data.Objects.SqlClient.SqlFunctions.
//DateDiff("dd",a.ExitDate,a.EnterDate)
};
DataTable dt = qry.ToDataTable();
return dt;
}