Hi Michael Luna,
We decided to continue the conversation in the support thread mainly because it is private, thus allowing the customer to share more details. If anyone faces the same problem he can easily "revive" this thread and he will most certainly get an answer. Here is the one I provided to JC. I hope you will find it useful.
1. You should try and replace the boolean with bit values in the string where you pass the parameters.
2. You will need to define the type a little bit different. When you want to use an output parameter the "out." prefix is needed. Here is an example:
|var query = scope.GetSqlQuery("Myproc ?,?", null, "decimal unitPrice, out.integer outParam");
In your case you will need to use out.Varchar. When you do this your output parameter will be placed in a dictionary and its name will be used for key. If we would like to retrieve the output parameter from the above stored procedure call we would need code similar to this:
| int myParam = (int)queryResult.OutParameter["outParam"];
3. If your result set contains the items of only one table you can map the result type of the stored procedure to the class that represents this table. This will enable you to interact with the result as a set of class objects. If you however map the return type of a procedure to an object array than the result will be a set of object arrays and each array will be representing a row from your query result.
Multiple results sets returned by a single stored procedure are currently not supported.
4. Unfortunately this is the only way around so far.
the Telerik team