>>And I am wondering; if I wanted to use the same type of approach for an ASP.NET application, what would be the closest to VFP CursorAdapter in .NET world? Thanks in advance.

I don't know what you did with the CursorAdapter, but I've found that:
a.- Whatever you use, be prepared to devote a couple of intense weeks to learning it. There's just no way to avoid that.
b.- I use strongly-typed datasets with SQL-Server stored procedures and views and after more than a year with them I can't see how anything could be:
-cheaper
-simpler to use (after the learning curve)
-faster in development
-faster in execution
-more completely documented and supported

This platform doesn't have the "sizzle" factor that EF and NH do, but our clients pay for steak- not sizzle- and in my judgement, there's a higher probability that it will be around 5 years from now after ORM has succummed to a newer buzzword of the day.
(Whatever happened to CASE?)

Bonnie Berent has some excellent blog entries that got me started and since then I've built my own framework and I've deployed dozens of apps with it in about the same time or faster than I'd have done the apps with VFP.
The one VFP feature that I still miss is the way the report writer integrated so seamlessy with the app, but other than that, the new platform is more productive than VFP, I think.