This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
While trying to update a record using Mysql5 the generated update statement: UPDATE CollectionObject SET LastEditTime = '2/14/2012 12:00:00 AM', LastHarvestTime = '3/16/2012 2:29:36 PM' ... is invalid, if i try to run the statement manually mysql complaints about the wrong date time format. I am also not getting any SqlException/Exception when doing a SaveChanges() This is using an express edition downloaded today. |
|
|
|
|
The statement we actually send is: where the pN parameters are DateTimes, not strings, so it should run fine when actually executed. The substitution of values for parameters is done when printing the trace output, just to make the trace more readable. You can create a logger that formats parameters differently by implementing the ILogger interface. In your LogSql implementation, cast the object to CommandLog and you will be able to access the actual command text and parameter names and values, and format them as required. |
|
|
|
