LINQ, can't construct datetime
I need to construct linq, but day (date time type, i.AllowedTime.AllowedDate.Day), hours and minutes (int type) stores differently. I try to make it:

            DateTime date = DateTime.Now.Date;
            IQueryable<ITW2012Mobile.Core.DataTable.MeetingModel2> result = null;
            if (status == MeetingStatus.RequestedOfYou)
            {
                
                result = from i in _dbContext.Meetings
                         where i.UserInvitedID == CurrentUserID && i.MeetingStatus == null && EntityFunctions.TruncateTime(i.AllowedTime.AllowedDate.Day) >= date
                         select new ITW2012Mobile.Core.DataTable.MeetingModel2()
                         {
                             Name = i.UserInviter.FirstName + " " + i.UserInviter.LastName,
                             Company = i.UserInviter.Company,
                             MeetingID = i.MeetingID,
                             Time = EntityFunctions.AddMinutes(EntityFunctions.AddHours(i.AllowedTime.AllowedDate.Day, i.AllowedTime.Hour).Value, i.AllowedTime.Minute).Value,
                             Image = i.UserInviter.ProfileImage,
                             Username = i.UserInviter.aspnet_User.UserName
                         };
            }

but got an exception :

> {"The datepart hour is not supported by date function dateadd for data
> type date."}

how to do it?

LINQ, can't construct datetime
===

I need to construct linq, but day (date time type, i.AllowedTime.AllowedDate.Day), hours and minutes (int type) stores differently. I try to make it:

            DateTime date = DateTime.Now.Date;
            IQueryable<ITW2012Mobile.Core.DataTable.MeetingModel2> result = null;
            if (status == MeetingStatus.RequestedOfYou)
            {
                
                result = from i in _dbContext.Meetings
                         where i.UserInvitedID == CurrentUserID && i.MeetingStatus == null && EntityFunctions.TruncateTime(i.AllowedTime.AllowedDate.Day) >= date
                         select new ITW2012Mobile.Core.DataTable.MeetingModel2()
                         {
                             Name = i.UserInviter.FirstName + " " + i.UserInviter.LastName,
                             Company = i.UserInviter.Company,
                             MeetingID = i.MeetingID,
                             Time = EntityFunctions.AddMinutes(EntityFunctions.AddHours(i.AllowedTime.AllowedDate.Day, i.AllowedTime.Hour).Value, i.AllowedTime.Minute).Value,
                             Image = i.UserInviter.ProfileImage,
                             Username = i.UserInviter.aspnet_User.UserName
                         };
            }

but got an exception :

> {"The datepart hour is not supported by date function dateadd for data
> type date."}

how to do it?
