% character

% character

Postby 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
Roland.Despinoy
 
Posts: 4
Joined: Mon 26 Nov 2012 20:20

Re: % character

Postby 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.
Shalex
Devart Team
 
Posts: 7608
Joined: Thu 14 Aug 2008 12:44

Re: % character

Postby 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

Postby 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
Roland.Despinoy
 
Posts: 4
Joined: Mon 26 Nov 2012 20:20

Re: % character

Postby 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.
Shalex
Devart Team
 
Posts: 7608
Joined: Thu 14 Aug 2008 12:44

Re: % character

Postby Roland.Despinoy » Fri 30 Nov 2012 17:07

Thank you for your help !

We try with this option.
Roland.Despinoy
 
Posts: 4
Joined: Mon 26 Nov 2012 20:20


Return to dotConnect for Oracle