I am trying to fetch data from an OData url in a script component in an SSIS package. I have been trying to use Newtonsoft.JSON but the assembly doesn't load at runtime. The general resolution is to deploy the assemmbly to GAC or auto resolve the assembly by loading it from a location. I am not keen on doing that.
Is there a way in C# to fetch/deserialize data form an OData url, without using custom libraries/dlls?