Calling stored procedure

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
JEH
Posts: 5
Joined: Mon 06 Jun 2011 09:00

Calling stored procedure

Post by JEH » Thu 04 Aug 2011 11:20

Hi,

I'm trying to map an Oracle stored procedure into my entity model, but the context class fails to compile after I've done it. I'm told it doesn't contain a definition of CommandTimeout and Connection.

I'm using the dbContext template.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Mon 08 Aug 2011 11:07

Please try using the EntityObject template and refer to http://www.devart.com/dotconnect/oracle ... rsors.html:
- drag&drop the Dept table from Database Explorer on the diagram surface before setting the Value Types property of the method in the conceptual part of the model;
- the DDL/DML script of DEPT is at %ProgramFiles%\Devart\dotConnect\Oracle\Samples\tables.sql.
If this doesn't help, tell us the versions of your dotConnect for Oracle (x.xx.xxx), Visual Studio (with SP or not) and send us a small test project with your model and DDL/DML script of the corresponding database objects.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Fri 27 Jan 2012 14:26

New version of dotConnect for Oracle 6.70 is released!
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://www.devart.com/forums/viewtopic.php?t=23260 . The stored procedures support in DbContext template in case of XML mapping is implemented (Entity Framework models) in this build.

Post Reply