We need to read data from FoxPro 8 with C#. I'm gonna do some operations, and will push some of thoses data to an SQL Server database. We are not sure what's best method to read those data.

I saw OLE DB and ODBC; what's best?

  1. The export program will run each night, but my company runs 24h a day.
  2. The DBF could sometimes be huge.
  3. We DON'T need to modify data.
  4. Our system, wich use FoxPro, is quite unstable: I need to find a way that ABSOLUTELY do not corrupt data, and, ideally, do not lock DBF files while reading.
  5. Speed is a minor requirement: it must be quick, but requirement #4 is most important.

thank you!