Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is there a LINQ to VFP tables?
Message
 
To
25/02/2008 07:48:36
General information
Forum:
ASP.NET
Category:
Databases
Miscellaneous
Thread ID:
01296009
Message ID:
01296305
Views:
7
>Is there a tool in Visual Studio to use LINQ to directly query Foxpro free tables? If there is not now, might someone be building one?

LINQ to SQL only works against SQL Server.

LINQ to Entities (the ADO.NET Entity Framework) will work against other providers like Oracle, MySql, etc. but it requires creating a special provider interface. I doubt Microsoft will provide one for FoxPro data - if anything it'll have to come from the community.

You can use Fox tables with OleDb and using ADO.NET. .NET 3.5 also includes LINQ to DataSet which allows some sort of LINQ functionality against data returned from any ADO.NET data source, but it's nothing as easy to use as LINQ to SQL is for example.

With Fox data you're pretty much left with good old fashioned DataReaders or DataSets (or possibly using another OR/M framework like nHibernater or SubSonic).

+++ Rick ---


>
>The reason I am asking is to understand if I can begin to write new Visual Studio apps to read/write data against Foxpro tables in an environemnt where the data must remain in Foxpro tables so that other legacy VFP apps can remain in use for several more years.
+++ Rick ---

West Wind Technologies
Maui, Hawaii

west-wind.com/
West Wind Message Board
Rick's Web Log
Markdown Monster
---
Making waves on the Web

Where do you want to surf today?
Previous
Reply
Map
View

Click here to load this message in the networking platform