Conditional operators in projection

[Yoke78]

Hello,

I'm connecting to an Oracle database using dotConnect for Oracle.
I have an error when using conditional operators in projection such as ?: or ??

Here's a query example (probably not 100% exact):

var query = (from user in context.Users.AsQueryable()
select new user2()
{
name = user.Name,
address = user.Street=="" ? "" : user.Street + user.City
});

Is there a restriction using such operator with the Oracle provider (it works fine using MS standard provider for SQL Server) ?

Thanks,
Yoann

[MariiaI]

Thank you for the report. We have reproduced the issue with Oracle conditional operators and empty strings. We will investigate it and notify you about the results as soon as possible.
As a workaround, you could try rewriting your query in the next way:

Code: Select all

var query = (from user in context.Users.AsQueryable()
select new user2()
{
name = user.Name,
address = user.Street==null ? "": user.Street + user.City
});

Please notify us about the results.

[Yoke78]

Hello,
Thanks for your investigation.

I had problem to see the exact error due to a 3rd party componant.
Now, I have a clear error, which is ORA-12704: character set mismatch.
I fixed the issue changing the columns from nvarchar2 to varchar2.

Yoann

[MariiaI]

Thank you for the additional information. We have reproduced the issue with 'ORA-12704: character set mismatch' error. We will investigate it and notify you about the results.

[MariiaI]

We have fixed the bugs that refer to the Oracle conditional operators and nvarchar datatypes. The fix will be available in the next build of LinqConnect, which we are planning to release in about two weeks.

[MariiaI]

New build of dotConnect for Oracle 7.1.58 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with active subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?f=1&t=24670