I’ve been working on Telerik’s OpenAccess ORM tool. It is a pretty neat tool where it allows you to perform ReverseMapping on your existing Database Schema and generate class files for each table.

It is also great that it has built in tools that integrate with Visual Studio 2008. If you have written a lot of stored procedures in your lifetime, the OpenAccess ORM will let you pick the stored procedures you want to create a mapping for. It generates static method that return an IEnumerable that you can bind it to any Web Control.

Here’s a sample code that binds data return by stored procedure: cleanerGetPerfectScoresByDate

IObjectScope scope = ObjectScopeProvider1.GetNewObjectScope();
 IEnumerable res = CustomerSatisfactionData.StoredProcedure.cleanerGetPerfectScoresByDate(scope, StartDate.SelectedDate,
                EndDate.SelectedDate);

//Bind to Grid here:

RadGrid1.DataSource = res;