Where is OracleIdGenerator?

   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.:

<EntityType Name="DEAL">

          <Key>

            <PropertyRef Name="DEAL_ID" />

          </Key>

          <Property Name="DEAL_ID" Type="int64" Nullable="false" StoreGeneratedPattern="Identity" />

          <Property Name="DATE_ENTERED" Type="DATE" Nullable="false" />

          <Property Name="DATE_OF_DEAL" Type="DATE" Nullable="false" />

          <Property Name="FLOW_DATE_START" Type="DATE" Nullable="false" />

          <Property Name="FLOW_DATE_END" Type="DATE" Nullable="false" />

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);

}  