ADOX --> ADO.NET Help

[Guest]

Hi Everyone,
Is there a way to get the schema from the database using ADO.NET like you
could with ADOX. I would like to write a small project that will take the DB
structure and create functions for me. I have many stored procs that have
over 50-100 parameters and hand writing these is very tedous. So far I have
not seen anything in the help, unless I missed it. THanks for any input.
Michael

 

[Armin Zingler]

Hi Everyone,
Is there a way to get the schema from the database using ADO.NET
like you could with ADOX. I would like to write a small project that
will take the DB structure and create functions for me. I have many
stored procs that have over 50-100 parameters and hand writing these
is very tedous. So far I have not seen anything in the help, unless
I missed it. THanks for any input. Michael

System.Data.OleDb.OleDbConnection.GetOleDbSchemaTable



Armin

 

[Cor Ligthert [MVP]]

Michael,

Two samples

As Armin says

http://www.vb-tips.com/default.aspx?ID=9c2ca38c-92c1-410f-b753-528cf4c49e94

OleDbSchemaGuid.Procedures 'this you can change to get what you want

And in this part the datareader.getschemachematable
http://www.vb-tips.com/dbPages.aspx?ID=49f2cff5-56ad-44fc-a4c6-fc0d5c470f53

I hope this helps,

Cor

 

[Oenone]

Is there a way to get the schema from the database using ADO.NET like
you could with ADOX. I would like to write a small project that will
take the DB structure and create functions for me. I have many stored
procs that have over 50-100 parameters and hand writing these is very
tedous.

If you're trying to get the details of stored procedure parameters (which
I'm guessing you may be from your question), and you're using SQL Server
2000 or later, you can use the INFORMATION_SCHEMA views to do retrieve this
information for you.

\\\
select *
from INFORMATION_SCHEMA.PARAMETERS
where SPECIFIC_NAME = 'stored_proc_name'
///

There are a number of similar views (see the Views section in the master
database in Query Analyzer or Enterprise Manager for the rest) and they can
give you a huge amount of information about the db schema in a
forward-compatible manner.

HTH,

 

[Guest]

Hi Everyone,
Thanks for the replys. I will look into the options. I started to look at
ADOX in .Net, but I was hoping to do it in pure .Net. I'll take a look at the
links you all provided. Thanks again for the suggestions.
Michael