Connector/Net, suggestion
Posted by: Nico den Boer
Date: January 17, 2005 07:39AM

I am working with MySQL® Connector/Net and Microsoft Visual Studio.NET 2002.

Below a suggestion for improvement of the Connector.
I cannot implement this myself, since this seem to require Visual Studio.NET 2003 (2002 cannot find System.Drawing while compiling).

In the file NativeDriver.cs, the methods GetFieldMetaData and
GetFieldMetaData41 take care of retrieving metadata while reading data from the server.

It would be more practical if a MySqlDateTime would be interpreted as a System.DateTime.

This is why:
I normally retrieve data (roughly) the following way:

DataSet ds = new DataSet();
MySqlDataAdapter da = new MySqlDataAdapter(sql, m_connString);

In case a DataSet is used as return value of a webservice, the generated XML that arrives at the client has the datatype MySqlDateTime. For applications written in a Microsoft language which use webservices to retrieve content, this gives some practical problems.

Options: ReplyQuote

Written By
Connector/Net, suggestion
January 17, 2005 07:39AM
January 17, 2005 07:43AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.