Thanks to add your reflexion to the FAQ ;) LOL!! On Fri, Jun 25, 2010 at 3:24 PM, John Davidson <[email protected]> wrote:
> I have estimated that each composite key in an ASP.Net application when > using NHibernate is about $5000 (local money). When not using NHibernate is > probably about $7500. This is over the lifecycle of the application, but > with significant front-end costs. > > I have a system that uses around 60 composite keys, very expensive! > > John Davidson > > On Fri, Jun 25, 2010 at 2:19 PM, Fabio Maulo <[email protected]> wrote: > >> with this WARNING: >> *Keys With Business Meaning Are a Bad Idea and So Are Composite Keys* >> >> *"A very critical issue that needs to be pointed out is that OIDs should >> have absolutely no business meaning* >> *whatsoever. Nada. Zip. Zilch. Zero. Any column with a business meaning >> can potentially change, and if* >> *there’s one thing that we learned over the years in the relational world >> it’s that it’s a fatal mistake to give* >> *your keys meaning."* >> * >> * >> *"Composite keys increase the overhead in your database as foreign >> keys, increase the complexity of your database design, and often incur >> additional processing requirements when* >> *many fields are involved."* >> * >> * >> *by Scott W. Ambler* >> >> On Fri, Jun 25, 2010 at 3:01 PM, John Davidson <[email protected]>wrote: >> >>> See >>> >>> http://devlicio.us/blogs/anne_epstein/archive/2009/11/20/nhibernate-and- >>> composite-keys.aspx >>> >>> >>> <http://devlicio.us/blogs/anne_epstein/archive/2009/11/20/nhibernate-and-composite-keys.aspx>which >>> should provide guidance on what is required. (I really need to add this to a >>> FAQ - thanks anne) >>> >>> John Davidson >>> >>> On Fri, Jun 25, 2010 at 1:44 PM, Walter Johnson <[email protected]>wrote: >>> >>>> How can I create an ID in a mapping file with a composite primary key? >>>> >>>> -- >>>> You received this message because you are subscribed to the Google >>>> Groups "nhusers" group. >>>> To post to this group, send email to [email protected]. >>>> To unsubscribe from this group, send email to >>>> [email protected]<nhusers%[email protected]> >>>> . >>>> For more options, visit this group at >>>> http://groups.google.com/group/nhusers?hl=en. >>>> >>>> >>> -- >>> You received this message because you are subscribed to the Google Groups >>> "nhusers" group. >>> To post to this group, send email to [email protected]. >>> To unsubscribe from this group, send email to >>> [email protected]<nhusers%[email protected]> >>> . >>> For more options, visit this group at >>> http://groups.google.com/group/nhusers?hl=en. >>> >> >> >> >> -- >> Fabio Maulo >> >> -- >> You received this message because you are subscribed to the Google Groups >> "nhusers" group. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]<nhusers%[email protected]> >> . >> For more options, visit this group at >> http://groups.google.com/group/nhusers?hl=en. >> > > -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<nhusers%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > -- Fabio Maulo -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
