Can I use LINQ to get to a VFP table?

[cj]

Can I use LINQ in VB .Net 2008 to get to a Visual FoxPro Table? I've
seen demos of it with SQL Server but they've used it with a server
browser and I don't think that'd work when I need to see VFP tables.

[Cor Ligthert[MVP]]

Linq to SQL is only for SQL server.

Linq to DataSet is for others, however that is not direct to retrieve the
dataset.

http://msdn2.microsoft.com/en-us/library/bb386977.aspx

Cor

"cj" <[e-mail] in bericht
news:O2**************@TK2MSFTNGP02.phx.gbl...

Can I use LINQ in VB .Net 2008 to get to a Visual FoxPro Table? I've seen
demos of it with SQL Server but they've used it with a server browser and
I don't think that'd work when I need to see VFP tables.

[cj]

Thanks. Linq to DataSet doesn't sound very helpful to me. It sounds as
if I'd have to load all the data I might be needing into datasets then
be able to query them vial Linq. I need to do queries, both reading and
writing, to these tables while our business system continue to work with
the data as well. This will be a real time portal into our system for
customers to inquire about account balances and set up accounts. I
can't load every customers information into data sets on the off chance
they'll submit an inquiry for their balance. I guess Linq will not be
of much help to me since I'm forced to pull most data from VFP tables.
Am I misunderstanding anything?

Cor Ligthert[MVP] wrote:

Linq to SQL is only for SQL server.

Linq to DataSet is for others, however that is not direct to retrieve
the dataset.

http://msdn2.microsoft.com/en-us/library/bb386977.aspx

Cor

"cj" <[e-mail] in bericht
news:O2**************@TK2MSFTNGP02.phx.gbl...

>Can I use LINQ in VB .Net 2008 to get to a Visual FoxPro Table? I've
seen demos of it with SQL Server but they've used it with a server
browser and I don't think that'd work when I need to see VFP tables.

[Steven Cheng[MSFT]]

Hi Cj,

I'm afraid so far the built-in LINQ-SQL feature won't help much for Visual
Foxpro. There does exists some 3rd party community that are working on some
LINQ to other db projects:

#DbLinq Project: Linq Provider for MySql, Oracle and PostgreSQL
http://code2code.net/DB_Linq/

http://www.ayende.com/projects/scratch-pad.aspx

however, direct LINQ to VFP support is still uncertainty.

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------

>Date: Wed, 02 Jan 2008 13:31:42 -0500
From: cj <[e-mail]>
User-Agent: Thunderbird 2.0.0.6 (Windows/20070728)
MIME-Version: 1.0
Subject: Re: Can I use LINQ to get to a VFP table?

>
Thanks. Linq to DataSet doesn't sound very helpful to me. It sounds as
if I'd have to load all the data I might be needing into datasets then
be able to query them vial Linq. I need to do queries, both reading and
writing, to these tables while our business system continue to work with
the data as well. This will be a real time portal into our system for
customers to inquire about account balances and set up accounts. I
can't load every customers information into data sets on the off chance
they'll submit an inquiry for their balance. I guess Linq will not be
of much help to me since I'm forced to pull most data from VFP tables.
Am I misunderstanding anything?

Cor Ligthert[MVP] wrote:

>Linq to SQL is only for SQL server.

Linq to DataSet is for others, however that is not direct to retrieve
the dataset.

http://msdn2.microsoft.com/en-us/library/bb386977.aspx

Cor

"cj" <[e-mail] in bericht
news:O2**************@TK2MSFTNGP02.phx.gbl...

>>Can I use LINQ in VB .Net 2008 to get to a Visual FoxPro Table? I've
seen demos of it with SQL Server but they've used it with a server
browser and I don't think that'd work when I need to see VFP tables.

[cj]

Thanks.

Steven Cheng[MSFT] wrote:

Hi Cj,

I'm afraid so far the built-in LINQ-SQL feature won't help much for Visual
Foxpro. There does exists some 3rd party community that are working on some
LINQ to other db projects:

#DbLinq Project: Linq Provider for MySql, Oracle and PostgreSQL
http://code2code.net/DB_Linq/

http://www.ayende.com/projects/scratch-pad.aspx

however, direct LINQ to VFP support is still uncertainty.

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------

>Date: Wed, 02 Jan 2008 13:31:42 -0500
From: cj <[e-mail]>
User-Agent: Thunderbird 2.0.0.6 (Windows/20070728)
MIME-Version: 1.0
Subject: Re: Can I use LINQ to get to a VFP table?

>Thanks. Linq to DataSet doesn't sound very helpful to me. It sounds as
if I'd have to load all the data I might be needing into datasets then
be able to query them vial Linq. I need to do queries, both reading and
writing, to these tables while our business system continue to work with
the data as well. This will be a real time portal into our system for
customers to inquire about account balances and set up accounts. I
can't load every customers information into data sets on the off chance
they'll submit an inquiry for their balance. I guess Linq will not be
of much help to me since I'm forced to pull most data from VFP tables.
Am I misunderstanding anything?

Cor Ligthert[MVP] wrote:

>>Linq to SQL is only for SQL server.

Linq to DataSet is for others, however that is not direct to retrieve
the dataset.

http://msdn2.microsoft.com/en-us/library/bb386977.aspx

Cor

"cj" <[e-mail] in bericht
news:O2**************@TK2MSFTNGP02.phx.gbl...
Can I use LINQ in VB .Net 2008 to get to a Visual FoxPro Table? I've
seen demos of it with SQL Server but they've used it with a server
browser and I don't think that'd work when I need to see VFP tables.