BizRule DB Connection Optimization

Sep 20, 2010 at 7: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 8:55 PM

Andrea here are the specs:

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

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

Regards,

Andrea.

__________________________________
Andrea Ferendeles
NetSqlAzMan Project Coordinator
E-mail aferende@hotmail.com Web http://netsqlazman.codeplex.com