public void NonQueryStatementFormatIfParameterCountNotLimitedTo2098WhenConditionIsNotMet() { Assert.DoesNotThrow(() => TSql.NonQueryStatementFormatIf(false, "", ParameterCountLimitedExceeded.Instance.All).ToArray()); }
private static IEnumerable <TestCaseData> NonQueryStatementFormatIfCases() { yield return(new TestCaseData( TSql.NonQueryStatementFormatIf(true, "text"), new[] { new SqlNonQueryCommand("text", new DbParameter[0], CommandType.Text) })); yield return(new TestCaseData( TSql.NonQueryStatementFormatIf(true, "text", parameters: null), new[] { new SqlNonQueryCommand("text", new DbParameter[0], CommandType.Text) })); yield return(new TestCaseData( TSql.NonQueryStatementFormatIf(true, "text", new IDbParameterValue[0]), new[] { new SqlNonQueryCommand("text", new DbParameter[0], CommandType.Text) })); yield return(new TestCaseData( TSql.NonQueryStatementFormatIf(true, "text", new TestDbParameter()), new[] { new SqlNonQueryCommand("text", new[] { new TestDbParameter().ToDbParameter("@P0") }, CommandType.Text) })); yield return(new TestCaseData( TSql.NonQueryStatementFormatIf(true, "text {0}", new TestDbParameter()), new[] { new SqlNonQueryCommand("text @P0", new[] { new TestDbParameter().ToDbParameter("@P0") }, CommandType.Text) })); yield return(new TestCaseData( TSql.NonQueryStatementFormatIf(true, "text", new TestDbParameter(), new TestDbParameter()), new[] { new SqlNonQueryCommand("text", new[] { new TestDbParameter().ToDbParameter("@P0"), new TestDbParameter().ToDbParameter("@P1") }, CommandType.Text) })); yield return(new TestCaseData( TSql.NonQueryStatementFormatIf(true, "text {0} {1}", new TestDbParameter(), new TestDbParameter()), new[] { new SqlNonQueryCommand("text @P0 @P1", new[] { new TestDbParameter().ToDbParameter("@P0"), new TestDbParameter().ToDbParameter("@P1") }, CommandType.Text) })); yield return(new TestCaseData( TSql.NonQueryStatementFormatIf(false, "text"), new SqlNonQueryCommand[0])); yield return(new TestCaseData( TSql.NonQueryStatementFormatIf(false, "text", parameters: null), new SqlNonQueryCommand[0])); yield return(new TestCaseData( TSql.NonQueryStatementFormatIf(false, "text", new IDbParameterValue[0]), new SqlNonQueryCommand[0])); yield return(new TestCaseData( TSql.NonQueryStatementFormatIf(false, "text", new TestDbParameter()), new SqlNonQueryCommand[0])); yield return(new TestCaseData( TSql.NonQueryStatementFormatIf(false, "text {0}", new TestDbParameter()), new SqlNonQueryCommand[0])); yield return(new TestCaseData( TSql.NonQueryStatementFormatIf(false, "text", new TestDbParameter(), new TestDbParameter()), new SqlNonQueryCommand[0])); yield return(new TestCaseData( TSql.NonQueryStatementFormatIf(false, "text {0} {1}", new TestDbParameter(), new TestDbParameter()), new SqlNonQueryCommand[0])); }
public void NonQueryStatementFormatIfParameterCountLimitedTo2098WhenConditionIsMet() { Assert.Throws <ArgumentException>(() => TSql.NonQueryStatementFormatIf(true, "", ParameterCountLimitedExceeded.Instance.All).ToArray()); }