Auto Number generation

(0) Share

Report

Posted on by sdnd2000

2,510

Hi, when I do auto number generation in plugin, I use "lock (SyncLock)" to handle the concurrency, but it looks like it doesn't work very well, I still get duplicated numbers sometimes.

 private void RegNumber(Entity entity, IOrganizationService service)
 {
     lock (SyncLock)
     {
  if (entity != null)
  {
      // read  counter
      // update counter
  }
     }
  }

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

Radu Chiribelea 6,667 on at

Like (0)

Report

RE: Auto Number generation

Hello - please check if following blog can help you with your request : www.akaes.com/.../how-to-implement-robust-auto-numbering-using-transactions-in-microsoft-dynamics-crm

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
RE: Auto Number generation

Hi sdnd2000 ,

you need to set your plugin like following code:

namespace YOURNAMESPACE.Plugins { public class MyAutoNumber : IPlugin { public MyAutoNumber() { } private static readonly object SyncLock = new object(); public void Execute(IServiceProvider serviceProvider) { var context = (Microsoft.Xrm.Sdk.IPluginExecutionContext)serviceProvider.GetService(typeof(Microsoft.Xrm.Sdk.IPluginExecutionContext)); var factory = (IOrganizationServiceFactory)serviceProvider.GetService(typeof(IOrganizationServiceFactory)); var service = factory.CreateOrganizationService(context.UserId); var orgcontext = new OrganizationServiceContext(service); var tracer = (ITracingService)serviceProvider.GetService(typeof(ITracingService)); try { if (context.InputParameters.Contains("Target") || (context.InputParameters["Target"] is Entity)) { var entity = context.InputParameters["Target"] as Entity; if (context.IsInTransaction) { lock (SyncLock) { // your code here } } } } catch (Exception ex) { tracer.Trace("MyAutoNumber Plugin Exception: " + ex); throw new InvalidPluginExecutionException(ex.Message); } } } }

Please let me know if you solve.

If you found the answer helpful, please mark as Verified

Join my network on LinkedIn Follow me on Twitter

Thank You & Best Regards

Francesco Picchi

Microsoft Dynamics CRM Consultant, Bologna+Milano, ITALY

Independent Contractor

http://www.francescopicchi.com

Was this reply helpful? Yes No
Wayne Walton 13,728 on at

Like (0)

Report

RE: Auto Number generation

There are a great many free (and some for-pay) options out there for autonumbering in CRM. you might be better off just using one someone has already created instead.

Was this reply helpful? Yes No
sdnd2000 2,510 on at

Like (0)

Report

RE: Auto Number generation

Hi, Francesco,

sorry, I didn't paste all the code, but your code snippet is exactly the same as what I am using nows

Was this reply helpful? Yes No
Verified answer

tw0sh3ds 5,600 on at

Like (1)

Report

RE: Auto Number generation

Locking is not good enough if your plugins are running in Sandbox (there can be multiple Sandbox processing services). The correct way (with some exceptions but usually works without a problem) can be found here:

bettercrm.blog/.../making-use-of-transactions-in-dynamics-365-customer-engagement

Basically what you have to do is to create a dummy update to lock the transaction and do all the critical section logic after that.

Was this reply helpful? Yes No