Executing a Pattern(Wildcard) search in OQL

[Ashok Sridhar]

Hi,

I have an Employer table and a corresponding object.

When I try to do a wildcard search in OQL like

scope.GetOqlQuery<Employer>("SELECT emp FROM EmployerExtent AS emp WHERE emp.EmployerName LIKE \"*$1*\" ").ExecuteList("Ashok");

I get an error saying "expected 0 parameters received 1"

If I change the like to an equals without any wildcard it works fine.  I even tried the GetOqlQuery().Execute() method with the same error.  So generic or not, it throws an error.  What could be the issue?

[Zoran]

Hi Ashok Sridhar,

There is a slight change in the format of your OQL query that should be done. When using parameters quotation marks are not required as part of the query and also the "*" characters should be part of the parameter passed when using wildcards.
Here is a modified version of your query that should not do any problems when executed:

scope.GetOqlQuery<Employer>("SELECT emp FROM EmployerExtent AS emp WHERE emp.EmployerName LIKE $1 ").ExecuteList("*Ashok*");

Best wishes,
Zoran
the Telerik team

Check out Telerik Trainer , the state of the art learning tool for Telerik products.

[Ashok Sridhar]

Thanks Zoran.  That worked.