BizTalk Server General - SQLAdapter component

Author

SQLAdapter component

Sam

2005-03-01, 5:55 pm

When we develop a custom component to load data to SQL Server , do you need a
BeginTransaction(), a commit and a rollback or is it not required since it is
a com+ component. I am new to biztalk and com+.

public class AICPipeSQL: ServicedComponent, IBTSAppIntegration
{
public AICPipeSQL()
{
}

string IBTSAppIntegration.ProcessMessage(string strDocument)
{
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.LoadXml(strDocument);
SqlDataAdapter oDa = new SqlDataAdapter();
DataSet oDs = new DataSet();
//SQLTransaction ?????????

//Logic to extract data from the XML and load tp database

return strDocument;
}

private DataSet RetrieveStagingData(string groupValue)
{

}
}