Friday, December 10, 2010

Load DataSet Error: Cannot add a DataRelation or Constraint

If you work in an international team there may occur problems with the Locale property of datasets.

The error may also occur when running the application: "Cannot add a DataRelation or constraint that has different Locale..."

Often you can not fix this within visual studio but there is a simple way to fix it with notepad:

Search and replace the string "msdata:Locale="de-CH" (example for German-Switzerland) with an empty string using notepad. Simply open the xsd file with notepad.

Make sure to create a backup before. If you have a versioning tool this should be no problem anyway.

No comments: