.net - Retrieving datatypes from underlying database -


IM creates an application that displays information about an underlying database may be anything but the database But either Oracle, MSSQL or My Sql I am trying to remove the datatype but it can not look right. I have a DB connection because I do not know if I need OleDbConnection or OdbcConnection . In this regard, I create a GetSchema ("Column", "MistBNam") query and get results back. It seems that there are some discrepancies with my datasets or the query gives different datatypes for different databases. For example, in my MSSQL database, I query and get an integer (which is OleDbType ) that I map to the dataet. My magnitude is no longer char - there is no length - and it confuses me a bit.

I think my main question is something like this: Are there a similar way to extract datatype in providers Is there a way to make the way and to "accurately represent" the datatype?

It seems that there is no the only way to do this: I have a schema query on OleDb Removes and converts the Datat Type to represent me, and does the same for the ODBC connection. This layer of "translation" seems to be the only way between datatype.


Comments