I saw in another thread that you can execute a stored procedure before each batch query using the IBatcher interface. Instead of using a batch I have a situation where I need to pass a single paramenter to a stored procedure that I need to have executed before each query. Is there an interceptor, event or interface that I can leverage to do this? Does anyone know how this would be affected by using Linq for my queries?
Additional info: This is for a system that uses the MS SQL Server variable CONTEXT_INFO to store the id of a given users company and then that value is used to filter a set of views which I am planning to map in nHibernate. The Stored Procedure would be setting the value of the CONTEXT_INFO so that the views are then properly filtered for the queries. -- 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.
