I have a requirement to be able to communicate with a remote SQL Server database from inside a plugin. When I do this, I get an error:
The action that failed was: Demand
The type of the first permission that failed was: System.Data.SqlClient.SqlClientPermission
The Zone of the assembly that failed was: MyComputer
Evidently because my plugin has to run in isolation mode, CRM is preventing my code from communicating with my own database. MS white papers say ytou can't communicate with a remote SQL Server from a plugin running in SabdBox mode. I do not have the option to change the isolation mode. What are my options?