I need to get the Database schema information using Microsoft.Practices.EnterpriseLibrary.Data. I have not found a means to do this with these tools. I found an article using ADO.Net OpenSchema, but I do not want to add multiple database connections to my application.
Does anyone know how to gain access to this information? I use selects to tables and stored procedure/queries in SQL Server and MS Access. The type of information that I need to derive is the column name, column data type, column size (length), column precision, column scale, column order (ordinal), is the column null able, is the column part of the primary key, is the column part of an index, is the column for replication or not for replication, is the column a GIUD and is the column an identity or the equivalent.
Thank in advance for any help.