Validating database schema
If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
I would not include the part that queries the database, because it's done with Dapper, and... But since this is a third-party dependency I would use it in a separate assembly that has a reference to your DAL (to obtain the database object names), so your DAL doesn't have this dependency.Failure to register a method with Validation Event Handler causes an exception (Xml Exception) to be thrown when the XML document is found to be invalid or missing.After setting the Validation Type property, the Schema's property and Validation Event Handler of the Xml Reader Settings object, we are ready to create a validating Xml Reader.More reliable, because you'll only get the mapped entities and properties without having to jump through hoops to exclude non-mapped ones.I'll give you the heart of it, so you can fit it in appropriately.
Search for validating database schema:
Error is not on your side, but the implementation of Oracle and non-standard format “xsd: date Time”.