CODEWITHSUNDEEP
linqlinq-to-sqldynamics-crm-2011dynamics-crmdynamics-crm-2013
Nick
Nick

Reputation: 870

Pre Operation Concurrent Plugins Getting MAXIMUM Existing Field Value For An Entity Records

I am trying to set a field (Record Number) on an entity in Pre-Operation plugin that triggers on create with an incremental number based on previous one. For example if the MAX Previous Record Number is 4 I will set the one being created to 5. I am using LINQ to get the MAX exiting number from entity records and then incremented by 1. My concern is that, what if 2 or more plugins execute at the same time and does the same thing. Does CRM has a sequential mechanism to force the plugins to run in sequential order and if NOT how can I avoid 2 plugins getting the same previous maximum record number?

Upvotes: 0

Views: 595

Answers (2)

Sxntk
Sxntk

Reputation: 846

The way CRM supports concurrence is: 1. The plug-in must be in the pre or post operation. 2. You need to update one field on the entity you need. (Whatever value you want). 3. You add your logic here.

The third step will grant you one plug-in execute that logic and the others will wait for it until it ends.

Edit: This is what you need:

Entity context = (Entity)executionContext.InputParameters["Target"];
Entity entity = new Entity { LogicalName = "salesorder", Id = context.Id };
entity["new_dummyfield"] = Guid.NewGuid().ToString();
service.Update(entity); // Lock

entity = service.Retrieve("salesorder", context.Id, new ColumnSet("new_autonumber"));
if (!entity.Contains("new_autonumber"))
{
    return;
}
int autonumber = (int)entity["new_autonumber"] + 1;
entity["new_autonumber"] = autonumber;
service.Update(entity);

Upvotes: 2

Darren Lewis
Darren Lewis

Reputation: 8508

Multiple plugins can indeed run concurrently therefore you cannot guarantee uniqueness of any values calculated in this way. Many solutions use an external database for auto number but keep in mind you won't be able to access this database from a Sandbox plugin.

There is a way in which you can achieve isolation using a custom entity removing the need for the external database discussed here. However, as you'll read, it's not an out of the box feature.

Upvotes: 1

Related Questions