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