Connection/Object pool for OrganizationServiceProxy in XRM/Dynamics CRM 2011

Question

I am writing a MVC 3 WebApp which uses XRM 2011 using Early Bound. This is an internet-facing application hosted on separate machine than Dynamics IIS.

This of course makes OrganizationServiceProxy call very very frequently and response is kind of sluggish on every first hit.

Is it advisable to reuse OrganizationServiceProxy connection rather than create new instance every time?

If yes,

Is there anything to manage the connections such as
- connection pool app - MS or third party/open source
- or some framework like WCF (Never used WCF, yet)
Which design pattern is recommended if I have to write my own code to manage connection?

Sorry for the duplicate post from MS website. Hopefully this forum is more active.

score 2 · Accepted Answer · answered Jul 07 '11 at 04:33

2

After few test cycles, I have found that using CrmConection is the fastest method. Compared to above caching implementation, CrmConnection runs at least 5 times faster.

CrmConnection connection = new CrmConnection("XrmConnectionString");   // Todo: Replace magic connection string
using (XrmVRC.XrmVrcServiceContext context = new XrmVRC.XrmVrcServiceContext(connection)) {
    // Processing...
}

answered Jul 07 '11 at 04:33

SamJackSon

1,071
14
19

Completely agree with this answer. Our website when using ServerConnection class spent 2+ seconds on creating one Contact record. With CrmConnection it takes 5ms. We're using CRM Online. – Alex Sorokoletov Sep 19 '14 at 23:58

score 1 · Answer 2 · edited Jun 20 '20 at 09:12

This is quite an old question but for anyone else still looking have a read of this SDK Extensions for Microsoft Dynamics CRM 2011 and Microsoft Dynamics CRM Online. I believe the extensions take care of the caching/pooling of resources for you.

For a solution to OP original question have a look here and here. Below is a quote from the CRM SDK documentation linked above:

Developer Extensions for Microsoft Dynamics CRM provide the following capabilities:

Simplified connection to Microsoft Dynamics CRM servers provided by the CrmConnection class (Microsoft.Xrm.Client)

Code Generation of strong types provided by customizations to the code generation tool (CrmSvcUtil.exe)

App.config and Web.config configurability for enabling custom extensions provided by the CrmConfigurationManager class (Microsoft.Xrm.Client)

Performance enhancements through caching of service results provided by the CachedOrganizationService class (Microsoft.Xrm.Client)

The Portal Developer’s Guide enables you to build a Web portal that is tightly integrated with Microsoft Dynamics CRM. For more information, see Portal Developer Guide for Microsoft Dynamics CRM 2011 and Microsoft Dynamics CRM Online. This guide proves the following capabilities:

Security Management (Microsoft.Xrm.Portal)

Cache Management (Microsoft.Xrm.Portal)

Content Management (Microsoft.Xrm.Portal, Microsoft.Xrm.Portal.Files, WebSiteCopy.exe)

score 0 · Answer 3 · answered Jun 24 '11 at 14:28

I also posted this question on MS Forum where I got following reply by Pat.

While it is somewhat limited, there is some direction regarding the caching of service connectivity in the SDK:

Performance Best Practises - Caching

The two primary suggestions being to:

    1. Cache the IServiceConfiguration class
    2. Monitor your WCF security token and refresh it before it expires

Based on that advise, I endedup using following classes from the API sample code. Please let me know if anyone has feedback or right/wrong/better advise on this.

As far management of AppPool is concerned, I still looking for info.

1. ManagedTokenOrganizationServiceProxy
2. AutoRefreshSecurityToken
3. DeviceIdManager

I added following connection string to web.config

<add name="XrmConnectionString" connectionString="ServiceUri=http://<MACHINE>:<PORTt>/<ORG>/XRMServices/2011/Organization.svc; Domain=<DOMAIN>; Username=<USERNAME>; Password=<PASSWORD>" />

Then I created following class to create connection.

/// <summary>Provides server connection information.</summary>
public class ServerConnection
{
    private static readonly ILog log = LogManager.GetLogger(typeof(ServerConnection));

    #region Public methods
    /// <summary>
    /// Obtains the OrganizationServiceProxy connection for the target organization's
    /// Uri and user login credentials from theconfiguration.
    /// </summary>
    public static OrganizationServiceProxy getServiceProxy() {
        ManagedTokenOrganizationServiceProxy serviceProxy = null;
        log.Debug("in getServiceProxy");
        try {
            CrmConnection crmConnection = new CrmConnection("XrmConnectionString");
            serviceProxy = new ManagedTokenOrganizationServiceProxy(crmConnection.ServiceUri, crmConnection.ClientCredentials);
            log.Debug("ManagedTokenOrganizationServiceProxy created = " + serviceProxy);
            serviceProxy.EnableProxyTypes();
        } catch (Exception e) {
            log.Fatal(e, e);
            throw;
        }
        log.Debug("Returning serviceProxy");
        return serviceProxy;
    }

    #endregion
}

Following MVC code consumes the connection:

public ActionResult Index() {
    XrmVrcServiceContext context = null;
    try {
        context = new XrmVrcServiceContext(ServerConnection.getServiceProxy());
    } catch (Exception e) {
        log.Error(e, e);
        throw;
    }
    return View(context.new_XYZEntitySet.ToList());
}

Connection/Object pool for OrganizationServiceProxy in XRM/Dynamics CRM 2011

3 Answers3