public override void SetUp() { // Generic Dialect inherits all of the Quoting functions from // Dialect (which is abstract) d = new MsSql2000Dialect(); tableWithNothingToBeQuoted = new string[] { "plainname", "[plainname]" }; tableAlreadyQuoted = new string[] { "[Quote[d[Na]]$`]", "[Quote[d[Na]]$`]", "Quote[d[Na]$`" }; tableThatNeedsToBeQuoted = new string[] { "Quote[d[Na]$`", "[Quote[d[Na]]$`]", "Quote[d[Na]$`" }; }
public void OrderByMultiColumn() { Dialect.Dialect dialect = new MsSql2000Dialect(); string orderBy = "col1 asc, col2 desc, col3"; string expectedOrderBy = "$PlaceHolder$.col1 asc, $PlaceHolder$.col2 desc, $PlaceHolder$.col3"; Assert.AreEqual(expectedOrderBy, Template.RenderOrderByStringTemplate(orderBy, dialect, functionRegistry)); }
public void NoLeadingUnderscores() { var alias = new Alias("suffix"); Dialect.Dialect dialect = new MsSql2000Dialect(); Assert.That(alias.ToAliasString("__someIdentifier", dialect), Does.Not.StartWith("_")); Assert.That(alias.ToUnquotedAliasString("__someIdentifier", dialect), Does.Not.StartsWith("_")); }
public void SchemaNameQuoted() { Table tbl = new Table(); tbl.Schema = "`schema`"; tbl.Name = "name"; Dialect.Dialect dialect = new MsSql2000Dialect(); Assert.AreEqual("[schema].name", tbl.GetQualifiedName(dialect)); }
public void NoLeadingUnderscores() { Alias alias = new Alias("suffix"); Dialect.Dialect dialect = new MsSql2000Dialect(); Assert.IsFalse( alias.ToAliasString("__someIdentifier", dialect) .StartsWith("_")); Assert.IsFalse( alias.ToUnquotedAliasString("__someIdentifier", dialect) .StartsWith("_")); }
public void TableNameNotQuoted() { Table tbl = new Table(); tbl.Name = "notkeyword"; Dialect.Dialect dialect = new MsSql2000Dialect(); Assert.AreEqual("notkeyword", tbl.GetQuotedName(dialect)); Assert.AreEqual("dbo.notkeyword", tbl.GetQualifiedName(dialect, null, "dbo")); Assert.AreEqual("notkeyword", tbl.GetQualifiedName(dialect, null, null)); tbl.Schema = "sch"; Assert.AreEqual("sch.notkeyword", tbl.GetQualifiedName(dialect)); }