locked
AGAIN... EDM Error 0040: Type is not qualified... but Decimal? RRS feed

  • Question

  • Hello,

    recently I started getting a metadata exception:

    "Schema specified is not valid. Errors: \r\n(9,6) : error 0040: The Type decimal is not qualified with a namespace or alias. Only primitive types can be used without qualification..."

    This is the Statement:

          Property( x => x.IsPoBox ).HasColumnName( "AR_IS_PO_BOX" ).HasColumnType( "decimal");

    and the EDM-Type is a boolean.

    INterestingly, similar code works on a small testproject. I use EF V5 Code First anf Fluent Mappings. What can be the reason for this? The string "System.Decimal" does not work either.

    Regards
    DaProgramma

    Tuesday, October 2, 2012 5:25 PM

Answers

  • Well,

    it works with SQLServer, but not with Oracle. After finding that, it was easy: Oracle does not have decimal..... They use number for all and everything. Which poses another set of problems: number(1,0) cannot be mapped to bool.... :-(

    THAT I posted to the Oracle-Groups.

    daProgramma

    • Marked as answer by daProgramma Thursday, October 4, 2012 12:41 PM
    Thursday, October 4, 2012 12:41 PM