General

Re: Today's Byte #3: Developing For Oracle Databases

Stephen Ebichondo — Thu, 08 Oct 2009 05:32:55 GMT

Thanks guys this is usually a big challenge when developing a site that may need to support different data stores.

Re: Today's Byte #3: Developing For Oracle Databases

gutsboy — Wed, 07 Oct 2009 10:26:02 GMT

Thanks for pointing out that Stephen, I had overlooked it on that perspective and always compared LINQ to other ORM frameworks which always seem to have a common defacto - support for multiple db platforms. I guess IBATIS in combi with Abator.NET would achieve the cross-db-platform ability.

Re: Today's Byte #3: Developing For Oracle Databases

Rad — Wed, 07 Oct 2009 06:39:52 GMT

Since Oracle are deafeningly silent on the matter, currently the best way is to use a third party provider. I keep hearing good things about Devart dotConnect. You could also check out the open source dbLinq or LinqToOracle

Re: Today's Byte #3: Developing For Oracle Databases

Stephen Ebichondo — Wed, 07 Oct 2009 05:20:01 GMT

Hey Rad, how would i use LINQ when developing against an Oracle database???

Today's Byte #3: Developing For Oracle Databases

Rad — Tue, 06 Oct 2009 14:40:24 GMT

If you're doing development against an Oracle database, you can use the built in Oracle client, System.Data.OracleClient. However this is a bad idea for a two reasons:

It will be deprecated in .NET 4.0
Oracle's provider, ODP.NET is better in several ways:
- Faster
- Supports more Oracle features: Associative arrays, server side cursors, etc
- Better support for large character/binary types (LOB)
- Supports caching
- Is updated on Oracle's technology cycle, rather than the .NET framework cycle