i have this procedure statement
<procedure id="InsertIOs" parameterMap="InsertIOsParams">
SP_InsertIOs
</procedure>
</statements>
<parameterMaps>
<parameterMap id="InsertIOsParams">
<parameter property="iosxml" column="iosxml" dbType="VarChar"/>
</parameterMap>
</parameterMaps>
The name of the stored procedure is SP_InsertIOs which is expecting a string called "iosxml" which is passed in a hashtable(the key name is also iosxml). I use it to insert 10000 entities in the database and it works fine. If i use it to insert 50000 entities i get a timeout SqlException. How can i set a timeout for the procedure? I tried procedure id="InsertIOs" timeout="200" but with no result