public IEnumerable<$methodResult> $methodName($arglist)
{
	var sql = @"
$sql
";
	IEnumerable<$methodResult> result = null;
	using(var cmd = new SqlCommand(sql))
	{
#foreach($parm in $parameters)
	#if($parm.Length > 0)
		cmd.Parameters.Add("$parm.Name", SqlDbType.$parm.SqlDbType.ToString(), $parm.Length).Value = $parm.ArgName;
	#else
		cmd.Parameters.Add("$parm.Name", SqlDbType.$parm.SqlDbType.ToString()).Value = $parm.ArgName;
	#end
#end
		result = _helper.ExecuteMultiple<$methodResult>(cmd);
	}
	return result;
}