Query Vs. C# Method To Retrieve Database Metadata

I need to retrieve for each table in the database the following info: All columns names For each column its type Type max length The possible way to do that is to run a query (e

Solution 1:

Use either method and cache the result

Meta data doesn't change under normal operation so performance is a non-issue