Page 1 of 1

Error when using Procedure in EF (dotConnect for Oracle)

Posted: Thu 21 Jan 2010 10:02
by intiwilly
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,

Posted: Thu 21 Jan 2010 15:11
by AndreyR
Please make a couple of models (.edmx and .edml) containing the mentioned couple of
tables and the procedure mapping. We will investigate the difference.

Solution??

Posted: Tue 17 Aug 2010 19:44
by nycsca
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!

Posted: Wed 18 Aug 2010 12:17
by AndreyR
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.