public void IndexValuesTest() { TableHint target = new TableHint(); // TODO: Initialize to an appropriate value List<string> actual; actual = target.IndexValues; Assert.Inconclusive("Verify the correctness of this test method."); }
public void TestExample1() { var nolock = new TableHint(TableHints.NoLock); var s = new Schema("s"); }
private void AssertExpression(TableHint hint, string expectedOutput) { using (var writer = new IndentedTextWriter(new StringWriter(), " ")) { using (var tsql = new TSqlCodeProvider()) { tsql.GenerateCodeFromCodeObject(hint, writer, new CodeGeneratorOptions()); var output = writer.InnerWriter.ToString(); Assert.IsTrue(output == expectedOutput); } } }
public void TestSqlTableHint() { var hint = new TableHint(TableHints.Index | TableHints.NoLock); hint.IndexValues.Add("t1"); hint.IndexValues.Add("t2"); AssertExpression(hint, "INDEX (t1, t2), NOLOCK"); }
public void TestOrderBy() { TableHint nolock = new TableHint(TableHints.NoLock); var man_batch = new Table("mb", "mb", null, nolock); var table = new OrderBy.OrderBy(man_batch["foo"].Asc()); AssertClause(table, "ORDER BY mb.foo"); }
public void TestNestedScalarSelect() { TableHint nolock = new TableHint(TableHints.NoLock); var schema = new Schema("s"); var t0 = new Table("b", "b", null, nolock); var t1 = new Table("mb", "mb", null, nolock); var t2 = new Table(schema, "s", "s0", null, nolock); var t3 = new Table(schema, "s", "s1", null, nolock); var t4 = new Table(schema, "p", "p", null, nolock); var table = Sql.From( t0 .Join.Inner(t1, t0["mb_id"].Equal(t1["id"])) .Join.Left(t2, t0["sid"].Equal(t2["sid"]) .And(t2["f0"].Equal("Y")) .And(t2["f1"].Equal("N")) .And(t2["dtm"].Equal( Sql.From( t3 .Join.Inner(t4, t4["gid"].Equal(t3["gid"]) .And(t4["n0"].In("YYZ", "ABC") .And(t4["n1"].Equal("XYZ"))))) .Where( t3["sid"].Equal(t2["sid"]) .And(t3["f0"].Equal("Y") .And(t3["f1"].Equal("N")))) .ScalarSelect( new Max(t3["dtm"]) ) ) ) ) ) .Where( t0["mb_id"].Equal("id") .And(t0["seq"].GreaterThanOrEqual(1)) .And(t0["seq"].LessThanOrEqual(5)) ) .Select( t0["sid"], t0["gid"], t1["eval_usr_nm"], t2["gid"] ); AssertClause(table, @"SELECT b.sid, b.gid, mb.eval_usr_nm, s0.gid FROM [b] AS [b] WITH (NOLOCK) INNER JOIN [mb] AS [mb] WITH (NOLOCK) ON b.mb_id = mb.id LEFT OUTER JOIN [s].[s] AS [s0] WITH (NOLOCK) ON b.sid = s0.sid AND s0.f0 = 'Y' AND s0.f1 = 'N' AND s0.dtm = (SELECT MAX(s1.dtm) FROM [s].[s] AS [s1] WITH (NOLOCK) INNER JOIN [s].[p] AS [p] WITH (NOLOCK) ON p.gid = s1.gid AND p.n0 IN ('YYZ', 'ABC') AND p.n1 = 'XYZ' WHERE s1.sid = s0.sid AND s1.f0 = 'Y' AND s1.f1 = 'N') WHERE b.mb_id = 'id' AND b.seq >= 1 AND b.seq <= 5;"); }
public Table(Schema schema, string name, string alias, ClauseTableSample tableSampleClause, TableHint tableHints) : this(schema, name, alias, tableSampleClause) { TableHints = tableHints; }
public Table(string name, string alias, TableHint tableHints) : this(name, alias) { TableHints = tableHints; }
public Table(string name, string alias, ClauseTableSample tableSampleClause, TableHint tableHints) : this(Schema.Dbo, name, alias, tableSampleClause, tableHints) { // }
public static Table Default(string name, string alias, ClauseTableSample tableSampleClause, TableHint tableHints) { return new Table(name, alias, tableSampleClause, tableHints); }
public Table(Schema schema, string name, string alias, TableHint tableHints) : this(schema, name, alias, null, tableHints) { // }
public void TableHintConstructorTest1() { TableHints hints = new TableHints(); // TODO: Initialize to an appropriate value TableHint target = new TableHint(hints); Assert.Inconclusive("TODO: Implement code to verify target"); }
public void TableHintConstructorTest() { TableHint target = new TableHint(); Assert.Inconclusive("TODO: Implement code to verify target"); }