SqlReplication: Refactor resource to not use Load()

Details of the scenario you tried and the problem that is occurring

This resource is dependent on loading an assembly from the GAC for it to be able to create the objects it uses.

Verbose logs showing the problem

n/a

Suggested solution to the issue

We should instead refactor it so it does not need to use Load(), which is version dependent to load the correct assembly for the correct SQL Server version. But instead use SQLPS or SqlServer module to get the assrmbly loaded into the session.

Looked into if there was another way to create the types needed in this resource, instead of using Load(). But neither SQLPS och SqlServer module loads the necessary assembly. So the only way might be to load the assembly directly from the GAC using Load().

The DSC configuration that is used to reproduce the issue (as detailed as possible)

n/a

SQL Server edition and version the target node is running

n/a

SQL Server PowerShell modules present on the target node

n/a

The operating system the target node is running

All

Version and build of PowerShell the target node is running

n/a

Version of the DSC module that was used ('dev' if using current dev branch)

Dev

No file, test, or entry point is named. Start by locating the SqlReplication resource and its Load() usage, then inspect how the SQLPS or SqlServer module exposes the required assemblies; done means the resource no longer depends on version-sensitive loading while still creating its required types.