Append() public method

Appends the specified predicate (the WHERE keyword will be set when calling ApplyTo so it doesn't need specifying in the predicate).
public Append ( string predicate ) : RawWhereBuilder
predicate string The predicate to be appended.
return RawWhereBuilder
RawWhereBuilder Class Documentation
示例#1
0
        public void ToStringReturnsInnerSql()
        {
            var rawWhereBuilder = new RawWhereBuilder();
            rawWhereBuilder.Append("Forename = @p0", "Fred");

            Assert.Equal("Forename = @p0", rawWhereBuilder.ToString());
        }
示例#2
0
        public void ApplyToEnsuresParametersAreRenumberedAndAllArgumentsAreAppended()
        {
            var rawWhereBuilder = new RawWhereBuilder();
            rawWhereBuilder.Append("ForeName = @p0 AND Surname = @p1", "Fred", "Flintstone")
                .Append(" AND Created > @p0", DateTime.Today)
                .Append(" AND LastLogin IS NOT NULL");

            var mockSqlBuilder = new Mock<IWhereOrOrderBy>();

            rawWhereBuilder.ApplyTo(mockSqlBuilder.Object);

            mockSqlBuilder.Verify(
                x => x.Where("ForeName = @p0 AND Surname = @p1 AND Created > @p2 AND LastLogin IS NOT NULL", "Fred", "Flintstone", DateTime.Today),
                Times.Once());
        }