Пример #1
0
        private static IEnumerable <TestCaseData> NonQueryStatementFormatCases()
        {
            yield return(new TestCaseData(
                             TSql.NonQueryStatementFormat("text"),
                             new SqlNonQueryCommand("text", new DbParameter[0], CommandType.Text)));

            yield return(new TestCaseData(
                             TSql.NonQueryStatementFormat("text", parameters: null),
                             new SqlNonQueryCommand("text", new DbParameter[0], CommandType.Text)));

            yield return(new TestCaseData(
                             TSql.NonQueryStatementFormat("text", new IDbParameterValue[0]),
                             new SqlNonQueryCommand("text", new DbParameter[0], CommandType.Text)));

            yield return(new TestCaseData(
                             TSql.NonQueryStatementFormat("text", new TestDbParameter()),
                             new SqlNonQueryCommand("text", new[]
            {
                new TestDbParameter().ToDbParameter("@P0")
            }, CommandType.Text)));

            yield return(new TestCaseData(
                             TSql.NonQueryStatementFormat("text {0}", new TestDbParameter()),
                             new SqlNonQueryCommand("text @P0", new[]
            {
                new TestDbParameter().ToDbParameter("@P0")
            }, CommandType.Text)));

            yield return(new TestCaseData(
                             TSql.NonQueryStatementFormat("text", new TestDbParameter(), new TestDbParameter()),
                             new SqlNonQueryCommand("text", new[]
            {
                new TestDbParameter().ToDbParameter("@P0"),
                new TestDbParameter().ToDbParameter("@P1")
            }, CommandType.Text)));

            yield return(new TestCaseData(
                             TSql.NonQueryStatementFormat("text {0} {1}", new TestDbParameter(), new TestDbParameter()),
                             new SqlNonQueryCommand("text @P0 @P1", new[]
            {
                new TestDbParameter().ToDbParameter("@P0"),
                new TestDbParameter().ToDbParameter("@P1")
            }, CommandType.Text)));
        }
 public void NonQueryStatementFormatParameterCountLimitedTo2098()
 {
     Assert.Throws <ArgumentException>(() => TSql.NonQueryStatementFormat("", ParameterCountLimitedExceeded.Instance.All));
 }