LIKE operator instead of INSTR

Discussion of open issues, suggestions and bugs regarding Entity Developer - ORM modeling and code generation tool
Post Reply
Posts: 2
Joined: Wed 18 Nov 2009 14:14

LIKE operator instead of INSTR

Post by rwrife » Thu 19 Nov 2009 15:18

Is there a way to force the framework to use the like operator instead of instr when doing a contains, startswith or endswith? From my testing I found that the SQL generated by Devart (w/ instr) takes about 5 minutes to execute on my table, however when I run the same SQL using like instead of instr it takes about 2 seconds? From what I've read it looks like my only option is to create a stored proc, but by doing so I lose the ability to use Expression to dynamically build my where clause.

Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Thu 19 Nov 2009 17:03

We have implemented this behaviour in Entity Framework support for all dotConnects since *.*.44 build.

Post Reply