do you recommend Direct=true?

do you recommend Direct=true?

Postby joeu » Tue 04 Jan 2011 13:02

do you recommend Direct connections?
What are the pros?
what are the cons?
Are you answers the same if using the Entity Framework?

Thanks
Joe
joeu
 
Posts: 9
Joined: Wed 18 Aug 2010 17:12

Postby StanislavK » Tue 04 Jan 2011 18:01

The main advantage of using the Direct connection mode is that you don't need the Oracle client software. However, the Direct mode has several limitations concerning using advanced Oracle features. For the detailed information about the Direct mode, please refer to the corresponding topic of our documentation:
http://www.devart.com/dotconnect/oracle/docs/DirectMode.html
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Postby mas » Mon 10 Jan 2011 09:09

If you are using TIMESTAMP WITH TIMEZONE columns, you might experience inconsistent behaviour with respect to the timezone offset, depending on if you use Direct mode or not.

I posted the issue here: http://www.devart.com/forums/viewtopic.php?t=19911

We use Entity Framework, and so far, we have not run into any limitations of Direct mode, it works great besides the said issue.
mas
 
Posts: 25
Joined: Mon 15 Nov 2010 12:09


Return to dotConnect for Oracle