We have been really tired lately dealing with all bugs that comes out of ODP.Net and the lag time to bring out any new product out. I am looking for ado.net provider for oracle and looking for the following:
1. Entity Framework
2. Linq
3. Good support (in case we run into issues)
4. Quick response to open issues
5. Quick updates and new releases
I looked at datadirect and dotConnect by DevArt...But I am not sure if any one is better than other. I would greatly appreciate any suggestions/comments about any of these or other products.
I am not sure if you got the latest ODAC from oracle...We found a lots of bugs with that. I know that Devart does support linq to oracle but I am not sure about other providers.
Also I am not sure about the experiences people have with Devart or Datadirect. So I just wanted to get some recommendations if anyone has used any other provider for oracle.
ngracias
Member
27 Points
22 Posts
ADO.Net/Entity framework provider for oracle
Feb 13, 2011 11:41 AM|LINK
We have been really tired lately dealing with all bugs that comes out of ODP.Net and the lag time to bring out any new product out. I am looking for ado.net provider for oracle and looking for the following:
1. Entity Framework
2. Linq
3. Good support (in case we run into issues)
4. Quick response to open issues
5. Quick updates and new releases
I looked at datadirect and dotConnect by DevArt...But I am not sure if any one is better than other. I would greatly appreciate any suggestions/comments about any of these or other products.
Thanks
</div></div>.
Entity Framework oracle datadirect devart
Lannie
Contributor
3744 Points
731 Posts
ADO.Net/Entity framework provider for oracle
Feb 14, 2011 01:43 AM|LINK
If you figure out how to use LINQ to connect with Oracle let us know,
I read in Visual Studio magazine LINQ is specific to MSSQL,
and Oracle Forums stated Oracle has not yet supported LINQ.
Sorry you have troubles with ODP.NET,
I find it is the fastest and most reliable Oracle driver for me,
and at the same time leveraging some of the SQL advantages of Oracle as well.
ngracias
Member
27 Points
22 Posts
Re: ADO.Net/Entity framework provider for oracle
Feb 14, 2011 03:15 PM|LINK
I am not sure if you got the latest ODAC from oracle...We found a lots of bugs with that. I know that Devart does support linq to oracle but I am not sure about other providers.
Also I am not sure about the experiences people have with Devart or Datadirect. So I just wanted to get some recommendations if anyone has used any other provider for oracle.
Lannie
Contributor
3744 Points
731 Posts
ADO.Net/Entity framework provider for oracle
Feb 14, 2011 06:07 PM|LINK
I think much of the reason you do not find many of these other products is that they inject a great deal of overhead resulting in slow grid load, etc.
It might be useful to forum members if you would list problems you had with ODP.NET,
maybe I am just lucky, but I have had now problems with any version in direct communication by ASP.NET page or Code Behind Page.
I only have had some problems with the GUI tool type interfaces with Visual Studio.
Over time as I became more proficient with Oracle and ODP.NET at programming level (code behind and/or stored procedures),
and learned some of the differences in syntax with ODP.NET, like how each data type is handled,
I did not have a need to use the Visual Studio GUI tools and explorer, etc. or any third-party glunky entity tool any more.
Lannie
Contributor
3744 Points
731 Posts
Re: ADO.Net/Entity framework provider for oracle
Feb 16, 2011 10:48 PM|LINK
Oracle just released an Entity Framework Beta.
http://www.oracle.com/technetwork/topics/dotnet/downloads/oracleefbeta-302521.html?msgid=3-3438343197
modotx
Member
2 Points
3 Posts
Re: ADO.Net/Entity framework provider for oracle
Jul 27, 2011 01:47 PM|LINK
Do you use the Entity Framework?
asava samuel
Member
14 Points
10 Posts
Re: ADO.Net/Entity framework provider for oracle
Feb 22, 2013 05:19 PM|LINK