One of the ways I've used is to pass sql queries to my wrapper class. I will have several sql with a variable number of parameters. That way, I can just list all the parameters that I send with the request, and not create an array first.
SQLWrapper.Query(" some sql with parameters", new SqlParameter("@param1", val1), new SqlParameter("@param1", val1), new SqlParameter("@param1", val1));
Much better than an alternative:
SQLWr
apper.Query(" some sql with parameters", new SqlParameter[]{new SqlParameter("@param1", val1), new SqlParameter("@param1", val1), new SqlParameter("@param1", val1)});
It's nice to have when you are faced with a situation where you need a variable number of arguments.
source share