#副標=商務處理與整合 (7)
#大標=BizTalk解決方案的自動測試
#眉標=BizTalk Server 2006
#作者=文／彭靖灝
#引言=



========box 程式1=========

<TestCase testName="SQLAdapterValidTest">
  <TestSetup>
   <TestStep assemblyPath=""
   typeName=
   "Microsoft.Services.BizTalkApplicationFramework.BizUnit.FileDeleteMultipleStep">
     <Directory>..\..\..\Receive\</Directory>
     <SearchPattern>*.xml</SearchPattern>
   </TestStep>
    <TestStep assemblyPath="" typeName=
     "Microsoft.Services.BizTalkApplicationFramework.BizUnit.FileDeleteMultipleStep">
      <Directory>..\..\..\Send\</Directory>
      <SearchPattern>*.xml</SearchPattern>
    </TestStep>    
  <TestStep assemblyPath="" typeName=
   "Microsoft.Services.BizTalkApplicationFramework.BizUnit.DBExecuteNonQueryStep">
    <DelayBeforeExecution>1</DelayBeforeExecution>
     <ConnectionString>server=(local);Trusted_Connection=yes;
　　　database=SQLAdapterUsingDTCOrderDB</ConnectionString>			
      <SQLQuery>
	  <RawSQLQuery>DELETE ORDERS</RawSQLQuery>
	    <SQLQueryParams>
	    </SQLQueryParams>
       </SQLQuery>
	</TestStep>
	<TestStep assemblyPath=""
　　　typeName=
　　　"Microsoft.Services.BizTalkApplicationFramework.BizUnit.DBExecuteNonQueryStep">
  <DelayBeforeExecution>1</DelayBeforeExecution>
   <ConnectionString>server=(local);Trusted_Connection=yes;
　　database=SQLAdapterUsingDTCCustomerDB</ConnectionString>
     <SQLQuery>
	 <RawSQLQuery>DELETE CUSTOMERS</RawSQLQuery>
	 <SQLQueryParams>
	 </SQLQueryParams>
	</SQLQuery>
　　</TestStep>
   </TestSetup>
     …
</TestCase>

===========end==========



=======box 程式2========

<TestExecution>
 <TestStep assemblyPath="" typeName=
 "Microsoft.Services.BizTalkApplicationFramework.BizUnit.FileCreateStep">
　<SourcePath>..\..\..\Test\TestData\OrderValidSample.xml</SourcePath>
　<CreationPath>..\..\..\Receive\OrderValid.xml</CreationPath>			
 </TestStep>
<TestStep assemblyPath="" typeName=
"Microsoft.Services.BizTalkApplicationFramework.BizUnit.FileValidateStep">
　<Timeout>10000</Timeout>
　<Directory>..\..\..\Send\</Directory>
　<SearchPattern>*.xml</SearchPattern>
　<DeleteFile>true</DeleteFile>
　<ValidationStep assemblyPath="" typeName=
　"Microsoft.Services.BizTalkApplicationFramework.BizUnit.XmlValidationStep">
　<XmlSchemaPath>..\..\..\Test\TestData\OrderDetail.xsd</XmlSchemaPath>

<XmlSchemaNameSpace>
http://Microsoft.Samples.BizTalk.Orchestrations.SQLAdapterUsingDTC.BizTalkApp
</XmlSchemaNameSpace>
 </ValidationStep>
</TestStep>
 <TestStep assemblyPath="" typeName=
"Microsoft.Services.BizTalkApplicationFramework.BizUnit.DBQueryStep">
 <DelayBeforeCheck>4</DelayBeforeCheck>
 <ConnectionString>server=(local);Trusted_Connection=yes;database=SQLAdapterUsingDTCCustomerDB</ConnectionString>
 <SQLQuery>
  <RawSQLQuery>select * from Customers where CustomerID = '{0}'</RawSQLQuery>
  <SQLQueryParams>
  <SQLQueryParam>1</SQLQueryParam>
 </SQLQueryParams>
</SQLQuery>
      <Rows>
        <Columns>
          <CustomerID>1</CustomerID>
        </Columns>
      </Rows>
    </TestStep>
 <TestStep assemblyPath="" typeName=
　"Microsoft.Services.BizTalkApplicationFramework.BizUnit.DBQueryStep">
 <DelayBeforeCheck>1</DelayBeforeCheck>
 <ConnectionString>server=(local);
　Trusted_Connection=yes;database=SQLAdapterUsingDTCOrderDB
　</ConnectionString>
 <SQLQuery>
  <RawSQLQuery>select * from Orders where OrderID = '{0}'
</RawSQLQuery>
   <SQLQueryParams>
   <SQLQueryParam>1</SQLQueryParam>
 </SQLQueryParams>
</SQLQuery>
      <Rows>
        <Columns>
          <OrderID>1</OrderID>
        </Columns>
      </Rows>
    </TestStep>
</TestExecution>

============end=============



==========box 程式3============
using System;
using System.Text;
using System.Collections.Generic;
using Microsoft.VisualStudio.TestTools.UnitTesting;
using Microsoft.Services.BizTalkApplicationFramework.BizUnit;

namespace SQLAdapterUsingDTC.Test
{
 [TestClass]
 public class BizTalkAppTest
  {
   /// <summary>
   /// It runs a valid test for the SQLAdapterAtomicTx orchestration.
   /// </summary>  
    [TestMethod]
    public void SqlAdapterValidTest()
  {
   BizUnit bizUnit = new BizUnit
   (@"..\..\..\Test\TestCases\SQLAdapterValidTest.xml");
   bizUnit.RunTest();
   }
   /// <summary>
   /// It runs an invalid test for the SQLAdapterAtomicTx orchestration. 
   /// </summary>  
    [TestMethod]
    [ExpectedException(typeof(System.IndexOutOfRangeException),
     "The service instance must be suspended because the serviced compnent tried
　　　to insert a recored having a duplicate public key")]
      public void SqlAdapterInvalidTest()
      {
      BizUnit bizUnit = new BizUnit
　　　(@"..\..\..\Test\TestCases\SQLAdapterInvalidTest.xml");
      bizUnit.RunTest();
   }
  }
}
============end============