Unable to create relation

The problem occurs because the Object Mapper cannot onvert from the string representation of a System.Guid to a System.Guid even if the string representation pf the System.Guid is completely legal.

Edited by davidklitzke - 23-Mar-2009 at 9:45am

A DataSourceMappingInterceptor could be a workaround for the problem but hopefully there's a simpler answer, since technically this problem shouldn't exist (we have relations joining Int64 and nullable Int64 columns all over our test suite).

Both the "DataType" and "SourceDatType" values come up as System.Int64.

Following are the declarations you requested:

    /// <summary>
    /// Represents a parent/child relationship between
    /// <see cref="CompanyInfo"/> and <see cref="InvStoreQuantity"/>.
    /// </summary>
    public static EntityRelation CompanyInfo_InvStoreQuantity = new EntityRelation(
      new EntityColumn[] { CompanyInfo.CompanyCodeEntityColumn },
      new EntityColumn[] { InvStoreQuantity.CompanyCodeEntityColumn },
      false,
      "CompanyInfo_InvStoreQuantity");

//CompanyInfoDataRow
     /// <summary>The CompanyCode <see cref="T:IdeaBlade.Persistence.EntityColumn"/>.</summary>
    public static readonly EntityColumn CompanyCodeEntityColumn =
      new EntityColumn(typeof(CompanyInfo), "CompanyCode", typeof(System.Int64), false, true, false, DataSourceAccessType.ReadWrite);

//InvStoreQuantityDataRow
    /// <summary>The CompanyCode <see cref="T:IdeaBlade.Persistence.EntityColumn"/>.</summary>
    public static readonly EntityColumn CompanyCodeEntityColumn =
      new EntityColumn(typeof(InvStoreQuantity), "CompanyCode", typeof(System.Int64), true, false, false, DataSourceAccessType.ReadWrite);

The relationship is present in the Object Mapper.  It currently shows up with a relation name of CompanyInfo_InvStoreQuantity, cardinality OneToMany, and joined on CompanyCode=CompanyCode.

The relation was created when I added the CompanyInfo and InvStoreQuantity tables to the Object Mapper.

I'm currently getting an error returned when I try and retrieve data through an entityrelation.  It is specifically between two tables, CompanyInfo (contains basic information on a company) and InvStoreQuantity (records that say location X has quantity Y of a particular item).  Within SQL Server 2005 I created the relation between them on the field CompanyCode (which is the primary key of CompanyInfo) with a data type of long integer in both tables.  Going through the Object Mapper, I have made sure that both tables are using the same data type.
In my actual query, I'm building the rdbquery on the table CompanyInfo, and doing an addspan to cover the relation EntityRelations.CompanyInfo_InvStoreQuantities.  When the query tries to run, the following error comes up: 

{"Unable to create relation 'CompanyInfo_InvStoreQuantity' because of an underlying column datatype mismatch \n Column 'CompanyCode' DataType 'System.Int64' != Column 'CompanyCode' DataType 'System.Decimal'"}

I have checked the data type in the database, in the object mapper, and in my customized code(such as the Create method) and each of these are set to use the Int64 data type.  Is there somewhere else that might be throwing this off?