>>agreeing with you in tendency (less acerbic) on the other points, but
>>
>>>VFP's data handling is an anachronism when using a server based database.
>>
>>Why ? Having the backend where-specified data mirrored in equivalent tables to feed the biz objects
>>IMHO is more sensible than EF or other ORM frameworks (nHibernate or what do you use ?).
>>Especially if you are fluent in SQL, why for need 2 different ways to access data ?
>>Do you prefer LINQ vs. SQL, as it again puts you into a MS-controlled niche compared to SQL on nealy all backends ?
>>
>>The local cursor engine (pls separate from dbf as backend data store) is the thing keeping me with vfp -
>>and is the thing making me look at Lianja, as today there is no client financing a cursor cache layer
>>with SQLite having update automatics similar to Ado.Net or vfp-Cursoradapter,
>>which is what I'd create to scratch my itches.
>
>In .NET you have local tables you can manipulate. You can use LINQ on them. Not quite as easy as VFP cursors but they are functional.

Yes, but I prefer SQL - I can switch to server or client side munging easily if I always use SQL on both tiers.

>
>Again, I do my data manipulation server side if at all possible.

On updateable data I prefer to send over the needed record batches and munge them locally - cleaner code,
was once preached as "best practice" for Ado.Net and made sense to me, even if best practice might have changed ;-)

With read-only data I try to minimze the amount of data sent across the wire.
Sometimes more, sometimes less data across the wire, depending on how much repeated data needs to be shown on screen
(i.e. if the denormalized screen data has larger footprint or not). But using local cursors and SQL I can always pick the best route
calling up the least amount of data across the wire.

But from "Not quite as easy as VFP cursors" I would interpret that for you munging serverside and storing locally
in Ado.Net or similar was at least not better than munging serverside and keeping local result sets in cursors - which was my POV.

regards

thomas