public void WriteLimit_WithNullCount_WritesOffsetOnly() { var expected = "OFFSET 42 ROWS"; var dialect = new SqlServerDialect(); var builder = new StringBuilder(); using (TestSqlWriter writer = new TestSqlWriter(builder, dialect)) { dialect.WriteLimit(writer, 42, null); } var actual = builder.ToString(); Assert.Equal(expected, actual); }
public void WriteLimit_WithNullOffset_WritesZeroOffset() { var expected = "OFFSET 0 ROWS FETCH FIRST 10 ROWS ONLY"; var dialect = new SqlServerDialect(); var builder = new StringBuilder(); using (TestSqlWriter writer = new TestSqlWriter(builder, dialect)) { dialect.WriteLimit(writer, null, 10); } var actual = builder.ToString(); Assert.Equal(expected, actual); }
public void WriteLimit_WithNullCount_WritesOffsetOnly() { var expected = "OFFSET 42 ROWS"; var dialect = new SqlServerDialect(); var builder = new StringBuilder(); using (TestSqlWriter writer = new TestSqlWriter(builder, dialect)) { dialect.WriteLimit(writer, 42, null); } var actual = builder.ToString(); Assert.Equal(expected, actual); }
public void WriteLimit_WritesOffsetFetch() { var expected = "OFFSET 42 ROWS FETCH FIRST 10 ROWS ONLY"; var dialect = new SqlServerDialect(); var builder = new StringBuilder(); using (TestSqlWriter writer = new TestSqlWriter(builder, dialect)) { dialect.WriteLimit(writer, 42, 10); } var actual = builder.ToString(); Assert.Equal(expected, actual); }