Hello,
I am new to DBlinq and I have a problem and I don't know if it is
because I'm doing something wrong, if it is because a bug or "not
implemented" :)
I am using MySql.
The problem is when I try to use dates in my query.
The code:
var ids = from i in ctx.Markets
where i.DateScheduled > DateTime.Now
select i.MarketId;
Console.WriteLine(ids.Count());
A MySqlException is thrown:
"You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near ':52:15.9545502+01:00)' at line 3"
When I inspect the command it reads like:
"SELECT COUNT(*)\r\nFROM `MyDatabase`.`Markets`\r\nWHERE
(`DateScheduled` > 2011-01-09T17:52:15.9545502+01:00)"
As you can see the date parameter seems to lacks the enclosing ''.
I shouldn't have to do the enclosing myself? If so where would I
easily do that. If not in which type can I edit so that the value is
enclosed. (
I just started using DBLinq and to browse the src-tree so I don't find
very easily yet :)
Thanks in advance
/Magnus Olsson
--
You received this message because you are subscribed to the Google Groups
"DbLinq" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/dblinq?hl=en.
