Using Reflection and Collections to Illiterate a Object Rational Database

Question

Hi All, Have C# question;

I've been searching for a way to lets say dynamic created objects at runtime by iterating though them and there properties/methods. so far i've played with using Reflections and foreach to illiterate the class properties. This is to display all records in various tables on a Data Grid view. However one approach I think is to use Object-rational mapping to connect, populate a dataset and then be able to display it on the Data Grid view for editing etc..

*Edit: Maybe iterating over the actually namespace of classes, all the classes inherit a class called Table so I guess there should be a method in invoking all classes at run-time to fetch the data from the database*

I've done mostly Java programming up until now so have a good idea of OO-programming just not so familiar with .NET so looking for the best approach in this.

Thanks in Advance

Answer 1

There are object-relational libraries available in .NET. If you're targeting SQL Server, use Linq to SQL, or if you need cross-database support, try the Entity Framework.