Support for PostgreSQL SIMILAR TO command?

[TonyV]

My program has a search page on it in which I want the users to be able to specify search strings that can contain %, _, [, and ] characters. In PostgreSQL, the LIKE command does not support [ & ], but the SIMILAR TO command does.

Is there any way I can get a search that uses the SIMILAR TO command in my entity framework query?

Tony

[Shalex]

dotConnect for PostgreSQL includes the full support of LIKE and ILIKE via the Devart.Data.PostgreSql.Entity.PgSqlFunctions class (the Devart.Data.PostgreSql.Entity.dll assembly).

[Shalex]

We are investigating the possibility to support SIMILAR TO. We will post here about the results.

[Shalex]

The SimilarTo overloaded methods are added to the PgSqlFunctions class to provide support of the SQL SIMILAR TO statement.
We will post here when the corresponding build of dotConnect for PostgreSQL is available for download.

[TonyV]

Thank you very much! Do you have an estimate for when this will go out?

[Shalex]

We are planning to release the corresponding build in the end of the next week.

[Shalex]

New version of dotConnect for PostgreSQL 6.1 is released!
It can be downloaded from http://www.devart.com/dotconnect/postgr ... nload.html (trial version) or from Registered Users' Area (for users with active subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?f=3&t=24525 .

[TonyV]

When I log into the Registered Users area, I do not see a link to download version 6.x. I see a link for version 5.80.350 and for DbMonitor 3.00.3.

Why don't I see a link for the latest version?

[Shalex]

Please contact our Sales department (sales at devart.com).

[Devart]

Hello,

Please email to our sales your license number or registration email as we couldn't see dotConnect for PostgreSQL license registered for your email.

Regards,
Devart Support

[TonyV]

It's not registered to my name, it's registered to my boss. I'll get the information and and email it.