title: Entity Framework: Foreign key with a different type
body: <p>I've to do an import from an old database (In oracle) a lot of data to an SQL Server database.  This import will be done every night, and can be launched from .net application(asp or heavy client)</p>
  
  <p>I'm using the devart connector to the database.</p>
  
  <p>I finished to configure the database connection and started to create an edmx with only data that I'm interessted to.</p>
  
  <p>I encountered a weird thing:
  It seems that the foreign key is an Number(10)(translated in int64), and the referenced primary key is a Number(8)(translated in an int32).</p>
  
  <p>I've just no freaking idea why it has be done like this and there is no way that I can ever dream once to change this( :( ).</p>
  
  <p>The problem is that I got errors in my model:</p>
  
  <pre><code>Error 112: The types of all properties in the Dependent Role of a referential 
  constraint must be the same as the corresponding property types in the Principal 
  Role. The type of property 'GSM_ID' on entity 'My.NameSpace.Store.GG_IRTSPEZ' does
  not match the type of property 'ID' on entity 'My.NameSpace.Store.GG_STAMM' in the 
  referential constraint 'ORACLE_GIRT_GSM_FK'.    
  </code></pre>
  
  <p>Do you have any idea about how to workaround this problem?</p>