Bite the bullet.

With VFP free tables (and only 12 of them):

1) Create a new SQL server database and import the free tables using the OLE DB provider (< 1 hour).
2) Generate an Entity Data Model (Entity Framework EDM) from the database using edmgen.exe in order to generate strongly typed data objects ( < 1 hour)
3) Configure a new project to use the new EDM and starting coding … (using LINQ to Entities for data access)

I see no advantage to the 2 stage approach.

>Hi
>A client has a fairly complex VFP app (I wrote it) that needs to be converted to C# in two stages:
>1- convert the GUI and business logic to C#, leaving the data in VFP free tables
>2- convert the VFP free tables to SQL-Server
>
>There are about a dozen tables involved. fewer than 100 transactions per day, but each transaction looks at every table several times, using indexing.
>25000 records in the largest table..
>What is the best way to access and update the VFP tables from C#, VS2008?