Error when using Procedure in EF (dotConnect for Oracle)

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
intiwilly
Posts: 3
Joined: Fri 08 Jan 2010 08:37

Error when using Procedure in EF (dotConnect for Oracle)

Post by intiwilly » Thu 21 Jan 2010 10:02

Hi,

I don't know if this is in EF or dotConnect for Oracle area.

I'm using dotConnect for Oracle and create edml (Entity Framework) using devart entity developer and using procedure to insert, update and delete.

I have 2 entityset with one to many relationship (lets say Order - OrderDetail entity). I got this following error when i set the procedure in OrderDetail entity.

Code: Select all

If an EntitySet or AssociationSet includes a function mapping, all related entity and AssociationSets in the EntityContainer must also define function mappings. The following sets require function mappings: Order_OrderDetailSet. 
But when i create edmx file. I don't get the error. For the reference create edmx vs edml http://www.devart.com/blogs/dotconnect/?p=5

Here's some of my edml file (I remove some in order to simplify the LOC)

Code: Select all

            
              
                                
                
                
                
                
              
            
          


          
            
              
                
                
                
                
                
                
                
              
            
            
              
                
                  
                                                      
                  
                  
                  
                    
                  
                
                
                  
                                   
                  
                  
                  
                    
                  
                
                
                  
                                    
                  
                  
                  
                    
                  
                
              
            
          

          
            
              
            
            
              
            
          
Here some my references

http://blogs.msdn.com/adonet/archive/20 ... pping.aspx

http://msdn.microsoft.com/en-us/library/bb399203.aspx

Many thanks,
Last edited by intiwilly on Fri 22 Jan 2010 03:59, edited 1 time in total.

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Thu 21 Jan 2010 15:11

Please make a couple of models (.edmx and .edml) containing the mentioned couple of
tables and the procedure mapping. We will investigate the difference.

nycsca
Posts: 1
Joined: Tue 09 Feb 2010 22:10

Solution??

Post by nycsca » Tue 17 Aug 2010 19:44

Did anyone find a workaround for this?

I am trying to do the same thing, assigning a stored procedure parameter to an associationEnd property.

I have dotConnect for Oracle 5.35. Would upgrading to version 5.70 solve this issue?

Help please!

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Wed 18 Aug 2010 12:17

We have fixed a similar error several builds ago. Could you please upgrade to the latest 5.70.152 release of dotConnect for Oracle?
Please notify us if anything goes wrong.

Post Reply