BizRule DB Connection Optimization

Sep 20, 2010 at 8:05 PM

Hi Andrea,

We're creating some custom tables to satisfy our security needs and I'd like to query the tables from BizRules. Is there a way to create a DB Connection outside of the BizRule such that it can be (re)used by all BizRules, such that every rule execution doesn't have to open and close a costly DB connection?

TIA, Steve

Sep 20, 2010 at 9:55 PM

Andrea here are the specs:

  • NetSqlAzMan version
  • Management Console
  • XP Pro SP3 with C#
  • Platform (x86, 32 bit)
  • SQL Server version (2005)
Sep 20, 2010 at 10:56 PM

Why not passing all you need (a dataset ? or an open SqlConnection ?) as a context parameter ?



Andrea Ferendeles
NetSqlAzMan Project Coordinator
E-mail Web