I have looked at that ayende post before, and didnt quite get it till now. So basically I could define sprocs to get the encrypted entity in a one to one case or I could define a sproc to return a collection of decrypted entities.
Seems to provide the right level of granularity, and no worries about lazy loading. On Nov 12, 9:08 am, Dan Normington <[email protected]> wrote: > Have you considered using stored procedures. I have some columns that are > encrypted as well. I use the <loader query-ref="namedQuery" /> for loading > single aggregates. As far as child lists of aggregates you can use a similar > concept. Take a look at this link. It will provide you with the information > on how to call stored procedures with named queries, loaders, and bags/lists > of aggregates. > > http://ayende.com/Blog/archive/2006/09/18/UsingNHibernateWithStoredPr... > > I would take a look at the named queries and possibly loaders. > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
