Install-Package Microsoft.CrmSdk.CoreAssemblies -Version 8.2.0.2

Install-Package Newtonsoft.Json

using Microsoft.Xrm.Sdk;
using System;

namespace ILRepack.Sample
{
    public class Plugin : IPlugin
    {
        public void Execute(IServiceProvider serviceProvider)
        {
            Run(serviceProvider);
        }

        private static void Run(IServiceProvider serviceProvider)
        {
            ITracingService tracingService =
                (ITracingService)serviceProvider.GetService(typeof(ITracingService));

            Type knownType = typeof(Newtonsoft.Json.JsonSerializer);
            tracingService.Trace($"{ knownType } is known type");
        }
    }
}

Install-Package ILRepack.Lib.MSBuild.Task -Version 2.0.15.2

<Target Name="AfterBuild">
  </Target>

  <Target Name="AfterBuild">
    <ItemGroup>
      <InputAssemblies Include="$(OutputPath)\$(AssemblyName).dll" />
      <InputAssemblies Include="$(OutputPath)\Newtonsoft.Json.dll" />
    </ItemGroup>
    <ILRepack 
      Parallel="true"
      InputAssemblies="@(InputAssemblies)"
      KeyFile="$(AssemblyOriginatorKeyFile)" 
      OutputFile="$(OutputPath)\$(AssemblyName).dll"
   />
  </Target>

1>------ Rebuild All started: Project: ILRepack.Sample, Configuration: Debug Any CPU ------
1>  ILRepack.Sample -> \ILRepack.Sample\bin\Debug\ILRepack.Sample.dll
1>  Added assembly 'bin\Debug\\ILRepack.Sample.dll'
1>  Added assembly 'bin\Debug\\Newtonsoft.Json.dll'
1>  Merging 2 assembies to 'bin\Debug\\ILRepack.Sample.dll'
1>  Merge succeeded in 1,1207542 s
========== Rebuild All: 1 succeeded, 0 failed, 0 skipped ==========

/targetplatform:v4,C:\Windows\Microsoft.NET\Framework\v4.0.30319

  <Import Project="..\packages\ILRepack.Lib.MSBuild.Task.2.0.15.2\build\ILRepack.Lib.MSBuild.Task.targets" Condition="Exists('..\packages\ILRepack.Lib.MSBuild.Task.2.0.15.2\build\ILRepack.Lib.MSBuild.Task.targets')" />

npm run test

npm run eject

node -v

npm -v

npm install -g create-react-app

create-react-app crmreactapp --scripts-version=react-scripts-ts

cd crmreactapp

npm start

npm run build

Install-Package spkl

"webresources": [
    {
      /* 
      Option - profile - Provide a comma delimitered list of profile names that can be referenced when calling spkl
      */
      "profile": "default,debug",

      /*
      Optional - root - Provide the relatative path of the webresources.
      */
      "root": "build/",

      /*
      Optional - solution - Add webresources to a solution when deploying
      */
      "solution": "reactapp",

      /*
      Required - files - List the webresources to deploy relatative to the root of this file (or the the root parameter above)
      */
      "files": [
        {
          "uniquename": "new_/index.html",
          "file": "index.html",
          "description": ""
        },
        {
          "uniquename": "new_/static/css/main.c17080f1.css",
          "file": "static\\css\\main.c17080f1.css",
          "description": ""
        },
        {
          "uniquename": "new_/static/js/main.b047ec63.js",
          "file": "static\\js\\main.b047ec63.js",
          "description": ""
        },
        {
          "uniquename": "new_/static/media/logo.5d5d9eef.svg",
          "file": "static\\media\\logo.5d5d9eef.svg",
          "description": ""
        }
      ]
    }
  ]

deploy-webresources

exec sp_executesql N'select distinct AsyncOperationId, WaitOnAttributeList from WorkflowWaitSubscriptionBase where EntityId = @entityId and EntityName = @entityName'

exec sp_executesql N'update WorkflowWaitSubscriptionBase
set IsModified = 1, ModifiedOn = @modifiedOn
where EntityId = @entityId
and EntityName = @entityName'

exec sp_executesql N'update AsyncOperationBase 
    set
        StateCode = @readyState,
        StatusCode = @readyStatus,
        ModifiedOn = @modifiedOn,
        ModifiedBy = @modifiedBy
    where
        StateCode = @suspendedState
    and AsyncOperationId in ( <AsyncOperationId> )'

exec sp_executesql N'select WorkflowState
from AsyncOperationBase
where
    AsyncOperationId = @id'

exec sp_executesql N'delete WorkflowWaitSubscriptionBase from WorkflowWaitSubscriptionBase with(index(ndx_CascadeRelationship_Asyncoperation_workflowwaitsubscription)) where AsyncOperationId=@workflowId'

exec sp_executesql N'select WaitOnAttributeList from WorkflowWaitSubscriptionBase where 
                            EntityName = @entityName and
                            EntityId = @entityId and 
                            AsyncOperationId = @asyncOperationId'

exec sp_executesql N'if (select count(*) from WorkflowWaitSubscriptionBase where 
                            EntityName = @entityName and
                            EntityId = @entityId and
                            AsyncOperationId = @asyncOperationId) = 0
                        begin
                            insert into WorkflowWaitSubscriptionBase (WorkflowWaitSubscriptionId, AsyncOperationId, EntityName, EntityId, IsModified, ModifiedOn, Data, WaitOnAttributeList)
                            values (@workflowWaitSubscriptionId, @asyncOperationId, @entityName, @entityId, @isModified, @modifiedOn, @data, @waitOnAttributeList)
                        end'

exec sp_executesql N'select WaitOnAttributeList from WorkflowWaitSubscriptionBase where 
                            EntityName = @entityName and
                            EntityId = @entityId and 
                            AsyncOperationId = @asyncOperationId'

exec sp_executesql N'update WorkflowWaitSubscriptionBase
                        set WaitOnAttributeList = @waitOnAttributeList
                        where EntityId = @entityId and 
                        EntityName = @entityName and 
                        AsyncOperationId = @asyncOperationId'

exec sp_executesql N'update AsyncOperationBase 
set 
StateCode = @newState
, StatusCode = @newStatus
, ErrorCode = @errorCode
, Message = @errorMessage
, FriendlyMessage = NULL
, PostponeUntil = @postponeUntil
, ExecutionTimeSpan =  @executionTimeSpan
, ModifiedOn = @modifiedOn
, ModifiedBy = CreatedBy
 where AsyncOperationId = @id

exec sp_executesql N'update AsyncOperationBase
set
    PostponeUntil = @postponeUntil,    
    WorkflowState = @workflowState,
    WorkflowIsBlocked = @workflowIsBlocked,
    ModifiedOn = @modifiedOn,
    ModifiedBy = CreatedBy
where
    AsyncOperationId = @id'

                using (OrganizationServiceContext context = new OrganizationServiceContext(proxy))
                {
                    var account = context.CreateQuery<Account>()
                        .Where(a => a.Name != null)
                        .Select(a => new Account() { Id = a.Id }).FirstOrDefault();
 
                    Console.Out.WriteLine("Id = a.Id {0}", account.Attributes.Count);
                }

                using (OrganizationServiceContext context = new OrganizationServiceContext(proxy))
                {
                    var account = context.CreateQuery<Account>()
                        .Where(a => a.Name != null)
                        .Select(a => new Account() { AccountId = AccountId }).FirstOrDefault();
 
                    Console.Out.WriteLine("Id = a.AccountId.Value {0}", account.Attributes.Count);
                }

[Microsoft.Xrm.Sdk.AttributeLogicalNameAttribute("accountid")]
public System.Nullable<System.Guid> AccountId

[Microsoft.Xrm.Sdk.AttributeLogicalNameAttribute("accountid")]
public override System.Guid Id

AccountId = a.Id 57
Id = a.Id 57
Id = a.AccountId.Value 1
AccountId = a.AccountId 1

$rs2010.DeleteSubscription("SubscriptionID");

http://<Server Name>/_vti_bin/ReportServer

    Public Function GetHostUrl(ByRef uri As String) As String
        If String.IsNullOrEmpty(uri) Then
            Return String.Empty
        Else
            Return New Uri(uri).GetLeftPart(UriPartial.Authority)
        End If
    End Function

=IIF(String.IsNullOrEmpty(Globals!ReportServerUrl), "http://test server uri", Code.GetHostUrl(Globals!ReportServerUrl))

https://server.domain/oranization

https://oranization.server.domain

CRM.FIXRM.COM:443

CRM.FIXRM.COM:444

        var req = new XMLHttpRequest();
        
        req.open("POST", this._SoapPath(), true)
        // Затычка для IE10+
        if (typeof (document.evaluate) == "undefined")
        {
            try { req.responseType = "msxml-document"; } catch (e) {}
        }

    function selectSingleNode(xmlDoc, elementPath, node)
    {
        if (xmlDoc.evaluate)
        {
            function nsResolver(prefix)
            {
                var ns = {
                    "s": "http://schemas.xmlsoap.org/soap/envelope/",
                    "i": "http://www.w3.org/2001/XMLSchema-instance",
                    "a": "http://schemas.microsoft.com/xrm/2011/Contracts",
                    "b": "http://schemas.microsoft.com/xrm/2011/Contracts",
                    "c": "http://schemas.datacontract.org/2004/07/System.Collections.Generic",
                    "d": "http://www.w3.org/2001/XMLSchema"
                };
                return ns[prefix] || null;
            }

            var nodes = xmlDoc.evaluate(elementPath, node || xmlDoc, nsResolver, XPathResult.ANY_TYPE, null);
            var results = nodes.iterateNext();

            return results;
        }
        else
        {
            try
            {
                var ns = "xmlns:s='http://schemas.xmlsoap.org/soap/envelope/' ";
                ns += "xmlns:i='http://www.w3.org/2001/XMLSchema-instance' ";
                ns += "xmlns:a='http://schemas.microsoft.com/xrm/2011/Contracts' ";
                ns += "xmlns:b='http://schemas.microsoft.com/xrm/2011/Contracts' ";
                ns += "xmlns:c='http://schemas.datacontract.org/2004/07/System.Collections.Generic' ";
                ns += "xmlns:d='http://www.w3.org/2001/XMLSchema' ";

                xmlDoc.setProperty("SelectionNamespaces", ns);
                return (node || xmlDoc).selectSingleNode(elementPath);

            }
            catch (e)
            {
                throw new Error("No XPath Support");
            }
        }

    }

_dateReviver: function (key, value)
    {
        ///<summary>
        /// Private function to convert matching string values to Date objects.
        ///</summary>
        ///<param name="key" type="String">
        /// The key used to identify the object property
        ///</param>
        ///<param name="value" type="String">
        /// The string value representing a date
        ///</param>
        var a;
        if (typeof value === 'string')
        {
            a = /Date\(([-+]?\d+)\)/.exec(value);
            if (a)
            {
                return new Date(parseInt(value.replace("/Date(", "").replace(")/", ""), 10));
            }
        }
        return value;
    }

_xrmTypeReviver: function (key, value)
    {
        ///<summary>
        /// Private function to convert matching string values to Date objects.
        /// agrunin: функция дополнена для преобразования EntityReference в lookup понятный Xrm.Page
        ///</summary>
        ///<param name="key" type="String">
        /// The key used to identify the object property
        ///</param>
        ///<param name="value" type="String">
        /// The string value representing a date or EntityReference
        ///</param>
        var a;
        if (typeof value === 'string')
        {
            a = /Date\(([-+]?\d+)\)/.exec(value);
            if (a)
            {
                return new Date(parseInt(value.replace("/Date(", "").replace(")/", ""), 10));
            }
        }
        else if (value != null && typeof value == 'object')
        {
            if (value["__metadata"] != undefined)
            {
                var type = value["__metadata"].type;
                switch (type)
                {
                    case "Microsoft.Crm.Sdk.Data.Services.EntityReference":
                        if (value.Id == null)
                        {
                            // Возвращаем null вместо пустого объекта
                            return null;
                        }
                        else
                        {
                            return { id: value.Id, entityType: value.LogicalName, name: value.Name };
                        }
                    case "Microsoft.Crm.Sdk.Data.Services.Money":
                    case "Microsoft.Crm.Sdk.Data.Services.OptionSetValue":
                        return value.Value;
                    default:
                        return value;
                }
            }
        }
        return value;
    }

              String crmconnection = "Server=http://crm/FixRM";
              CrmConnection connection = CrmConnection.Parse(crmconnection);
              OrganizationService service = new OrganizationService(connection);
  
              WhoAmIRequest userRequest = new WhoAmIRequest();
              WhoAmIResponse userResponse = (WhoAmIResponse) service.Execute(userRequest);
  
              // Create the ActivityParty instance.
              ActivityParty me = new ActivityParty
              {
                  PartyId = new EntityReference(SystemUser.EntityLogicalName, userResponse.UserId)
              };
  
              ActivityParty customparty= new ActivityParty
              {
                  //
                  PartyId = new EntityReference("fixrm_customparty", new Guid("6793AD07-E70E-E311-8E30-080027004A52"))
              };
  
              // Create the appointment instance.
              Appointment appointment = new Appointment
              {
                  Subject = "Test Appointment",
                  Description = "Test Appointment created using the BookRequest Message.",
                  ScheduledStart = DateTime.Now.AddHours(1),
                  ScheduledEnd = DateTime.Now.AddHours(2),
                  Location = "Office",
                  RequiredAttendees = new ActivityParty[] { me, customparty},
                  Organizer = new ActivityParty[] { me }
              };
  
              // Use the Book request message.
              Guid id = service.Create(appointment);

if (typeof (FixRM) == "undefined")
  { FixRM = { __namespace: true }; }
  
  /*
  Events
  FixRM.CustomActivityParty.AddPartyTypeOnLoad
  */
  
  FixRM.CustomActivityParty = {
      AddPartyTypeOnLoad: function (settings)
      {
          for (var setting in settings)
          {
              var parties = settings[setting];
  
              for (var i = 0; i < parties.length; i++)
              {
                  var party = parties[i];
  
                  this.AddPartyType(setting, party.otc, party.schema, party.schemaName);
  
                  if (party.isDefault == true)
                  {
                      this.SetDefaultParty(setting, party.otc, party.DefaultViewId);
                  }
              }
          }
      },
  
      AddPartyType: function (name, otc, schema, schemaName)
      {
          function ApendAttributeValue(node, name, separator, value)
          {
              var attribute = node.getAttribute(name);
              var attributeValues = attribute.split(separator);
              attributeValues.push(value);
  
              attribute = attributeValues.join(separator);
              node.setAttribute(name, attribute);
          }
  
          var lookup = document.getElementById(name);
          if (lookup && lookup.attributes)
          {
              ApendAttributeValue(lookup, "lookuptypes", ",", otc);
  
              var icoPath = Xrm.Page.context.prependOrgName("/_Common/icon.aspx?cache=1&iconType=GridIcon&objectTypeCode=" + otc);
              ApendAttributeValue(lookup, "lookuptypeIcons", ":", icoPath);
  
              if (schema && schemaName)
              {
                  var lookuptypename = schema + ":" + otc + ":" + schemaName;
                  ApendAttributeValue(lookup, "lookuptypenames", ",", lookuptypename);
              }
          }
      },
  
      SetDefaultParty: function (name, otc, view)
      {
          var lookup = document.getElementById(name);
          if (lookup && lookup.attributes)
          {
              lookup.setAttribute("defaulttype", otc);
              if (view)
              {
                  lookup.setAttribute("defaultViewId", view);
              }
          }
      },
  
      __namespace: true
  };

{
   1: [     ],
   2: [     ]
}

{
  otc: <  >,
  schema: <  >,
  schemaName: <  (        REST)>,
  isDefault: <          .  >,
  DefaultViewId: <      .  ,       >
}

ALTER DATABASE Org_MSCRM SET trustworthy ON
  
USE Org_MSCRM
EXEC sp_changedbowner 'DOMAIN\login'

SELECT
    [plugintypeidname],
    [averageexecutetimeinmilliseconds],
    [executecount],
    [failurecount],
    [failurepercent]
FROM FilteredPluginTypeStatistic

                    string estimatedvalue_avg = @" 
                    <fetch distinct='false' mapping='logical' aggregate='true'> 
                        <entity name='opportunity'> 
                           <attribute name='estimatedvalue' alias='estimatedvalue_avg' aggregate='avg' /> 
                        </entity> 
                    </fetch>";

                    EntityCollection estimatedvalue_avg_result = _serviceProxy.RetrieveMultiple(new FetchExpression(estimatedvalue_avg));

                    foreach (var c in estimatedvalue_avg_result.Entities)
                    {
                        decimal aggregate1 = ((Money)((AliasedValue)c["estimatedvalue_avg"]).Value).Value;
                        System.Console.WriteLine("Average estimated value: " + aggregate1);

                    }