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);
}
