BizUnit test for multiple rows returned from Database

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › BizUnit test for multiple rows returned from Database

Viewing 0 reply threads
  • Author
    Posts
    • October 18, 2008 at 1:57 AM #21009
      community-content

        Im using bizunit to call a stored porocedure. The result should return 5 rows (records). Testing for 1 record works fine but once i put in multiple <rows> in the configuration file it fails. Below is the sample file (which passes with 1 row element but fails with multiple). So my question is How do you set up the configuration (Rows/Colums) element to test for multiple records returned from the DB  

        <TestCase testName=”BizTalkia.Test“>

        <TestExecution>

                <TestStep assemblyPath=””

                            typeName=”Microsoft.Services.BizTalkApplicationFramework.BizUnit.DBQueryStep“>

                           <DelayBeforeCheck>1</DelayBeforeCheck>

                           <ConnectionString>Persist Security Info=False;Integrated Security=SSPI;

                                                      database=StaffDetailsImport;

                                                       server=HIGH52723;Connect Timeout=30</ConnectionString>

                           

                            <SQLQuery>

                                        <RawSQLQuery>[dbo].[getDuplicateEntries]</RawSQLQuery>

                                        <SQLQueryParams>

                                  <SQLQueryParam  />

                                        </SQLQueryParams>

                            </SQLQuery>

         

                            <Rows>

                                        <Columns>

                                                   <Staff_ID>9999</Staff_ID>

                                                   <first_name>John</first_name>

                                 <last_name>Doe</last_name>

                                        </Columns>

                            </Rows>

                </TestStep>

        </TestExecution>

        </TestCase>

    • Author
      Posts
    Viewing 0 reply threads
    • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.