.Net: Notices in loading dataset by ReadXml() with options

If exceptions were thrown while reading xml:

  1. ReadXml(file, XmlReadMode.InferSchema) ---- ArgumentException may be thrown with error message:
     {"The same table (Users) cannot be the child table in two nested relations." }
  2. ReadXml(file, XmlReadMode.IgnoreSchema) --- No exception is thrown right now, but InvalidCastException may be thrown for some properties while getting property LATER with error message: {"Specified cast is not valid."}

   so, better to read xml InferSchema defaultly, then catch the ArgumentException if encountered...

  try
   {
     ds.ReadXml(xmlFile, XmlReadMode.InferSchema);
   }
   catch (ArgumentException)
   {
     ds.ReadXml(xmlFile, XmlReadMode.IgnoreSchema);
   }
   catch (Exception e)
   {
     ds = null;

return;

}

If System.Data.ConstraintException was thrown with following error message:
"Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.", please set EnforceConstraints as false.