Dynamic Linq .Select() - How to handle certain null values -


I am using System.Linq.Dynamic for a project, for which the user needs to choose that on runtime Which properties to choose?

So, I have such a query:

  var query = db. Select ("New User ID, User Name, Group Max (Date specified) AS DateInserted");   

The date-specified column is not empty, but there are no groups of all users. Therefore, when a user is returned without groups, I get the following error:

  "value type 'datetime' fails because unlimited value is zero. The query should use a faucet type. "  

Can I do anything in the query? I can not empty the column.

Thanks for any help.

Faucet type date time? In this way: var query = db.Users.Select ("New UserId, Username, Date Time? (Specified as Group Date (Date specified))");

Comments