Where is OracleIdGenerator? : I wish I had known I was completely...

Tue, 09 Jun 2009 07:27:12 -700

Author: skingaby
Subject: 1304
Posted: 09-Jun-2009 at 7:27am

I wish I had known I was completely barking up the wrong tree. There is no need to use an IdGenerator.

To use an Oracle Sequence in DevForceEF (Silverlight or Windows):

1) Add a BEFORE INSERT trigger to the table to get the sequence value and put it into the Id column. This will then work in a way similar to a SQL Server identity column.
i.e.:
create or replace trigger DEAL_BI_GETSEQ
before insert on deal FOR EACH ROW when (NEW.DEAL_ID is null)
BEGIN select DEAL_ID_SEQ.nextval into :NEW.DEAL_ID from dual; end;

2) Edit the XML in the Entity Model's .edmx file to add the StoreGeneratedPattern attribute to the key's Property element.
i.e.:




          StoreGeneratedPattern="Identity" />





Now, EF will automagically pick up the new ID and update the item. A unit test like this will show that:
[TestMethod]
public void AddADeal()
{
    ServerModelEF.ModelEntities em = new ModelEntities();
    Deal deal = new Deal();
    long id = deal.DealId;
    em.AddToDeals(deal);
    int result = em.SaveChanges();
    Assert.IsTrue(result>0);
    Assert.AreNotEqual(id, deal.DealId);
}

Where is OracleIdGenerator? : You can use the same algorithms...

Mon, 08 Jun 2009 09:37:32 -700

Author: davidklitzke
Subject: 1304
Posted: 08-Jun-2009 at 9:37am

You can use the same algorithms used in DevForce Classic. I will email you the documentation used in this tutorial.

Where is OracleIdGenerator? : I am using DevForce Silverlight....

Thu, 04 Jun 2009 12:45:41 -700

Author: skingaby
Subject: 1304
Posted: 04-Jun-2009 at 12:45pm

I am using DevForce Silverlight. What do I need to do to get the business object Id's out of an Oracle Sequence?
Thanks,
Simon

DevForce Community Forum : Where is OracleIdGenerator?

Where is OracleIdGenerator? : I wish I had known I was completely...

Where is OracleIdGenerator? : You can use the same algorithms...

Where is OracleIdGenerator? : I am using DevForce Silverlight....