Hi, everyone...

I was wondering if anyone can help me convert the following query to LLBLGen format:

SELECT * FROM Locations WHERE REPLACE(ShortName, ' ','') = 'CzechRepublic'

The requirement is to compare a certain City/Country name (without spaces) with a DB City/Country name (with spaces). The above query removes the spaces in the names stored in DB.

The code is:

LocationsCollection cities = new LocationsCollection(); IPredicateExpression filterToUse = new PredicateExpression();

filterToUse.Add(LocationsFields.ShortName == cityName);

cities.GetMulti(filterToUse);

I need to change "LocationsFields.ShortName" but to what?

I tried Help > Generated code > Calling a database function. Didn't help.

Thanks

You could use DBFunctionCalls. For example:

// the filter
EntityField fiedlWithReplace = 
    new EntityField("LocationShortNameSpaceStrip", new DbFunctionCall("REPLACE", new object[]{ LocationFields.ShortName, " ", ""}) );

IPredicateExpression filter = new PredicateExpression(fiedlWithReplace == "CzechRepublic");

// fetch
LocationCollection locations = new LocationCollection();
locations.GetMulti(filter);

HTH

Thanks, that solved the problem...