Linq across oracle, access?

[Ilyas]

Hi

Is linq just for Sql Server or can you use if for Oracle, Access etc

 

[Jon Skeet [C# MVP]]

Is linq just for Sql Server or can you use if for Oracle, Access etc

LINQ to SQL is just for SQL Server (and SQL Mobile). LINQ itself is a
very general, nebulous term.

The ADO.NET Entity Framework is a pluggable ORM which incorporates LINQ
and will support drivers for multiple databases.

 

[Ilyas]

LINQ to SQL is just for SQL Server (and SQL Mobile). LINQ itself is a
very general, nebulous term.

The ADO.NET Entity Framework is a pluggable ORM which incorporates LINQ
and will support drivers for multiple databases.

Does that mean then If i had an oracle database I wouldnt be able to
use Linq with it?

 

[Jon Skeet [C# MVP]]

Does that mean then If i had an oracle database I wouldnt be able to
use Linq with it?

It means you wouldn't be able to use LINQ to SQL with it.

You need to be very precise about what you mean: "LINQ" is too general
a term in this case.

Jon

 

[Marc Gravell]

You should be able to use the Entity Framework LINQ provider:
http://blogs.microsoft.co.il/blogs/...entity-framework-oracle-provider-support.aspx

As Jon observes, "LINQ" is a very vague term. For example, NHibernate
is getting a LINQ API; and I'm pretty sure NHibernate supports Oracle.

Marc

 

[Frans Bouma [C# MVP]]

You should be able to use the Entity Framework LINQ provider:
http://blogs.microsoft.co.il/blogs/bursteg/archive/2007/12/07/ado-net-
entity-framework-oracle-provider-support.aspx

As Jon observes, "LINQ" is a very vague term. For example, NHibernate
is getting a LINQ API; and I'm pretty sure NHibernate supports Oracle.

I wouldn't hold my breath for that one. I'd be surprised if it is
released before the summer. Writing a full provider (not a toy) is a
lot of work, and even though some work has been done, it's still a lot
of work to get everything implemented.

FB

--
------------------------------------------------------------------------
Lead developer of LLBLGen Pro, the productive O/R mapper for .NET
LLBLGen Pro website: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------

 

[Frans Bouma [C# MVP]]

Does that mean then If i had an oracle database I wouldnt be able to
use Linq with it?

Within a month you will, using LLBLGen Pro and our linq provider. It
goes into beta this week.

FB

--
------------------------------------------------------------------------
Lead developer of LLBLGen Pro, the productive O/R mapper for .NET
LLBLGen Pro website: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------

 

[Marc Gravell]

        I wouldn't hold my breath for that one.

Fair enough (you're an awful lot closer to that area than me ;-p).