private static IEnumerable <TestCaseData> QueryProcedureFormatCases()
        {
            yield return(new TestCaseData(
                             TSql.QueryProcedureFormat("text"),
                             new SqlQueryCommand("text", new DbParameter[0], CommandType.StoredProcedure)));

            yield return(new TestCaseData(
                             TSql.QueryProcedureFormat("text", parameters: null),
                             new SqlQueryCommand("text", new DbParameter[0], CommandType.StoredProcedure)));

            yield return(new TestCaseData(
                             TSql.QueryProcedureFormat("text", new IDbParameterValue[0]),
                             new SqlQueryCommand("text", new DbParameter[0], CommandType.StoredProcedure)));

            yield return(new TestCaseData(
                             TSql.QueryProcedureFormat("text", new SqlParameterValueStub()),
                             new SqlQueryCommand("text", new[]
            {
                new SqlParameterValueStub().ToDbParameter("@P0")
            }, CommandType.StoredProcedure)));

            yield return(new TestCaseData(
                             TSql.QueryProcedureFormat("text {0}", new SqlParameterValueStub()),
                             new SqlQueryCommand("text @P0", new[]
            {
                new SqlParameterValueStub().ToDbParameter("@P0")
            }, CommandType.StoredProcedure)));

            yield return(new TestCaseData(
                             TSql.QueryProcedureFormat("text", new SqlParameterValueStub(), new SqlParameterValueStub()),
                             new SqlQueryCommand("text", new[]
            {
                new SqlParameterValueStub().ToDbParameter("@P0"),
                new SqlParameterValueStub().ToDbParameter("@P1")
            }, CommandType.StoredProcedure)));

            yield return(new TestCaseData(
                             TSql.QueryProcedureFormat("text {0} {1}", new SqlParameterValueStub(), new SqlParameterValueStub()),
                             new SqlQueryCommand("text @P0 @P1", new[]
            {
                new SqlParameterValueStub().ToDbParameter("@P0"),
                new SqlParameterValueStub().ToDbParameter("@P1")
            }, CommandType.StoredProcedure)));
        }