Thank you both for your super fast replys as usual. I will go down the DB view with value-object path. p.s Fabio do you ever sleep no matter what time I post you reply with in minutes?
On Jun 17, 8:46 am, Fabio Maulo <[email protected]> wrote: > +1 but without map it (value-object in this case) > > 2009/6/16 James Gregory <[email protected]> > > > > > Personally, as it's read only, I'd go with creating a view and mapping an > > entity to it. It depends what the system is as to how good an idea it is. > > > On Tue, Jun 16, 2009 at 11:41 PM, Dave <[email protected]> wrote: > > >> Hi, > > >> I have a generic pivot table that is used to store additional > >> attributes for a entity > > >> For example > > >> ADDITIONAL ATTRIBUTES TABLE > >> Typefk | EntityFk | Value > >> ----------------------------------------------- > >> 1 1 Foo > >> 2 1 Bar > >> 1 2 Baz > >> 2 2 Qux > > >> TYPE TABLE > >> PK | Name > >> -------------------- > >> 1 company_name > >> 2 account_number > > >> I want to select an Enity with these addtional attrubutes showing as > >> columns in a single row instead of multiple rows (a piviot). > > >> For Example get all info from Entity1 would return > > >> pk | company_name | account_number > >> 1 Foo Bar > > >> This is a READ ONLY system. What the Best approach to do this? > > >> 1) Perform a piviot in the DB (stored proc or view) and use NHibernate > >> to map to it? > >> 2) Leave the DB and mappings as is but do the transformation in code > >> using the getters? > >> 3) Tell the DBA their design stinks and redesign the DB (not really an > >> option) > >> 4) Something else? > > >> Cheers > >> Dave > > -- > 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 -~----------~----~----~----~------~----~------~--~---
