Re: Gamma?

[Reggie Burnett]

First, there is absolutely no standard that says a provider should use @ to mark parameters in SQL. Both the OleDbClient and OdbcClient use ?. We are using ? to mark parameters since the @ symbol is used by MySQL to mark user variables.

Second, what evidence do you have that the MySqlValue and derived classes are slower?

Third, I have commited some code working on the date time issue. This is not an easy issue to deal with. On one hand, there are people who want to use zero datetimes in their databases and have code like reader["datetimefield"].ToString() print out '00-00-0000 00:00:00'. Try to make this happen by returning a DateTime stuct. However, we really should return DateTime structs in most cases so what should we do?

The approach I have taken last is to include a connection string option called "allow zero datetime". When yes, MySqlDateTime objects will be returned from GetValue(i). When no, DateTime structs will be returned.

I am open to any suggestions you might have.

-reggie