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