How to resolve “SqlClrProvider not found” without installing sql server on the client machine or needing a deployment project

While working on a project I needed to start and stop SQL jobs via a web application, this worked great on my local machine but as soon as I published to the client web server I started getting SQLClrProvider not found exceptions.

For some reason this DLL is not readily available on the windows system so it’s not as simple as dropping a DLL into the bin folder, however the DLL does exist in the GAC (on your local machine, or any machine with SQL Server Installed)
Read more “How to resolve “SqlClrProvider not found” without installing sql server on the client machine or needing a deployment project”