General information
Category:
Visual FoxPro and .NET
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?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only