I have wrote this post to tell you how to retrieve all BizTalk 2009 Applications with some important information. I am using BizTalk ExplorerOM assembly it is allow me to access BizTalk Application objects, so I have created simple windows application that show all BizTalk application with status in DataGridView.
Let us see main code used to retrieve BizTalk application and it is status in the below code:
1: BtsCatalogExplorer catalog = new BtsCatalogExplorer();
2: DataTable apptbl = CreateAppTBL();
3: 4: catalog.ConnectionString = "SERVER=.;DATABASE=BizTalkMgmtDb;Integrated Security=SSPI";
5: DataRow dr;
6: foreach (Microsoft.BizTalk.ExplorerOM.Application app in catalog.Applications)
8: dr = apptbl.NewRow();
9: dr["AppName"] = app.Name;
10: dr["AppDesc"] = app.Description;
11: dr["AppStatus"] = app.Status;
14: return apptbl;
As shown above I am going to retrieve all applications throw BtsCatalogExplorer then use Foreach loop to fetch each application individual and finally fill DataTable with information needed.
Now I am going to give you simple description about
ConnectionString property found at
ConnectionString : is used for gets or sets the string used to open BizTalk Management database as shown above i have installed BizTalk at local server so i have wrote server=. to point to local server database and BizTalk Database is BizTalkMgmtDbso i have set DataBase with BizTalkMgmtDb value.
Point of Interest
I think we have learned about ExplorerOM assembly and how it being used. You can download source code from http://www.box.net/shared/3lsvtpnraf