Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP and .NET Data Comparison
Message
General information
Forum:
Visual FoxPro
Category:
Visual FoxPro and .NET
Miscellaneous
Thread ID:
01080965
Message ID:
01080974
Views:
36
I agree. You should use SQL Server as it compares apples to apples.

>VFP and .NET Data Comparison
>OK here we go... First lets establish some base stuff.
>
>What are the unique characteristics of each technologies data access methods ?
>
>VFP
>Can open DBF files locally.
>Can access data via ODBC and OLEDB
>Data is maintained in global memory space
>Has a unique DML Syntax
> REPLACE ALL
> DELETE FOR
> UPDATE/INSERT
> SELECT
> SCAN FOR
>
>
>.NET
>All data is considered remote data
>Can access data via ODBC, OLEDB and native .net data providers
>Data is maintained in memory via objects
>All data access is done via object/property syntax.
>Future tech LINQ has capabilities similar to the SELECT statement in VFP.
>
>This is the start of my list. Contributions to the list would be appreciated…
>
>I would like to focus our discussion on accessing data from SQL Server. Each platform does a good job of retrieving data from SQL. While the .DBF does have its benefits I think we should focus on how it behaves in a client/server/distributed world. Sound good?
>
>
>Rodman
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform