On Jan 17, 2:42 pm, Edwin van Holland <edwinvanholl...@hotmail.com>
wrote:

My biggest problem is that I am not given a column in a table, so that
I could query it. For instance, I am some times given a stored
procedure definition and want to know what the parameter types are.

I can query the metadata table, but it will always return a string
that represents that type on the DBMS. I don't want to have a switch
statement with all the types on the database to map to a .NET type.
Even more, I think calling FillSchema or something similar is overkill
for something that may be called many, many times.

My overall goal to provide the developers here code that would
generate the C# code that would execute a stored procedure. I have
written code that will access the meta data tables and figure out
information about the stored procedures. Right now, my library
supports MySQL, Oracle, MSSQL, PostgreSQL and Access.

With a large number of supported databases and the potential for more,
manually entering in type conversion is buggy and tedious.

I was hoping there was a tool available or a trick to getting the
information.

Thanks for your reply.

On Jan 18, 7:38 am, "Ignacio Machin \( .NET/ C# MVP \)" <machin TA
laceupsolutions.com> wrote:

Somewhere at some point, someone wrote code to get the .NET type from
the database. There are two possibilities: each RDBMS is responsible
for specifying the mapping; Microsoft somehow wrote a generic class
that could extract the type given an instance of the result. But,
again, I don't have a result.