public void FormatString_EscapesApostrophe()
{
const string expected = "'This isn''t a test.'";
var dialect = new SqlDialect();
var actual = dialect.FormatString("This isn't a test.");
Assert.Equal(expected, actual);
}
public void FormatParameterName_ReturnsFormattedParameterName()
{
const string expected = "@Parameter";
var dialect = new SqlDialect();
var actual = dialect.FormatParameterName("Parameter");
Assert.Equal(expected, actual);
}
public void FormatIdentifier_ReturnsFormattedTableName()
{
const string expected = "[Users]";
var dialect = new SqlDialect();
var actual = dialect.FormatIdentifier("Users");
Assert.Equal(expected, actual);
}
public void WriteLimit_WithNullOffset_WritesNoOffset()
{
var expected = "FETCH FIRST 10 ROWS ONLY";
var dialect = new SqlDialect();
var builder = new StringBuilder();
using (TestSqlWriter writer = new TestSqlWriter(builder, dialect))
{
dialect.WriteLimit(writer, null, 10);
}
var actual = builder.ToString();
Assert.Equal(expected, actual);
}
static SqlDialect()
{
Default = new SqlDialect();
Current = Default;
}
public TestSqlWriter(StringBuilder builder, SqlDialect dialect)
: base(builder, dialect)
{
}
static SqlDialect()
{
Default = new SqlDialect();
Current = Default;
}
