locked
LINQ to Oracle RRS feed

  • Question

  •  

    Hi!


    What about LINQ to Oracle?

    Can I download it somewhere?

     

    Thanks.

    Friday, November 30, 2007 1:26 PM

Answers

  • There is currently no out-of-the-box LINQ to Oracle or may be some OracleProvider for LINQ to SQL from Microsoft. But you have a few options if you would like to make use of LINQ features over Oracle:

    • Learn and use LINQ to Entities which is built on top of Entity Framework (currently Beta 3). Entity Framework is designed to be data-source independant and it is likely that popular DBMS vendors such as Oracle, IBM, etc. will implement their own providers supporting Entity Framework in the near future. Current beta version of EF only supports SQL Server.
    • Use LINQ to NHibernate which is an open-source LINQ provider to be used with NHibernate. Since NHibernate supports Oracle, you will be able to use LINQ with your Oracle databases. LINQ to NHibernate is written by Ayende Rahien (http://www.ayende.com) and is currently maintained by Bobby Diaz (http://blogs.magiconsoftware.com/blogs/bdiaz/).
    • DbLinq is another open-source project intending to provide support for LINQ over Oracle, MySql, and PostgreSql. Its out-of-the-box providers only support MySql and PostgreSql.


    Friday, November 30, 2007 3:04 PM

All replies

  • There is currently no out-of-the-box LINQ to Oracle or may be some OracleProvider for LINQ to SQL from Microsoft. But you have a few options if you would like to make use of LINQ features over Oracle:

    • Learn and use LINQ to Entities which is built on top of Entity Framework (currently Beta 3). Entity Framework is designed to be data-source independant and it is likely that popular DBMS vendors such as Oracle, IBM, etc. will implement their own providers supporting Entity Framework in the near future. Current beta version of EF only supports SQL Server.
    • Use LINQ to NHibernate which is an open-source LINQ provider to be used with NHibernate. Since NHibernate supports Oracle, you will be able to use LINQ with your Oracle databases. LINQ to NHibernate is written by Ayende Rahien (http://www.ayende.com) and is currently maintained by Bobby Diaz (http://blogs.magiconsoftware.com/blogs/bdiaz/).
    • DbLinq is another open-source project intending to provide support for LINQ over Oracle, MySql, and PostgreSql. Its out-of-the-box providers only support MySql and PostgreSql.


    Friday, November 30, 2007 3:04 PM
  • Hi Alex.
    as of January 2008, DbLinq ( http://code2code.net/Db_Linq ) supports Oracle.
    It was tested on Oracle XE.

    Regards,
    George

    Saturday, January 19, 2008 4:36 PM
  • You could try looking at third party LINQ providers such as Mindscape's LightSpeed (http://www.mindscape.co.nz/products/LightSpeed/) which support Oracle 9 and above.

    There is also a very rich Visual Studio 2008 integrated model design surface to make interaction easy - you even get schema round-tripping (update your database from code or update your code from the database with just one click).

    Disclaimer: I do work for Mindscape.

    Hope that helps,

    John-Daniel Trask
    Thursday, July 17, 2008 8:10 AM
  • You can try ALinq, the bestest database linq provider, it supports MS Access, SQLite, MySQL, Oracle and Firebird database.
    please vist http://www.alinq.org

    Tuesday, July 14, 2009 12:39 PM
  • Sorry, but I have some doubts on those alternatives. LINQ to Entity and LINQ to NHibernate actually won't generate the SQL specific to the target database directly, but take the whole process in LINQ to Objects way against Entities, which will bring the cost on effeciency.
    DBLinq seems to be a good way, but it is old and I haven't studied it.
    ALinq is elegent, but not free.

    In fact, I am looking for the solution as effecient and elegent as MS officially provided LINQ to SQL over MS SQL Server, in a way of Expression Tree to analyze and translate the LINQ sentences into SQL over a certain database. So whenever we check, we can see the automatically generated SQL via Output Window, or any output console via DataContext.Log.

    Any suggestions?

    Thank you very much.

    Best regards,
    Michael

    Thursday, February 11, 2010 2:51 AM
  • According to an official statement from Oracle earlier this summer (June 2010) the company plans to enhance Oracle Data Provider for .NET (ODP.NET) to support Microsoft ADO.NET Entity Framework.

    ODP.NET Beta with Entity Framework is planned for the end of 2010, while ODP.NET Production with Entity Framework is scheduled for release in 2011.

    http://bit.ly/a0ZLUg

    -paul-

    Monday, August 16, 2010 12:12 PM
  • Hi, (1) Use Linq to Entities by adding edmx file in your project for your Oracle database.  This would require third party tools as of date as there is no Oracle provided Linq support. (2) Use "RV's LInQ to Entity debug visualizer" which is a free tool available at http://visualstudiogallery.msdn.microsoft.com/en-us/99468ece-689b-481c-868c-19e00e0a4e69 to view the native SQL (any database) generated on the fly from your Linq query.

    Good luck

    Venkat

    Thursday, September 2, 2010 9:16 AM
  • Try LinqConnect.
    We provide a LINQ to SQL compatible code with some enhancements and a more convenient designer - Entity Developer.
    Devart Team
    http://www.devart.com/dotconnect
    ADO.NET data providers for Oracle, MySQL, PostgreSQL, SQLite with Entity Framework and LINQ to SQL support
    Thursday, April 7, 2011 12:34 PM
  • Just found this really promising .....link to....LINQ to....Oracle.....from Oracle!! Based on .NET's Entity Framework like pointed out above by several members, but this actually guides your through it. Hope it helps somebody.

    http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/dotnet/EntityFrameworkOBE/EntityFrameworkOBE.htm

    • Proposed as answer by joym8 Wednesday, June 8, 2011 9:45 PM
    Wednesday, June 8, 2011 9:44 PM
  • Although an old thread, but we got update recently

    http://www.oracle.com/technetwork/database/windows/downloads/index-101290.html

    Oracle officially support entity framework & linq to oracle in this version


    No Way, No Will!
    Thursday, January 12, 2012 8:45 AM
  • Alex,

    Kellerman Software has an Oracle LINQ provider
    https://www.kellermansoftware.com/p-47-net-data-access-layer.aspx

    Friday, February 22, 2013 3:33 PM