Querying ADO.NET DataSets using VFP’s Data Engine
Kamal Patel
Thursday, June 20, 2002
Microsoft introduced ADO.NET as a new model for accessing data through the .NET Framework. Like most new models, ADO.NET has its share of limitations. In this article, I will discuss a key limitation in ADO.NET and demonstrate how to overcome that limitation using a combination of a .NET wrapper class and a VFP COM component.
This article is geared towards intermediate to advanced developers. It assumes that developers have the skills to create and use VFP COM components, have an understanding of ADO.NET and are familiar with either C# or VB .NET. The .NET examples are provided in both VB .NET and C#. I chose Visual FoxPro to build this COM component because it is the only language that supports built in features to run SQL queries on in-memory cursors, supports serializing and de-serializing XML to its native in-memory cursors and provides on the fly compilation (something like JavaScript eval() function).
querying ado.net datasets.zip (36.9 KB)