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]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
