Discussion of open issues, suggestions and bugs regarding Entity Developer - ORM modeling and code generation tool
2 posts • Page 1 of 1
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.