Well, I have been playing with Linq, specifically with Oracle.  First of all, the only way I could find to make this work is to use a third party software, OraDirect.Net by Core Lab.  Their product is great.   Perhaps that statement is biased by the fact that they are the only one's building a library to support Linq to Sql (as far as I know). 

There is certainly room for improvement.  I've crashed VS a few times because I was trying to force OraDirect to do something it doesn't support.  So, error handling needs some work.  Also, there are still a few too many things that require manual labor (I guess I am getting lazy in my old age).  Regardless, the guys at Core Lab are working really hard to address the barrage of feedback on their product.

posted on Thursday, February 28, 2008 1:15 AM
Filed Under [ .Net Oracle Linq ]

Comments

Gravatar
# re: Linq to Oracle *sigh*
on 7/17/2008 2:42 AM
Hi Will,

If you're interested in full Oracle support with LINQ querying I'd love to get your feedback on one of our products, LightSpeed (http://www.mindscape.co.nz/products/LightSpeed/). It supports querying over Oracle, SQL Server, MySQL, PostgreSQL, SQLite, VistaDB, FireBird and SQL CE.

It also has a very rich domain modeling surface that integrates into Visual Studio 2008 which complete database round-tripping (e.g. sync your changes with to the database or from the database).

Just to be clear, I do work for Mindscape but I would love to get your feedback. Email me if you have any questions.

Cheers,

John-Daniel Trask

Post A Comment
Title:
Name:
Email:
Comment:
Verification: