|
Home > Archive > BizTalk Server General > May 2005 > BizTalk 2004 :: Business Rules Engine :: database connections
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
BizTalk 2004 :: Business Rules Engine :: database connections
|
|
|
|
Hello everyone,
I'm confused about something:
In the SDK, the "Loans processing using business rules" sample has a ruleset
that uses the "Northwind" database, but no database connection is passed in
and no vocabulary supports the sample.
In my orchestration, I must pass in a dataset. Why?
I suspect it is because I am using the database in the "Then" actions,
because I dont really see any other differences.
Can anyone confirm why I must pass in datasets?
As a followup: does anyone have any advice on how best to use databases when
calling the rules engine? (keeping in mind the need test, accept,
production datasources)
Thanks,
BA
| |
|
|
"BA" <biztalk.architect@gmail.com> wrote in message
news:428840e3$0$1378$5fc3050@dreader2.news.tiscali.nl...
>
> Hello everyone,
>
> I'm confused about something:
>
> In the SDK, the "Loans processing using business rules" sample has a
> ruleset that uses the "Northwind" database, but no database connection is
> passed in and no vocabulary supports the sample.
>
> In my orchestration, I must pass in a dataset. Why?
>
> I suspect it is because I am using the database in the "Then" actions,
> because I dont really see any other differences.
>
> Can anyone confirm why I must pass in datasets?
>
>
> As a followup: does anyone have any advice on how best to use databases
> when calling the rules engine? (keeping in mind the need test, accept,
> production datasources)
>
> Thanks,
>
> BA
>
I've chosen to use "Microsoft.RuleEngine.DataConnection", which is the best
way to go under certain conditions.... BUT:
http://msdn.microsoft.com/library/d..._rules_noct.asp
In essence (bare bones, the article has many qualifications on these points,
so read it if you have doubts):
When you have large numbers of rows and small selectivity, use
*DataConnection*
When you, in general, have high selectivity (many rows satisfy query)
the *DataTable* is usually the better option
|
|
|
|
|