Add reference constraint support for sql server

[kaiserjpg]

It would be nice to add support for error 547 in sql server which is a reference constraint error. I created a pull request for you to review the new feature and if approved update the nuget package.

[Giorgi]

Thanks for the PR. Do you know if there is a similar error in other database engines so that we can support it in all packages ?

[kaiserjpg]

I saw the latest list of errors in mysql here
Not sure how accurate it is, since I saw that you use 1062 for DuplicateEntryForKey (Unique constraint) but here the code is 1169. This might be related to the DB version.

For PostgreSQL you can find the latest list here . Keep in mind that PostgreSQL uses two codes for this validation:

[Giorgi]

Merged.

[Giorgi]

@kaiserjpg I added support for ReferenceConstraintException for other databases too