You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I have a table with 2 date fields, created as the new (date) datatype in SQL Server 2008. I am managing to insert a record, however, when I try to retreive it with LINQ, I am getting an error:-
"Object of type 'System.DateTime' cannot be converted to type 'System.String'."
My LINQ is as follows:-
Resume resume = (from p in db.Resumes
where p.ResumeID == resumeID
select p).ToList().FirstOrDefault();
and the SQL that is being produced is
SELECT [t0].[CompanyAddress], [t0].[CompanyTitle], [t0].[CompanyWebsite], [t0].[DateFrom], [t0].[DateTo], [t0].[Description], [t0].[JobTitle], [t0].[ResumeID]
FROM [dbo].[Resume] AS t0
WHERE ([t0].[ResumeID] = 5)
If I change the datatype from date to datetime, everything works fine
Is there a problem with Subsonic on the new datatype (date) ?
Thanks
The text was updated successfully, but these errors were encountered:
Hi
I have a table with 2 date fields, created as the new (date) datatype in SQL Server 2008. I am managing to insert a record, however, when I try to retreive it with LINQ, I am getting an error:-
"Object of type 'System.DateTime' cannot be converted to type 'System.String'."
My LINQ is as follows:-
Resume resume = (from p in db.Resumes
where p.ResumeID == resumeID
select p).ToList().FirstOrDefault();
and the SQL that is being produced is
SELECT [t0].[CompanyAddress], [t0].[CompanyTitle], [t0].[CompanyWebsite], [t0].[DateFrom], [t0].[DateTo], [t0].[Description], [t0].[JobTitle], [t0].[ResumeID]
FROM [dbo].[Resume] AS t0
WHERE ([t0].[ResumeID] = 5)
If I change the datatype from date to datetime, everything works fine
Is there a problem with Subsonic on the new datatype (date) ?
Thanks
The text was updated successfully, but these errors were encountered: