Bulk fetch and Update entity record in Console app.

(0) Share

Report

Posted on by Shubh12

Hi Experts,

Looking for the best approach to fetch and update the entities in bulk. Please suggest best approach to deal with this requirement, I am fetching List of Guids (~80K+) from an external database and want to update an entity in CRM by increment the counter integer field and setting one option set field. So far as per my understanding following are the possible approaches :

1. Using Early-bound classes - Querying the context in batches by passing 5K entity id at once and then looping through the entitylist and update the entity context with-in foreach loop.

2. Using QueryExpression - Passing the Guid ids in batch/page of 5k in query expression using ConditionOperator.In operator, retriveMultipleRespone and then loop through the entities and preparing the updaterequest collection and call executeMultiple again repeat the same for remaining pages.

Please suggest which approach will better or any-other approach to handle it more efficient way. Can we use multi-threading here ?

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Shubh_K 80 on at

Like (0)

Report

Hi Experts,

Looking for the best approach to fetch and update the entities in bulk. Please suggest best approach to deal with this requirement, I am fetching List of Guids (~80K+) from an external database and want to update an entity in CRM by increment the counter integer field and setting one option set field. So far as per my understanding following are the possible approaches :

1. Using Early-bound classes - Querying the context in batches by passing 5K entity id at once and then looping through the entitylist and update the entity context with-in foreach loop.

2. Using QueryExpression - Passing the Guid ids in batch/page of 5k in query expression using ConditionOperator.In operator, retriveMultipleRespone and then loop through the entities and preparing the updaterequest collection and call executeMultiple again repeat the same for remaining pages.

Please suggest which approach will better or any-other approach to handle it more efficient way. Can we use multi-threading here ?

Thanks

Shubh

Was this reply helpful? Yes No
Shubh12 5 on at

Like (0)

Report

Hello Experts,

Looking for the best approach to fetch and update the entities in bulk. Please suggest best approach to deal with this requirement, I am fetching List of Guids (~80K+) from an external database and want to update an entity in CRM by increment the counter integer field and setting one option set field. So far as per my understanding following are the possible approaches :

1. Using Early-bound classes - Querying the context in batches by passing 5K entity id at once and then looping through the entitylist and update the entity context with-in foreach loop.

2. Using QueryExpression - Passing the Guid ids in batch/page of 5k in query expression using ConditionOperator.In operator, retriveMultipleRespone and then loop through the entities and preparing the updaterequest collection and call executeMultiple again repeat the same for remaining pages.

Please suggest which approach will better or any-other approach to handling it more efficient way. Can we use multi-threading here ?

Was this reply helpful? Yes No
Shubh_K 80 on at

Like (0)

Report

Hi Experts,

Looking for the best approach to fetch and update the entities in bulk. Please suggest best approach to deal with this requirement, I am fetching List of Guids (~80K+) from an external database and want to update an entity in CRM by increment the counter integer field and setting one option set field. So far as per my understanding following are the possible approaches :

1. Using Early-bound classes - Querying the context in batches by passing 5K entity id at once and then looping through the entitylist and update the entity context with-in foreach loop.

2. Using QueryExpression - Passing the Guid ids in batch/page of 5k in query expression using ConditionOperator.In operator, retriveMultipleRespone and then loop through the entities and preparing the updaterequest collection and call executeMultiple again repeat the same for remaining pages.

Please suggest which approach will better or any-other approach to handle it more efficient way. Can we use multi-threading here ?

Thanks

Shubh

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hi,

I hope that this link will help you and I think you can use multi threading in your case.

It is very interesting.

https://msdynamicscrmblog.wordpress.com/2013/05/10/use-executemultiplerequest-for-bulk-createupdatedelete-using-c-in-dynamics-crm-2011-2/

https://docs.microsoft.com/en-us/previous-versions/dynamicscrm-2016/developers-guide/jj863631(v=crm.8)?redirectedfrom=MSDN

Thanks.

Was this reply helpful? Yes No

Community site session details

Bulk fetch and Update entity record in Console app.

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Featured topics

Product updates

Community site session details

Bulk fetch and Update entity record in Console app.

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Featured topics

Product updates