public void Create_Query_With_One_Table() { // Setup var dataQuery = CreateSelectQuery(); var table = new QueryTable("table"); dataQuery.AddTable(table); // Execute Execute(dataQuery); // Validate Assert.AreEqual("select * from [table] t1", ExecutedSql); }
public void Create_Query_With_One_Table_And_Int_Parameter() { // Setup var dataQuery = CreateSelectQuery(); var table = new QueryTable("table"); var clause = new EqualsClause(new FieldReference(table, "field"), new IntConstant(5)); dataQuery.AddWhere(clause); dataQuery.AddTable(table); // Execute Execute(dataQuery); // Validate Assert.AreEqual("select * from [table] t1 where t1.[field]=@p1", ExecutedSql); Assert.AreEqual(1, ExecutedParameters.Length); Assert.AreEqual("p1", ExecutedParameters[0].ParameterName); }
public void Create_FullText_Query() { // Setup var dataQuery = CreateSelectQuery(); var t1 = new QueryTable("table1"); var clause = new FullTextClause("Peter", new FieldReference(t1, "field")); dataQuery.AddTable(t1); dataQuery.AddWhere(clause); // Execute Execute(dataQuery); // Validate Assert.AreEqual( "select * from [table1] t1 where contains(t1.[field],@p1)", ExecutedSql); }
private string GetAlias(QueryTable table) { return _aliasMap[table]; }
/// <summary> /// Creates a new <c>FieldReference</c> instance. /// </summary> /// <param name="table">The table that we are referencing</param> /// <param name="fieldName">The name of the field</param> public FieldReference(QueryTable table, string fieldName) { _table = table; _fieldName = fieldName; }
public void Create_Query_With_Two_Tables() { // Setup var dataQuery = CreateSelectQuery(); var t1 = new QueryTable("table1"); var t2 = new QueryTable("table2"); dataQuery.AddTable(t1); dataQuery.AddTable(t2); // Execute Execute(dataQuery); // Validate Assert.AreEqual("select * from [table1] t1, [table2] t2", ExecutedSql); }
public void Fulltext_Clause_With_Only_Wildcard_Character_Is_Ignored() { // Setup var dataQuery = CreateSelectQuery(); var t1 = new QueryTable("table1"); var clause = new FullTextClause("*", new FieldReference(t1, "field")); dataQuery.AddTable(t1); dataQuery.AddWhere(clause); // Execute Execute(dataQuery); // Validate Assert.AreEqual( "select * from [table1] t1", ExecutedSql); }
public Join LeftJoin(QueryTable table) { return new Join(this, table, JoinType.Left); }
public Join InnerJoin(QueryTable table) { return new Join(this, table, JoinType.Inner); }
public Join(TableBase left, QueryTable right, JoinType joinType) { _left = left; _right = right; _joinType = joinType; }