% character

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Roland.Despinoy
Posts: 4
Joined: Mon 26 Nov 2012 20:20

% character

Post by Roland.Despinoy » Mon 26 Nov 2012 21:08

Hello,

Please excuse me if this question has already been asked, I didn't find it on the previous posts.

Is there any option to re-activate the "%" caracters in the queries ? ->
a from s in db.MyClasses
where s.Name == "s%s" ...

will be translated directly with the special SQL caracter % in the generated statement.
It worked well for us in previous versions, but we renewed our license and it is now ignored by the DotConnect oracle provider "s%s" will be handled as "ss"

Thank you for your time

Roland

Shalex
Site Admin
Posts: 8248
Joined: Thu 14 Aug 2008 12:44

Re: % character

Post by Shalex » Tue 27 Nov 2012 10:24

Please give us the following information:
1) the build number (x.xx.xxx) of your dotConnect for Oracle;
2) the ORM Framework you are working with (e.g., Entity Framework);
3) if it is Entity Framework, specify its version (1.0/4.0/4.1/4.2/4.3/5.0).
If possible, send us a small test project to reproduce the issue in our environment.

Roland.Despinoy
Posts: 4
Joined: Mon 26 Nov 2012 20:20

Re: % character

Post by Roland.Despinoy » Tue 27 Nov 2012 20:01

Hello,

We are using Entity Framework 4.0
I will send you the build numbers and a sample project tomorrow, I am currently outside the office.

Thank you

Roland.Despinoy
Posts: 4
Joined: Mon 26 Nov 2012 20:20

Re: % character

Post by Roland.Despinoy » Wed 28 Nov 2012 14:57

It appears since the version v6 from the dotConnect.

I can add it a sample project, but I just show a query wich behavior changes since the v6 :
using (var entities = new EntitiesContext())
{

var restuls = from el in entities.Cotations
where el.Libelle.StartsWith("s%s")
select el.Libelle;
}

IN previous version (before v6)
results will be ->
sas
sis
seeeess
sseee

After v6
Only the sseee value will be returned

Shalex
Site Admin
Posts: 8248
Joined: Thu 14 Aug 2008 12:44

Re: % character

Post by Shalex » Fri 30 Nov 2012 14:50

Please turn on the following option:

Code: Select all

        var config = Devart.Data.Oracle.Entity.Configuration.OracleEntityProviderConfig.Instance;
        config.QueryOptions.NoEscapeLike = true;
The issue was discussed at http://forums.devart.com/viewtopic.php?t=22041.

Roland.Despinoy
Posts: 4
Joined: Mon 26 Nov 2012 20:20

Re: % character

Post by Roland.Despinoy » Fri 30 Nov 2012 17:07

Thank you for your help !

We try with this option.

Post Reply