How can we define a class in .NET which would be able to support a reference definition such as:

loDataSet.Tables("Temp")

Where loDataSet would be the object created from the class and Tables would be a property of the class but would accept an ID. Basically, I would like to be able to do something like:

llMandatory = oApp.oTable.Table("MyTableName").Field("MyFieldName").Mandatory

So, at initialization, I would read all my tables and populate them into the object. And, for each table, I would do a SQL into the field table to get all the fields with their property.

Presently, I read the data dictionary on request. I would like to load it all into an object at startup. My data dictionary has a Table table and a Field table to serve the purpose. The Table table contains some fields which define the table properties. The Field table contains x amount of records for each Table with about 200 fields so the framework knows how to deal with them.