baffled by transactrionID not mapped in relations involving acct and and subacct RRS feed

  • Question

  • in the database the contraint for transaction with regard to acct and subacct ar defined as

    ALTER TABLE "dba"."Transaction" ADD CONSTRAINT "FK_account" NOT NULL FOREIGN KEY ( "acct_ID" ASC ) REFERENCES "dba"."account" ( "acct_id" );
    ALTER TABLE "dba"."Transaction" ADD CONSTRAINT "FK_subAcct" NOT NULL FOREIGN KEY ( "subAcct_ID" ASC ) REFERENCES "dba"."SubAcct" ( "subAcct_ID" );

    I get error from entity designer something like

    Error 4 Error 11011: Association End key property 'trans_ID' is not mapped. c:\myapp\ModelMyDb.edmx 2729 9 myAppNs

    for subaccount association

    however the table's transaction ID is not automatically generated it is assigned during insert by a insert stored proc way back before .net days

    maybe this table should not be mapped because of all update, delete and insert are to be through the stored procedures?

    • Edited by fs - ab Thursday, July 19, 2012 2:26 AM
    Thursday, July 19, 2012 1:45 AM


All replies

  • sign!!!, I have to delete the model and start all voer to get rid of the Error.

    Looks like is alot more robust

    still in the process of fixing the new model with additonal function import. at least there is hope I can get it done instead of banging my head against the wall
    • Edited by fs - ab Thursday, July 19, 2012 3:17 AM
    Thursday, July 19, 2012 3:14 AM
  • Hi Fs – ab,

    Welcome to the MSDN forum.

    This error occurs when an association end in the conceptual model is a compound entity key and one “trans_ID” or more of the key properties is not mapped. To resolve this error, map all properties of the association end. For more information, see How to: Create and Edit Association Mappings (Entity Data Model Tools). If I misunderstood anything, please feel free to let me know.

    Good day.

    Alexander Sun [MSFT]
    MSDN Community Support | Feedback to us

    • Marked as answer by Alexander Sun Friday, August 3, 2012 2:21 AM
    Friday, July 20, 2012 5:04 AM