Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using VFP as back-end database
Message
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Miscellaneous
Thread ID:
00946258
Message ID:
00946306
Views:
16
Kevin,

>Question on using MM.NET with VFP data - I'm guessing that in order to do so, the OLE DB provider for VFP has to be used.

That's right...it's currently the only way you can access data from .NET.

>The last time I used the VFP data provider, I ran into two issues - you can't return a result set from a VFP stored proc as a dataset, and updating data requires you to provide field syntax, because the necessary schema info doesn't exist for .NET to dynamically build an update statement. (I realize that for some, this second one isn't an issue).
>
>Out of curiosity, does MM.NET do anything in particular to get around this? Let me know if I'm out in left field on any of these.

MM .NET business objects have an UpdateSelectStatement property you can set that allows the update logic to be built automatically by MM .NET / ADO.NET.

Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com
Previous
Reply
Map
View

Click here to load this message in the networking platform