[vital.mih]

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.Sql;
using Microsoft.SqlServer.Server;
using DiasToCrm.CrmWebService;

namespace DiasToCrm
{
public static class Proxy {
[SqlProcedure()]
public static void AddCustomerToCrm(string ExtID, string Name, string INN, int RelationshipType, string Phone1, string Phone2, string Phone3, string email, out string Test, out string ErrorMessage, out string Ret_Error)
{
Test = String.Empty;
ErrorMessage = String.Empty; // по дефолту ошибок нет
Ret_Error=String.Empty;
try
{
// Set up the CRM Service.
CrmAuthenticationToken token = new CrmAuthenticationToken();
token.AuthenticationType = 0;
token.OrganizationName = "ServiceDesk";

CrmService service = new CrmService();
service.Url = "http://crm:5555/ServiceDesk/mscrmservices/2007/crmservice.asmx";
service.CrmAuthenticationTokenValue = token;
service.Credentials = System.Net.CredentialCache.DefaultCredentials;


QueryByAttribute query = new QueryByAttribute();
query.ColumnSet = new AllColumns(); ;
query.EntityName = EntityName.account.ToString();
query.Attributes = new string[] { "new_ExtID" };
query.Values = new string[] { "111" };

RetrieveMultipleRequest request = new RetrieveMultipleRequest();
request.Query = query;
request.ReturnDynamicEntities = true;

//Выводим коллекцию значений
try
{
RetrieveMultipleResponse response = (RetrieveMultipleResponse)service.Execute(request);
BusinessEntityCollection Customer = response.BusinessEntityCollection;
Test = Customer.BusinessEntities.Length.ToString();
}
catch (Exception Ret_ex)
{
Ret_Error = Ret_ex.Message;
}


}
catch (Exception ex)
{
ErrorMessage = ex.Message;
}


}
}
}


Я максимально упростил процедуру и создал аккаунт с атрибутом new_ExtID=111.