Re: Multiple result sets and XML parameters for stored procedures

[Gilles Bayon]

Question a)
 IList list = sqlMap.QueryForList("GetMultipleResultClass", null); from Unit
tests

    <select id="GetMultipleResultMap"
      resultMap="account-result, Category-result">
      select
      Account_ID,
      Account_FirstName,
      Account_LastName,
      Account_Email,
      Account_Banner_Option,
      Account_Cart_Option
      from Accounts
      where Account_ID = 1;

      select
      Category_ID,
      Category_Name,
      Category_Guid
      from Categories
      where Category_ID = 1
    </select>


Question b)
Try to specify the dbType="NText" in (SqlDbType.NText)


-- 
Cheers,
Gilles

<a href="http://www.amazon.com/gp/registry/6JCP7AORB0LE";>Wish List</a>