Programming/Databasing with Visual FoxPro

Question

I work for a company that uses a program that uses Foxpro as its database.

I'm actually a little bit confused if Visual FoxPro is just a DB or its a programming lagnauge + database combined.

I want to create some software to integrate with it, but I just need to manipulate the date in the database (As i do not have access to the source).

Is there a SQL Management Studio equalivelent to Visual FoxPro, and can I see the tables and data by looking at the Database files? or is it all integrated some how into the programming and I would need the source to manipulate it?

Answer 1

The best SQL Management Studio equivalent would be the VFP IDE. However, as a C# developer you might prefer to use LINQPad so that you can work with the data using LINQ and not have to know anything about the VFP syntax. As far as writing some C# code to manipulate VFP data… I would suggest checking out LINQ to VFP and the VFP EF Provider.

Full disclosure: I wrote the LINQPad Provider, LINQ to VFP, and the VFP EF Provider so I might be a bit bias :)