C# and legacy databases (FoxPro)

Hi, everybody,

I stand in need of reading a FoxPro data table inside C# application. I tried standard approach and not quite managed it. I created a DSN using VFP driver and tried to configure a data adapter. The wizard created a connection, the test of the connection succeeded, and then: "The connection you have created does not work with the current adapter". How to work around the problem? I suspect that my problem has something to do with the limited ability (inability?) of the environment to use SQL statements on the FoxPro table, as a data adapter is nothing but a bunch of SQL commands. But then, I only have to fill somehow a DataSet. How to manage that in my case?

Grateful in advance, Alexey