Saturday, October 17, 2009

As usual...

... some news.

At my work, nothing special. I was working on correcting bugs in our applications And it is not very interesting. There was one thing that I was happy to work on.
In one of our application, we added the possibility to pass dynamic arguments to stored procedures that are executed. In fact, the user sets a list of stored procedures in one column, separated by semi-column, and in the second, the list of arguments (name-value) for all stored procedures (we use two separators, one for procedures, second for arguments, ex: @Proc1Arg1Name = Proc1Arg1Value; @Proc1Arg2Name = Proc1Arg2Value|@Proc2Arg1Name = Proc2Arg1Value; @Proc2Arg2Name = Proc2Arg2Value). This is made by a specific user's stored procedure.
Then, we use SMO to find type of arguments that are passed to stored procedures. But there is one small problem. There is no method in .Net Framework that makes matching between SMO SqlDataTye et standard SqlDbType used by SqlCommand. We had to write one to do that.

And that's all for now.

No comments: