No Unique Key/Constraint in DBML? RRS feed

  • Question

  • I am trying to upgrade an existing DataSet that has some 2 column unique keys/constraints (in addition to a primary key), but I didn't see this option in the DBML designer ... is this by design, or ... ?  Anyway to do this in the DBML designer?



    Saturday, January 24, 2009 6:53 AM


  • Unique constraints have to be defined and enforced in the database. L2S does not have all data in your db tables in memory so it wouldn't be able to enforce unique constraints without an extra roundtrip anyway...
    Monday, January 26, 2009 2:08 AM