DevForce Community Forum : parent child insertion record with (Oracle) http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : parent child insertion record with (Oracle) Wed, 10 Jun 2026 17:30:01 -700 Mon, 06 Sep 2010 04:11:14 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=2121 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ parent child insertion record with (Oracle) : OK. Thanks very much http://www.ideablade.com/forum/forum_posts.asp?TID=2121&PID=8369#8369 Author: Molinari
Subject: 2121
Posted: 06-Sep-2010 at 4:11am

OK.

Thanks very much]]> Mon, 06 Sep 2010 04:11:14 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2121&PID=8369#8369 parent child insertion record with (Oracle) : In theory choosing the right data... http://www.ideablade.com/forum/forum_posts.asp?TID=2121&PID=8359#8359 Author: kimj
Subject: 2121
Posted: 03-Sep-2010 at 3:24pm

In theory choosing the right data type for properties in the CSDL is the responsibility of the Oracle provider, so check with Devart to see if this is a known problem or has a workaround.]]> Fri, 03 Sep 2010 15:24:48 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2121&PID=8359#8359 parent child insertion record with (Oracle) : I would like to ask one more thing... Rather... http://www.ideablade.com/forum/forum_posts.asp?TID=2121&PID=8355#8355 Author: Molinari
Subject: 2121
Posted: 03-Sep-2010 at 1:39pm

I would like to ask one more thing...

Rather every time update a EDMX manually. Do you know any way that we can convert that decimal value to int. Automatically.

because the DB has more than 200 table.

you can not keep doing manually


Thanks...]]> Fri, 03 Sep 2010 13:39:06 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2121&PID=8355#8355 parent child insertion record with (Oracle) : Problem Solved. Problem was in... http://www.ideablade.com/forum/forum_posts.asp?TID=2121&PID=8353#8353 Author: Molinari
Subject: 2121
Posted: 03-Sep-2010 at 1:24pm

Problem Solved.

Problem was in EDMX.

Thanks very much.....]]> Fri, 03 Sep 2010 13:24:58 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2121&PID=8353#8353 parent child insertion record with (Oracle) : Your entities are not defined... http://www.ideablade.com/forum/forum_posts.asp?TID=2121&PID=8351#8351 Author: kimj
Subject: 2121
Posted: 03-Sep-2010 at 12:14pm

Your entities are not defined correctly.
 
VENDA.VENDAID should have the StoreGeneratedPattern attribute in both SSDL and CSDL.  This is the parent entity, and its ID is assigned by the database when a record is inserted.
 
ITEMVENDA.FK_VENDAID should not have the StoreGeneratedPattern attribute in either SSDL or CSDL.  This is a foreign key field, and the value will come via your code and DevForce, when you do something like anItemVenda.Venda = aVenda.
 
To make these changes you will likely need to manually edit the XML in the EDMX.
]]> Fri, 03 Sep 2010 12:14:16 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2121&PID=8351#8351 parent child insertion record with (Oracle) : hey i am uploding my EDMX could... http://www.ideablade.com/forum/forum_posts.asp?TID=2121&PID=8347#8347 Author: Molinari
Subject: 2121
Posted: 03-Sep-2010 at 11:24am

hey i am uploding my EDMX

could you see the problem. please.

edmx.txt




Thanks by attention]]> Fri, 03 Sep 2010 11:24:06 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2121&PID=8347#8347 parent child insertion record with (Oracle) : DevForce is agnostic regarding... http://www.ideablade.com/forum/forum_posts.asp?TID=2121&PID=8345#8345 Author: kimj
Subject: 2121
Posted: 03-Sep-2010 at 11:10am

DevForce is agnostic regarding the actual database and provider used, since all database access is done through the Entity Framework.  It's likely that the problem is with the provider, so please check both the CSDL and SSDL definitions of this entity in the EDMX to see that the StoreGeneratedPattern is set correctly on the ID property.  You can post or upload your EDMX here if you have any questions.]]> Fri, 03 Sep 2010 11:10:27 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2121&PID=8345#8345 parent child insertion record with (Oracle) : Hi thanks for reply My ID not... http://www.ideablade.com/forum/forum_posts.asp?TID=2121&PID=8344#8344 Author: Molinari
Subject: 2121
Posted: 03-Sep-2010 at 10:51am

Hi thanks for reply
My ID not always storing value 0

I am using Devart provider v5.60 for oracle.

Why I have problem with oracle and its working good with MS SQL Server
I am facing other problem of parent child insertion in oracle.

Is DevForce much not confirmtable with Oracle?

I testing and occurred this error :

A depended property in a ReferentialConstraint is mapped to a store-generated column. Column:FK_VENDAID!!!

]]> Fri, 03 Sep 2010 10:51:26 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2121&PID=8344#8344 parent child insertion record with (Oracle) : Can you check the ITEMVENDA ID... http://www.ideablade.com/forum/forum_posts.asp?TID=2121&PID=8340#8340 Author: kimj
Subject: 2121
Posted: 03-Sep-2010 at 9:18am

Can you check the ITEMVENDA ID assignment after adding each entity - is the ID always 0? If so, then it sounds like the ID might not be recognized as an "auto-increment" or store-generated ID. 
 
In the CSDL section of your EDMX, check that the ID property for ITEMVENDA indicates it is store generated.  For example, it should look something like this:
          <Property Name="ITEMVENDA_ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
 
If the StoreGeneratedPattern is not in the entity definition in the CSDL, but is defined for the entity in the SSDL, then this is a problem with the EF Oracle provider.  Which provider are you using?
]]> Fri, 03 Sep 2010 09:18:27 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2121&PID=8340#8340 parent child insertion record with (Oracle) : Hi There I catch up with other... http://www.ideablade.com/forum/forum_posts.asp?TID=2121&PID=8335#8335 Author: Molinari
Subject: 2121
Posted: 03-Sep-2010 at 7:48am

Hi There

I catch up with other Database Problem.
I am working with parent and child and below code works fine with MS SQL SERVER
But Throwing Exception in Oracle

My aim is to Insert one record after another record.Its works fine when I insert single record
but if I try to insert another one getting error.

            var mgr = new Entities();
            for (int i = 0; i < 10; i++)
            {
               ITEMVENDA c = new ITEMVENDA() { NOME = "DEV " + i,   VALORUNIT = 11, FK_VENDAID = 43 };
               mgr.AddEntity(c);
            }
            mgr.SaveChangesAsync(op =>
            {
               if (op.IsCompleted)
                    MessageBox.Show("Sucess");
               else
                    MessageBox.Show(op.Error.Message);
            });

Excepyion:-   An entity with this key: ITEMVENDA: 0 already exists in this EntityManage
]]> Fri, 03 Sep 2010 07:48:26 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2121&PID=8335#8335