CreateDatabase misses some constraints RRS feed

  • Question

  • I'd like to ask a question to which I'm pretty sure the answer is: "Nope, sorry."

    My application creates its database the first time it runs. In the development database, from which the dbml was generated, there's a Foreign Key relationship in which the "Enforce Foreign Key Constraint" property has been set to "no" (using SQL Management Studio, natch.) But it is "yes" in the newly created database on another machine.

    Question: Can I get CreateDatabase to create this relationship with "Enforce Foreign Key Constraint" set to No? The reason I think I can't is that the Association attribute doesn't appear to have a property that mirrors this setting.

    Anyway, I'd appreciate any suggestions on what I should do about this. Thanks!

    Wednesday, April 7, 2010 3:33 PM