dotConnect converts empty string to null

[Albert]

Hello,
I try something like this:

Code: Select all

var item = DbContext.GetTable<SomeEntity>().Select(d => new
        {
            Str1 = "",
            Str2 = d.Name,
        }).First();

But item.Str1 equals null instead of empty string. Why this happening? Thanks!

[MariiaI]

This issue is not related to dotConnect for Oracle. This is related to the fact that Oracle converts empty strings ("") to null. Please refer to:
http://stackoverflow.com/questions/1327 ... -in-oracle

[Albert]

This issue is not related to dotConnect for Oracle. This is related to the fact that Oracle converts empty strings ("") to null.

At that rate I don't understand two things:
1) Why the same query gives me item.str1 = "" (not null) with dotConnect for Oracle v6.0.58?
2) Why the following query

Code: Select all

var item2 = DbContext.GetTable<SomeEntity>().Select(d => new
        {
            Str1 = "",
            Str2 = "",
        }).First();

gives me item2 = { Str1 = "", Str2 = "" }. Both queries are not querying empty(null) strings from oracle. For example, first query translates to:

Code: Select all

SELECT t1.NAME FROM SOMETABLE t1 WHERE ROWNUM <= 1

Thus, Str1 must be defined on client-side. Could you explain please, what is going on? Thanks!

[MariiaI]

At that rate I don't understand two things:
1) Why the same query gives me item.str1 = "" (not null) with dotConnect for Oracle v6.0.58?
2) Why the following query

Code: Select all

var item2 = DbContext.GetTable<SomeEntity>().Select(d => new
        {
            Str1 = "",
            Str2 = "",
        }).First();

gives me item2 = { Str1 = "", Str2 = "" }. Both queries are not querying empty(null) strings from oracle. For example, first query translates to:

Code: Select all

SELECT t1.NAME FROM SOMETABLE t1 WHERE ROWNUM <= 1

Thus, Str1 must be defined on client-side. Could you explain please, what is going on? Thanks!

Please specify the version of Entity Framework you are working with. Also, please send us a small test project, so that we are able to reproduce the behaviour you have encountered, basing on your scenario.
In this case, we will investigate the issue in more details and find the solution for you in a shortest time.

[Albert]

I use:
- the dotConnect for Oracle v8.4.201.0 and LinqConnect v4.4.539.0 (not Entity Framework)
- the Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production.
You can download the test project from this link
https://onedrive.live.com/?cid=e2db3a53 ... GmY4Mybw_0

[MariiaI]

Thank you for the additional information. We will investigate this behaviour in more details and inform you about the results as soon as possible.

[MariiaI]

We have investigated this behaviour and, currently, there are no plans to make changes for such scenarios due to the complexity of the issue.