Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
- Posts: 1
- Joined: Thu 21 Jul 2011 10:29
currently we are using entity framework to access an oracle database. Additionally we call stored procedures with the ExecuteFunction of the ObjectContext.
Code: Select all
public int ExecuteFunction(string functionName, params ObjectParameter parameters);
In the dbMonitor I can see that every call of a stored procedure is prepared. This causes an additional overhead in the database (calls sys.dbms_describe.describe_procedure) that leads in our case to a massive performance issue.
It wouldn’t be necessary to prepare the statement before every call. Is there an option to avoid the preparation? Maybe there is an option in the connection like “Unprepared Execution” in PostgreSQL?
- Site Admin
- Posts: 8248
- Joined: Thu 14 Aug 2008 12:44
We will investigate the possibility to avoid the preparation and notify you about the results as soon as possible.