% character

[Roland.Despinoy]

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]

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]

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]

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]

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]

Thank you for your help !

We try with this option.