Re: Biztalk 2004: How to pass database facts from C# code?

Thanks for the response Matt. Do you have any code sample links for doing
this? That would really help me.

"Matt Milner" wrote:

You can fill up a datatable and then wrap that in a TypedDataTable and pass
it as a fact. Or, you can create a SQL connection and wrap it in the
DataConnection class. The one you choose will depend on how your rule
properties are configured. By default, they will expect the connection.
Highlight the database fact in the business rule editor and check the
properties to be sure. Be sure the string parameters you use to create the
typeddatatable or the dataconnection match those in your rules.

Matt


"Pankaj" <Pankaj@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FC4CDFAE-7A86-41F5-A155-167FDC818C02@xxxxxxxxxxxxxxxx
Hi

Tools: C#, .NET 1.1 and Biztalk 2004

I want to execute a policy rule which gets fired based on some input xml
and
database facts. I am able to pass the input xml facts but how to I pass
the
database facts information before executing policy. Basically, by passing
"Role" information, I want to get "Salary" values which are stored in a
database table.

Following is the code snippet:


--------------------------------------------------------------
Input XML:

<ns0:EmpInfo xmlns:ns0="http://EmployeeInfo.EmpInfo";>
<Emp>
<Salary></Salary>
<Role>Manager</Role>
</Emp>
<Emp>
<Salary></Salary>
<Role>CIO</Role>
</Emp>
</ns0:EmpInfo>

--------------------------------------------------------------

----------------------------
public string Execute(string sRequestXML, out string sResponseXML, out
string sErrorMsg)
{
sResponseXML = string.Empty;
sErrorMsg = string.Empty;
DebugTrackingInterceptor dti = new
DebugTrackingInterceptor(@"C:\Biztalk\projects\EmployeeInfo\XSDs\jit.txt");

//create an instance of the XML object
XmlDocument xd1 = new XmlDocument();
xd1.Load(@"C:\Biztalk\projects\EmployeeInfo\XSDs\Copy of
EmpInfo_output.xml");

TypedXmlDocument doc1 = new TypedXmlDocument("EmpInfo",xd1);
// create the array of short-term facts
object[] shortTermFacts = new object[1];
shortTermFacts[0] = doc1;

Policy policy = null;
// now execute to see what happens
try
{

//Console.WriteLine("Grabbing the policy ...");
policy = new Policy("EmpInfo");
policy.Execute(shortTermFacts, dti);

FileInfo finfo = new
FileInfo(@"C:\Biztalk\projects\EmployeeInfo\XSDs\ProcessedRFP.xml");
StreamWriter writer = finfo.CreateText();
writer.Write(doc1.Document.OuterXml);
writer.Close();

}
catch (Exception ex)
{
FileInfo finfoError = new
FileInfo(@"C:\Biztalk\projects\EmployeeInfo\XSDs\Error.xml");
StreamWriter writerError = finfoError.CreateText();
writerError.Write(ex.Message);
writerError.Close();
}

dti.CloseTraceFile ();

policy = null;
return "PASS";

}





.

Relevant Pages

  • Re: I just dont understand why...
    ... get your facts straight - There is only one dead person! ... You are willing to make all sorts of wild speculations about these two dead ... yeah I think it is a terrible policy to guide people on the ... >> cannot go paddling together. ...
    (rec.boats.paddle)
  • Rule activity
    ... The facts are published and the policy deployed. ... I look at the ENGINE RULE TRACE and get matches for each rule in my rule ... What must I do to get it to do something usefull like update the input xml ...
    (microsoft.public.biztalk.general)
  • Re: Biztalk 2004: How to pass database facts from C# code?
    ... this line right after you add your typed xml document. ... Be sure the string parameters you use to create ... I want to execute a policy rule which gets fired based on some input ... database facts. ...
    (microsoft.public.biztalk.general)
  • Re: I just dont understand why...
    ... get your facts straight - There is only one dead person! ... yeah I think it is a terrible policy to guide people on the ... >>> The military is typically more concerned with the appearance of things ...
    (rec.boats.paddle)
  • Re: Biztalk 2004: How to pass database facts from C# code?
    ... this line right after you add your typed xml document. ... Be sure the string parameters you use to create ... I want to execute a policy rule which gets fired based on some input ... database facts. ...
    (microsoft.public.biztalk.general)