Read Only Properties with no storage in dbml RRS feed

  • Question

  • Hi,

    I have two tables in my database A and B
    A has the colum x
    B has the colum y

    Now A references B in the way that A.x = "Q" + B.y

    Is there a way to model this association in dbml? Unfortunately this data-base layout is given.

    I can add the Property in the code, but then I cannot make an association in the dbml designer.

    Thanks for any hint

    Saturday, March 28, 2009 6:04 PM


  • The associations in LINQ to SQL work only if the data in the two different columns sets is equivalent. This means that your association, where A.x = "Q" + B.y, is not supported.

    Sunday, March 29, 2009 4:47 PM