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); }