Devart Forums

prodok

Not when binding the result to a list or something else.

prodok

That's no real option for us. We have 110 Tables each having about 100 or 200 fields.

One of the reasons to do a "select new { c.ID, c.ProjectName, c.Remark };" is to read only the data that is needed for the current operation. That can be nearly any combination of the fields in the table.

The three fields in the "select new" i wrote were only an example to point out the problem.

Something where we can hook in would really help, not only for the "null problem"

Or, if we could configure the provider to convert nulls to String.Empty would solve the main problem.

prodok

First: Thanks for the suggestion and sorry for the late response.

We tried that and at the beginning it looked like it would be the solution. But now we have recognized that the code in the generated entity class is not always executed so that it works only sometimes.

When this query is executed, the code in the entity class is executed

Code: Select all

var query = from c in context.Projects
            orderby c.ProjectName
            select c;

When this query is executed, the code in the entity class is not executed

Code: Select all

var query = from c in context.Projects
            orderby c.ProjectName
            select new { c.ID, c.ProjectName, c.Remark };

I guess that the generated class is only used when a complete entity is needed like in the first case and otherwise the framework does it in a different way.

Do you have an idea what we could do?

Thanks in advance

Oliver

prodok

Hi,

we use dotConnect for Oracle with entity framework. Everything works fine but there is one problem:

We would like to get strings that are null in the database as empty strings in the entity objects.

Is there a way to tell dotConnect for Oracle to convert null strings to an empty string when reading the data ?

Thanks in advance

Oliver

Devart Forums

Search found 4 matches

NULL and empty strings in Oracle