public void BulkUpsertTestInsertAndUpdate()
{
CrmConnection c = new CrmConnection("CRM");
OrganizationService service = new OrganizationService(c);
CrmBulkServiceManager mgr = new CrmBulkServiceManager(service);
List <Entity> entityList = new List <Entity>();
for (int i = 0; i < 10; i++)
{
Entity entity = new Entity("account");
entity["name"] = "account " + DateTime.Now.ToString();
entityList.Add(entity);
}
var resultsInsert = mgr.BulkInsert(entityList);
entityList.Clear();
foreach (var item in resultsInsert.ResultItems)
{
Entity entity = new Entity("account");
entity.Id = item.ItemID;
entity["name"] = "account " + DateTime.Now.ToString();
entityList.Add(entity);
}
for (int i = 0; i < 10; i++)
{
Entity entity = new Entity("account");
entity["name"] = "account " + DateTime.Now.ToString();
entityList.Add(entity);
}
var results = mgr.BulkUpdate(entityList, useUpsert: true);
}
public void BulkUpsertTestInsert()
{
CrmConnection c = new CrmConnection("CRM");
OrganizationService service = new OrganizationService(c);
CrmBulkServiceManager mgr = new CrmBulkServiceManager(service);
List <Entity> entityList = new List <Entity>();
for (int i = 0; i < 10; i++)
{
Entity entity = new Entity("account");
entity["name"] = "account " + DateTime.Now.ToString();
entityList.Add(entity);
}
var results = mgr.BulkUpdate(entityList, useUpsert: true);
}
private void RecordFailedRecord(string entityName, Entity trackEntity, CrmBulkServiceManager bulkMgr, List <Entity> entitiesToUpSert, Exception ex)
{
Entity failedEntity = new Entity("ctccrm_entitychangefailed");
failedEntity["ctccrm_name"] = entityName;
failedEntity["ctccrm_recordid"] = entitiesToUpSert[0].Id.ToString();
failedEntity.KeyAttributes = new KeyAttributeCollection();
failedEntity.KeyAttributes.Add("ctccrm_name", entityName);
failedEntity.KeyAttributes.Add("ctccrm_recordid", entitiesToUpSert[0].Id.ToString());
failedEntity["ctccrm_errormessage"] = ex.Message;
List <Entity> failedLog = new List <Entity>();
failedLog.Add(failedEntity);
trackEntity.KeyAttributes = new KeyAttributeCollection();
trackEntity.KeyAttributes.Add("ctccrm_name", entityName);
failedLog.Add(trackEntity);
bulkMgr.BulkUpdate(failedLog, transactionMode: CTCBulkTransactionMode.Single, useUpsert: true);
}
public void BulkUpdateQueryTest1()
{
CrmConnection c = new CrmConnection("CRM");
OrganizationService service = new OrganizationService(c);
CrmBulkServiceManager mgr = new CrmBulkServiceManager(service);
List <Entity> entityList = new List <Entity>();
QueryExpression q = new QueryExpression("account");
q.ColumnSet = new ColumnSet();
q.ColumnSet.AddColumn("accountid");
Entity entityData = new Entity("account");
entityData["name"] = "bulk updated " + DateTime.Now.ToString();
var results = mgr.BulkUpdate(q, entityData);
}
