Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.stanford.edu!sn-xit-02!sn-xit-01!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: DA Morgan Newsgroups: comp.databases.oracle.server Subject: Re: .net and oracle's (10G) object relational features ? Date: Thu, 03 Mar 2005 12:25:53 -0800 Organization: Ye 'Ol Disorganized NNTPCache groupie Message-ID: <1109881364.237944@yasure> User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.2) Gecko/20040804 Netscape/7.2 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 References: <1109874088.634949.25470@g14g2000cwa.googlegroups.com> In-Reply-To: <1109874088.634949.25470@g14g2000cwa.googlegroups.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Cache-Post-Path: yasure!unknown@oracle.advtechserv.com X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/) X-Complaints-To: abuse@supernews.com Lines: 34 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:237389 steph wrote: > Hi, > > We're evaluating pros and cons of using Oracle's object relational > features together with a .Net application. Currently this application > uses pure SQL, i.e. objects are transformed into table records bofore > they are put into/outof the database. I found in Oracle's documentation > something about creating a layer of object-views above the relational > model, thus an object oriented application would communicate with a > database by just transferring objects. > > Has anybody done something like this with .net? Are there any > performance issues? Are Oracle's .Net-interfaces supporting this at > all? > > Thanks for all the input, > Stephan Use relational tables and layer over them object views with instead-of triggers. The relational tables maintain data integrity and the object views deliver the data the way the developers would like to receive it. One caveat ... .NET is dying. Microsoft is likely later this year going to announce its replacement. So this is not necessarily a good time to begin investing in the technology. Take a serious look at PHP5 and other viable alternatives. -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace 'x' with 'u' to respond)