Test: Refactor ReverseEngineer EndToEnd tests

[smitpatel]

Our current testing infra test rev eng in following way.

1. Create DB
2. Rev eng DB and generate files
3. Compare generated files to expected files.

For every new type of code we generate, we need to add db creation and expected files.
Code generation is done by EFCore.Design not the provider.
We don't verify individual components making it harder to have good test coverage. Like we are missing KeyAttribute.

It may need some design on what we want to test, what we want to provide to provider-writers to test etc.

[smitpatel]

From @lajones

Good catch, but I would like to have at least one test where we do generate it because it is different from the default. Can we arrange that somehow (e.g. rename a PK or two in the E2E.sql file)?

[smitpatel]

Duplicate of #9111 already fixed