Interrogating mySQL datatypes with ADO.NET

[Mark Rae]

Hi,

Interrogating the DataType property of a DataColumn object where the
underlying column in a mySQL table is CHAR, VARCHAR or TEXT returns
System.String for each. Is there a method to differentiate these underlying
datatypes and, if so, to interrogate the column length so that it will
return me, say, VARCHAR(20) instead of just System.String?

Any assistance gratefully received.

Best regards,

Mark Rae

 

[Sahil Malik]

What is the data provider you are using?

- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik
http://blogs.apress.com/authors.php?author=Sahil Malik

 

[tnsrbdqs]

http://www.ardice.com/Computers/Programming/Databases/ADO/

 

[rcheyelo]

http://www.ardice.com/Computers/Programming/Databases/ADO/ADO.NET/

 

[Mark Rae]

What is the data provider you are using?

Core Lab MySQLDirect .NET Data Provider 2.30

 

[Sahil Malik]

I am not a MySql expert, but seems like this level of detail isn't built
into the provider you are using. You could verify that by decompiling it
using reflector. Worst case, you might want to write up your own schema
query mechanisms.

- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik

 

[Frans Bouma [C# MVP]]

Core Lab MySQLDirect .NET Data Provider 2.30

That's an oldie They're at 2.70.1 at the moment.

To answer your original question, no, once the db type is converted to
the .net type, you're stuck with the .NET type, as the db type is not
that interesting (in theory).

If you want to know the db type, you can always use the describe table
command of mysql, or use the trick with the command builder (create a
command using the command builder object, and check which type is
created for the parameters for the various fields)

Frans.

 

[Mark Rae]

That's an oldie They're at 2.70.1 at the moment.

To answer your original question, no, once the db type is converted to the
.net type, you're stuck with the .NET type, as the db type is not that
interesting (in theory).

If you want to know the db type, you can always use the describe table
command of mysql, or use the trick with the command builder (create a
command using the command builder object, and check which type is created
for the parameters for the various fields)

OK - thanks.

 

[Mark Rae]

Worst case, you might want to write up your own schema query mechanisms.

LOL!