Linq to Sql providers

[dsaf]

I have two questions regarding Linq to Sql providers:
1. Are there any other besides MS SQL Server available?
2. How to program custom Linq to Sql provider? (Obviously I expect only some
guidelines and "getting started" type of advice.

Thank you in advance,

Roger

 

[Frans Bouma [C# MVP]]

I have two questions regarding Linq to Sql providers:
1. Are there any other besides MS SQL Server available?

Linq to Sql is for MS SQL Server. If you want to use Linq with another
type of database you need something else than Linq to Sql.

2. How to program custom Linq to Sql provider? (Obviously I expect only some
guidelines and "getting started" type of advice.

Linq to Sql doesn't support custom providers as a necessary interface
is internal. You therefore can't write support for other databases. It
also would have been very difficult to do so, as writing a Linq provider
isn't easy.

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#)
------------------------------------------------------------------------

 

[Miha Markic]

In addition to Frans' comment.
If you are looking for a best ORM out there then check out Frans'
LLBLGenPro - you won't regret it.
If you are just looking to a free LINQ to SQL alternative that supports
multiple databases (plus other improvements) then take a look at forthcoming
Entity Framework.
There is also a plethora of both free and commercial ORM products out
there...

 

[Misbah Arefin]

From Charlie Calvert's Blog
http://blogs.msdn.com/charlie/archive/2008/02/28/link-to-everything-a-list-of-linq-providers.aspx

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

 

[dsaf]

Linq to Sql is for MS SQL Server.

Why then MS doesn't say so, as in "Linq to MSSQL"?

If you want to use Linq with another type of database you need something
else than Linq to Sql.

It seems I will have to. I would prefer solution that comes with .Net but MS
is just not making it possible. Don't really understand this decision, they
decided to officially provide an ORM solution (shipped with framework 3.5)
but then they decide to lock it in.

Linq to Sql doesn't support custom providers as a necessary interface is
internal. You therefore can't write support for other databases. It also
would have been very difficult to do so, as writing a Linq provider isn't
easy.

But is far from impossible...

FB, I thank you for your help

Best,

Roger

 

[dsaf]

Thank you Mishbah.

Alas, as I understood from previous replies, I will not be able to plug
these providers into Linq to Sql, since this is not supported. It seems this
could have been a rather simple solution...

 

[Frans Bouma [C# MVP]]

Why then MS doesn't say so, as in "Linq to MSSQL"?

that's something for MS to answer

It seems I will have to. I would prefer solution that comes with .Net but MS
is just not making it possible. Don't really understand this decision, they
decided to officially provide an ORM solution (shipped with framework 3.5)
but then they decide to lock it in.

If you want an O/R mapper with full linq support, check LLBLGen Pro:
http://www.llblgen.com . I'm the lead developer of LLBLGen Pro.

But is far from impossible...

True, it costed me 10 months full time work

See my blog (see sig) for the articles I wrote about writing a Linq
provider.

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#)
------------------------------------------------------------------------

 

[Cor Ligthert [MVP]]

Frans,

Advertising time is over again. Let others do that for you in newsgroups.

Miha and I have not any problem with that.



Cor

 

[Frans Bouma [C# MVP]]

Frans,

Advertising time is over again. Let others do that for you in newsgroups.

Miha and I have not any problem with that.

I didn't know I needed your permission

FB

Cor

--
------------------------------------------------------------------------
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#)
------------------------------------------------------------------------

 

[Cor Ligthert [MVP]]

I didn't know I needed your permission

Not mine, I tried to warn you that others maybe would do that.



Cor