Linq and Oracle,
Hi,
I have just tried to add some oracle tables to the object relational designer only to receive the message that the driver is not supported. Will we have support in the Orcas release?
Is oracle committed to supporting Linq?
They are always doing things at snails pace with java obsession. Makes me very frustrated.
Regards
Craig
No, LINQ to SQL is SQL Server only, at least in Orcas time frame. Instead you should look at ADO.NET Entity Framework, there is a sibling forum out here (it isn't clear whether it'll support Oracle out of the box but extensibility is there...)
Hi,
In my opinion this is just typical of Oracle.
I guess we will be using Linq over DataSet for all our Oracle access which will end up being much slower and more cumbersome than our equivalent SQL server access. The migration path is pretty clear to me. Our big production systems are on Oracle (sadly), but our new stuff definitely leans to SQL Server.
Thanks for your kind assistance.
Regards
Craig
Hi Craig,
Just to make it clear: Entity Framework is more or less superset of LINQ to SQL and I don't doubt that there will be Oracle support (by Microsoft or by Oracle or by some 3rd party). The problem with EF is that it is unclear what exactly will it be like and when it will be delivered.
Note also that there are a lot of 3rd party ORM products out there that let you do even more (without LINQ keywords though) even now.
Hi,
I am aware of a lot of the other products out there, and have used a number of them.
They all have a lot of drawbacks that linq does not have. It is very very clear to me that Anders and his team have thought this through. This is perhaps a good opportunity for me to state my thoughts. The C# team were clearly very distinctly aware of the drawbacks of many other ORM products. Add to that their unique position in being able to shape the language primitives. They really applied their minds, and it shows. I doubt its perfect, but darn its beautiful. Its elegant, stylish and simple - three cheers!
For any vendor (Oracle) to drag their heels in the face of this kind of innovation deserve to loose customers in my opinion.
I know that Oracle will eventually catch up. If not, then DataDirect will catch up for them, I am not blessed with an abundance of patience.
Thanks for the help.
Regards
Craig
Craig,
We are currently engaged with many .NET provider writers, including Oracle and DataDirect, to help them develop the next generation of providers to support LINQ to Entities through the Entity Framework. In fact, both Oracle and DataDirect will be speaking at a chalk talk session at Tech Ed on the provider model and integration with third party databases.
I hope this information proves helpful.
The provider writer chalk talk was not recorded in a WebCast or PodCast format, but here's a link to a blog post about the chalk talk. Oracle, IBM, DataDirect, Sybase and VistaDB were all in attendance and spoke briefly about their involvement. IBM even demonstrated an early build of their provider working with the 101 LINQ to Entities samples.