Programming Articles

In this article you learn how to use the GetSchema() method on the DbConnection class to retrieve tables, views, columns, index, stored procedures and more from any database system. This method is implemented by each data provider to retrieve schema information in a generic fashion. What do you do with this information? You can present column names to your user to let them select columns to filter on for a report. You can use it to build your own code generator. You can even use it to create a SQL comparison tool. Read and follow along with this article to see how easy it is to use GetShema() to accomplish these various tasks.