Using InitialLOBFetchSize with EntityFramework

Question

I have an Oracle database that I access through the Entity Framework, and I see that performance affects the choice where I click on tables with CLOB columns .

If I break the query created Entity Framework, I get the same results with a simple call ExecuteReaderto help OracleCommand, but I can improve the performance by setting InitialLOBFetchSizeto -1 on OracleCommand.

I would like to do the same for the Entity Framework.

How to tell Entity Framework set InitialLOBFetchSizeto -1?

This is for Entity Framework 4.

Answer 1

I had the same problem several years ago, and I ended up using wrapped OracleConnection, OracleCommand, DbProviderFactory and other ADO.NET classes and the Entity Framework provider, so any EF operation does with examples of these classes, I was able to enter any functionality or change the command configuration or connection.