question

Venkatesh 1 avatar image
Venkatesh 1 asked

ADO.NET EF provider for Oracle from Oracle corporation

Hi,

I have seen many articles on this topic. Today if we have use ADO.NET EF with Oracle we have to purchase the EF drivers from some other third party. That is again extra cost. Can some one tell me if Oracle is ready with a EF provider for ADO.NET EF ? If not what is the progress in this lines ? We see even the competitors like IBM are coming up with this EF provider compatiable with there new DB server.

Thanks and regards Venkatesh. S

oracle
3 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Christian13467 avatar image Christian13467 commented ·
Ask again at http://stackoverflow.com. This more dicussed there than here.
0 Likes 0 ·
KillerDBA avatar image KillerDBA commented ·
ADO.NET I understand but what is "EF?"
0 Likes 0 ·
Kastaka avatar image Kastaka commented ·
'Entity Framework' - see http://msdn.microsoft.com/en-us/library/bb399572.aspx for more details
0 Likes 0 ·

3 Answers

·
user-74 avatar image
user-74 answered

I think this is not entirely correct. There is also a free oracle ado.net ef provider available.

3 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Christian13467 avatar image Christian13467 commented ·
Yes there is, but it's not really active.
0 Likes 0 ·
pratikk avatar image pratikk commented ·
I wouldn't let the data access layer of an enterprise application depend on a 3rd party at codeplex. Just from a risk perspective alone it is a 100% NO.
0 Likes 0 ·
Venkatesh 1 avatar image Venkatesh 1 commented ·
Hi, Thanks for your replies. I would agree few things with Pratikk. The codes in code plex are open source and not thrid party. But if you see the documents it is clearly told that this EF is stable enough to use in production. But I'm surprised wh Oracle is not adopting this technology. EF first release itself is amazingly solid and can cater to enetrprise level. With the release of .Net 4.0 it is moving from strength to strngth.
0 Likes 0 ·
pratikk avatar image
pratikk answered

I think Oracle will never gain mind share in .Net development shops. It is a pity that Oracle has no support for LINQ, a 3 year old technology now. See my comments on this question at stackoverflow.

That being said I'm about to evaluate Devart DotConnect for Oracle. The cost is not that high but the question is how reliable it is. A rock solid, high performance ORM like EF is not trivial to implement and Oracle should be in the best position to support their own Database product.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

JackD avatar image
JackD answered

You can evaluate dotConnect - your limitation is the following - your table quantity should be less than 10. I like this tool because it provides outstanding Model Designer for me - http://www.devart.com/entitydeveloper/.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.