Sql: Refactor Mock tests to provide better additional mocks

[Aniruddh25]

In order to satisfy Mock test requirements, we had to add some default constructors/nullable properties.
Mock tests should ideally be sending the required mocks so we don't have to keep nullable properties. This issue is to fix our tests to generate the right mocks.

[seantleonard]

Many updates have occurred since this issue was raised. In order to identify what changes need to occur, I am searching through our

1. Test Project -> Identify areas of where mock creation/usage can be made more efficient and simplified.
2. Service Project -> for interfaces / classes which surface constructors or method signatures that are nullable only for testing purposes.

Goal(s):

• Reduce instances of Service project class/method signatures only utilized for testing purposes.