<p>I can connect with the DataContext to the Oracle database however I get errors in running the query against the oracle database.  I looked at the SQL generated and it is for MSSQL and not Oracle PSQL.  </p>

<p>Does anybody know of a decent easy to use wrapper to use LINQ against an Oracle Database?</p>

[{'answer_id': 30802, 'author': 'Keith', 'author_id': 905, 'author_profile': 'https://Stackoverflow.com/users/905', 'pm_score': 0, 'selected': False, 'text': '<p>Not an easy way, at least until a good provider is produced.</p>\n\n<p>Really MS should provide at least an OLEDB Linq provider.  After all, Linq to Sql is basically an implementation of IQueryable with designer support.</p>\n'}, {'answer_id': 30809, 'author': 'Greg Hurlman', 'author_id': 35, 'author_profile': 'https://Stackoverflow.com/users/35', 'pm_score': 5, 'selected': True, 'text': '<p>No, LINQ to SQL is very much MS SQL only - think of it as a client driver.</p>\n\n<p><a href="http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1623471&amp;SiteID=1" rel="noreferrer">Microsoft is/was helping Oracle and DataDirect develop providers for Oracle and other non-MS database servers.</a></p>\n'}, {'answer_id': 30820, 'author': 'Dillie-O', 'author_id': 71, 'author_profile': 'https://Stackoverflow.com/users/71', 'pm_score': 2, 'selected': False, 'text': "<p>One thing you might look into is that there is now LINQ to Entities, which leverages the MS Entity Framework, which I believe is DB agnostic. I'm still looking into how it works myself, but if you could create an ADO.NET Data Entity that interfaces with Oracle, you could then use LINQ against that Entity.</p>\n"}, {'answer_id': 30859, 'author': 'Geoff', 'author_id': 1097, 'author_profile': 'https://Stackoverflow.com/users/1097', 'pm_score': 2, 'selected': False, 'text': '<p>Do look at Linq to entities though.  I have a datareader populate a collection of objects that are mapped to the oracle table.  I can use linq to query that collection in very powerful, simple, and easy ways.  I love it.  Highly recommend.</p>\n'}, {'answer_id': 32467, 'author': 'vzczc', 'author_id': 224, 'author_profile': 'https://Stackoverflow.com/users/224', 'pm_score': 3, 'selected': False, 'text': '<p>We use the OraDirect driver from Devart. It includes ADO.NET Entity framework support. You can download a trial version <a href="http://www.devart.com/news/2008/directs475.html" rel="nofollow noreferrer">here</a>. You may then use LINQ to entities or entity SQL on top of this.</p>\n\n<p>The pricing of this is quite developer friendly, you pay per developer seat and you may use it however you like.  </p>\n\n<p>Another big advantage of this driver is that you can use it without installing an Oracle client, this is a big plus and worth the price alone.</p>\n\n<p>@Greg: We evaluated the datadirect drivers as well, but the performance was poor and  cost astronomical.</p>\n\n<p>Edit: It seems DevArt announced a beta with  <a href="http://devart.com/news/2008/linq100b.html" rel="nofollow noreferrer">LINQ support</a> recently</p>\n'}, {'answer_id': 179586, 'author': 'Skeolan', 'author_id': 9640, 'author_profile': 'https://Stackoverflow.com/users/9640', 'pm_score': 2, 'selected': False, 'text': '<p>There\'s also <a href="http://www.mindscape.co.nz/products/LightSpeed/" rel="nofollow noreferrer">Lightspeed</a> which has a per-organization (not per-developer) license scheme and seems to have a pretty solid documentation library and a free trial version (up to 8 entities).  I\'m checking this out presently.</p>\n'}, {'answer_id': 862564, 'author': 'Ivo Limmen', 'author_id': 57092, 'author_profile': 'https://Stackoverflow.com/users/57092', 'pm_score': 2, 'selected': False, 'text': '<p>After a long search I found <a href="http://code.google.com/p/dblinq2007/" rel="nofollow noreferrer">DbLinq</a> and should do the trick. I am going to try it myself. I came across your question because I was searching for the same solution. Hope it helps.</p>\n'}, {'answer_id': 1141320, 'author': 'Community', 'author_id': -1, 'author_profile': 'https://Stackoverflow.com/users/-1', 'pm_score': 2, 'selected': False, 'text': '<p>Why not try ALinq ？ <a href="http://www.alinq.org" rel="nofollow noreferrer">http://www.alinq.org</a></p>\n'}, {'answer_id': 4563188, 'author': 'Ramesh', 'author_id': 537651, 'author_profile': 'https://Stackoverflow.com/users/537651', 'pm_score': 2, 'selected': False, 'text': '<p>Try Devart <a href="http://www.devart.com/linqconnect" rel="nofollow">LinqConnect</a>. This product allows you to work with Oracle, etc.</p>\n'}, {'answer_id': 6214640, 'author': 'Juan Carlos Velez', 'author_id': 391895, 'author_profile': 'https://Stackoverflow.com/users/391895', 'pm_score': 1, 'selected': False, 'text': '<p>Look in codeplex:\n<a href="http://linqtooracle.codeplex.com/" rel="nofollow">Linq To Oracle project</a></p>\n'}, {'answer_id': 8733688, 'author': 'Brian Deragon', 'author_id': 758118, 'author_profile': 'https://Stackoverflow.com/users/758118', 'pm_score': 0, 'selected': False, 'text': '<p>Another cross-database solution that works fairly well across Oracle, SQLite, MySQL and SQL Server is <a href="http://www.devexpress.com/products/NET/ORM/" rel="nofollow">eXpress Persistent Objects</a></p>\n'}]
['https://Stackoverflow.com/questions/30790', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/2469/']