This code is supposed to get a DateTime from a linq expression.
DateTime orderDate = (from order in db.Orders where order.Id == orderRules.OrderId select order.DatumTijd).SingleOrDefault();
Instead I get this errorMessage:
'System.Data.Entity.Core.EntityCommandExecutionException' occurred in EntityFramework.SqlServer.dll but was not handled in user code
What could be wrong?
DateTime? orderDate = (from order in db.Orders where order.Id == orderRules.OrderId select order.DatumTijd).FirstOrDefault();