Linq to Sql providers

  • Thread starter Thread starter dsaf
  • Start date Start date
D

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
 
dsaf said:
I have two questions regarding Linq to Sql providers:
1. Are there any other besides MS SQL Server available?
Click to expand...

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.
Click to expand...

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#)
------------------------------------------------------------------------
 
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...
 
Linq to Sql is for MS SQL Server.
Click to expand...

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.
Click to expand...

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.
Click to expand...

But is far from impossible...

FB, I thank you for your help

Best,

Roger
 
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...
 
dsaf said:
Why then MS doesn't say so, as in "Linq to MSSQL"?
Click to expand...

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.
Click to expand...

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...
Click to expand...

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

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

Miha and I have not any problem with that.

:-)

Cor
 
Cor said:
Frans,

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

Miha and I have not any problem with that.
Click to expand...

I didn't know I needed your permission

FB
:-)

Cor
Click to expand...


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