Use ProviderType enum in providers and check against DbContext provider name

[PhenX]

          If you already define the enum, you could also add this to the Provider as property and check just the registered provider.

Originally posted by @SebastianStehle in #23 (comment)