querybuilder icon indicating copy to clipboard operation
querybuilder copied to clipboard

CommandType

Open mattewre opened this issue 3 years ago • 0 comments

QueryFactory Select and Statement accept optional "commandType" supported by Dapper. Useful for Stored Procedure.

Example

var parameters = new DynamicParameters();
parameters.Add("@param1", 2);
parameters.Add("@param1out", dbType: DbType.Int32, direction: ParameterDirection.Output);

var result = db.Select("SP_TEST", parameters, commandType: CommandType.StoredProcedure);
var param1out = parameters.Get<int>("@param1out");

mattewre avatar Sep 08 '22 14:09 mattewre