CRM plugin error connection

Question

I write this query in a crm plugin but i get this error

I create this view (vwPayrollEmployees) in crm database

Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed

SqlConnection myConnection = new SqlConnection("Data Source=........;Initial Catalog=......;Persist Security Info=True;User ID=sa;Password=.......;");
SqlCommand myCommand = new SqlCommand("[Depart]FROM [mbm_MSCRM].[dbo].[vwPayrollEmployees] WHERE [mbmhr_EmployeeNbr] =@EmpNbr", myConnection);
myCommand.Parameters.Add("@EmpNbr", empnbr);

myCommand.Connection = myConnection;
myConnection.Open();
SqlDataReader myReader = myCommand.ExecuteReader();

while (myReader.Read())
{
vdep = myReader["[Depart]"].ToString();

}
myConnection.Close();

Andrew Butenko Andrew Butenko · Accepted Answer · 2016-01-13T16:33:43

I believe you get this error because your plugin runs in Sandbox that disallow such operations. But the main question is - why do you need this?

CRM plugin error connection

2 Answers