在asp.net web api中使用Microsoft Common data services SDK

<connectionStrings>
  <add name="CdsConnection" connectionString="AuthType=Office365;Url=https://your-cds-instance.crm.dynamics.com;Username=username;Password=password;" />
</connectionStrings>

using Microsoft.Xrm.Tooling.Connector;

var connectionString = ConfigurationManager.ConnectionStrings["CdsConnection"].ConnectionString;
var serviceClient = new CrmServiceClient(connectionString);
var service = serviceClient.OrganizationServiceProxy;

using Microsoft.Xrm.Sdk;
using Microsoft.Xrm.Sdk.Query;

// 查询所有联系人记录
var query = new QueryExpression("contact");
query.ColumnSet = new ColumnSet("fullname", "emailaddress1");

var contacts = service.RetrieveMultiple(query).Entities;
foreach (var contact in contacts)
{
    var fullName = contact.GetAttributeValue<string>("fullname");
    var emailAddress = contact.GetAttributeValue<string>("emailaddress1");

    // 处理联系人数据...
}

// 创建新的账户记录
var account = new Entity("account");
account["name"] = "Test Account";
account["telephone1"] = "1234567890";

var accountId = service.Create(account);

// 更新账户记录
var updatedAccount = new Entity("account");
updatedAccount.Id = accountId;
updatedAccount["name"] = "Updated Account";

service.Update(updatedAccount);

// 删除账户记录
service.Delete("account", accountId);