Google

Friday, February 02, 2007

No Oracle DLinq Support

Recently I had a chance to play around with DLINQ that came out in the "Microsoft Visual Studio Code Name “Orcas” - LINQ CTP (May 2006)". I was blown away by the ability to create a Data Access Layer with out writing a single sql statement.

DLINQ stands for Database Language INline Query. What this means is that we no longer have to write sql statements as strings but can compile them as constructs of the application and let the provider module build the proper query for us at execution time based on the IL that was generated. Seeing this in action was unbelievable.

I spent a good bit of time reading all the material and examples and just couldn't wait until I could try it out with Oracle. It didn't take me long to determine that there was no Oracle support built in to the product. The reading that I did did point out that there is a framework in place for any provider to create their own LINQ module. As of yet, I have found no information stating that Oracle is or plans on making an Oracle DLINQ provider.

For those of us Oracle Developers out there this is a must have in the future. Hopefully Oralce will not make us wait too long for it.

No comments: