Ha - what a coincidence :) I've been working on this very thing for a few days. I'm starting with Scott Ambler's [1] very helpful whitepapers on Object - Relational mapping and mixing in dated but effective techniques from other techniques I've seen:
My design goals are something like this: 1. Automated persistence mechanism for .NET objects and relationships. 2. Non-invasive to client classes. You don't have to derive from some PersistentObject or implement special interfaces. Basically a reflection approach with help from custom attributes. 3. Fast and scalable 4. Database neutral implementation 5. Automated schema generation based on object model. The implementation is going really smoothly so far due to the CLR's metadata facilities. I have gotten to the point when objects save and retrieve themselves. Still plenty to go but perhaps opening this up to the community would be a good idea? Jim [1] - http://www.ambysoft.com > -----Original Message----- > From: Peter Foreman [mailto:[EMAIL PROTECTED]] > Sent: Friday, May 10, 2002 4:56 AM > To: [EMAIL PROTECTED] > Subject: Re: [DOTNET] OT: Relational to Object mapping. > > > It's definitely worth looking hard into this before doing it > IMO. Depending on the nature of your > application there are performance implications in going down > an OR route. > > Scott Ambler's papers are a good starting read. But it's > worth having at least a cursory glance > at CORBA persistence, 'entity' java beans, JDO, and > ObjectSpaces. It's also worth looking at the > commercial products that do this successfully at the moment > in a real world high performance > system. (Or lack thereof). > > Peter > > --- "Rolls, Robert" <[EMAIL PROTECTED]> wrote: > > I'd definatley like to hear more at present we're looking > at everything. > > > > -----Original Message----- > > From: Shawn Wildermuth [mailto:[EMAIL PROTECTED]] > > Sent: Friday, 10 May 2002 12:33 > > To: [EMAIL PROTECTED] > > Subject: Re: [DOTNET] OT: Relational to Object mapping. > > > > > > I like using the object-like view of data you get from > using DataSet and > > navigating between tables through relationships. If this > is confusing, > > I'll write about it more in-depth reply. > > > > Thanks, > > > > Shawn Wildermuth > > [EMAIL PROTECTED] > > > > > -----Original Message----- > > > From: dotnet discussion [mailto:[EMAIL PROTECTED]] > > > On Behalf Of Rolls, Robert > > > Sent: Thursday, May 09, 2002 9:45 PM > > > To: [EMAIL PROTECTED] > > > Subject: [DOTNET] OT: Relational to Object mapping. > > > > > > > > > Does anybody have a good web site link that gives a good > > > overview of relational to object mapping? > > > > > > Regards, > > > Robert Rolls > > > > > > > > > > > > > > > ************************************************************** > > > ********" > > > This correspondence is for the named person's use only. It > > > may contain confidential or legally privileged information or > > > both. " No confidentiality or privilege is waived or lost by > > > any " mistransmission. If you receive this correspondence in > > > error, please immediately delete it from your system and > > > notify the sender. You must not disclose, copy or rely on > > > any part of this correspondence if you are not the > intended recipient. > > > > > > Any views expressed in this message are those of the > > > individual sender, except where the sender expressly, and > > > with authority, states them to be the views of Vodafone. > > > > > > This email has been checked for viruses. > > > ************************************************************** > > > ******************************** > > > > > > You can read messages from the DOTNET archive, unsubscribe > > > from DOTNET, or subscribe to other DevelopMentor lists at > > > http://discuss.develop.com. > > > > > > > You can read messages from the DOTNET archive, unsubscribe > from DOTNET, or > > subscribe to other DevelopMentor lists at > http://discuss.develop.com. > > > > > > > ************************************************************** > ********" > > This correspondence is for the named person's use only. It may > > contain confidential or legally privileged information or both. " > > No confidentiality or privilege is waived or lost by any " > > mistransmission. If you receive this correspondence in > error, please > > immediately delete it from your system and notify the sender. You > > must not disclose, copy or rely on any part of this correspondence > > if you are not the intended recipient. > > > > Any views expressed in this message are those of the > individual sender, > > except where the sender expressly, and with authority, > states them to > > be the views of Vodafone. > > > > This email has been checked for viruses. > > > ************************************************************** > ******************************** > > > > You can read messages from the DOTNET archive, unsubscribe > from DOTNET, or > > subscribe to other DevelopMentor lists at > http://discuss.develop.com. > > > __________________________________________________ > Do You Yahoo!? > Yahoo! Shopping - Mother's Day is May 12th! > http://shopping.yahoo.com > > You can read messages from the DOTNET archive, unsubscribe > from DOTNET, or > subscribe to other DevelopMentor lists at http://discuss.develop.com. > You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.
