Bhubaneswar, Odisha, India
+91-8328865778
support@softchief.com

Sample code Console App for Dataverse Dynamics 365 Power Apps

Sample code Console App for Dataverse Dynamics 365 Power Apps

Console App Sample code.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Microsoft.Xrm.Sdk;
using Microsoft.Xrm.Sdk.Query;
using Microsoft.Xrm.Tooling.Connector;

namespace ConnectD365Console
{
    class Program
    {
        static void Main(string[] args)
        {
            Console.WriteLine("Console App started");

            IOrganizationService orgService;

            orgService = GetOrganizationServiceClientSecret(
                 "baf46f0e-fd8f-4b12-bb73-57da775728cc",
                 "OVG8Q~GzzcutCtTuKXVrrceQLyzNWiXHtmhtBaRh",
                 "https://softchiefdev.crm.dynamics.com/");

            /*
            Entity account = new Entity();
            account.LogicalName = "account";
            account["name"] = "Softchief Account";
            var createacc = orgService.Create(account);
             */

            //reqad all students
            QueryExpression qe = new QueryExpression();
            qe.EntityName = "soft_student";
            qe.ColumnSet = new ColumnSet("soft_name", "soft_email");
            EntityCollection ec = orgService.RetrieveMultiple(qe);

            foreach (var item in ec.Entities)
            {
                Entity entSt = new Entity();
                entSt.LogicalName = "soft_student";
                entSt.Id = item.Id;
                entSt["soft_certificateissues"] = false;
                orgService.Update(entSt);
                Console.WriteLine("Student updated! - " + item.Id);
            }



           
            Console.ReadLine();
        }
        public static IOrganizationService GetOrganizationServiceClientSecret(string clientId, string clientSecret, string organizationUri)
        {
            try
            {
                var conn = 
                    new CrmServiceClient($@"AuthType=ClientSecret;url={organizationUri};ClientId={clientId};ClientSecret={clientSecret}");

                return conn.OrganizationWebProxyClient != null ? conn.OrganizationWebProxyClient : (IOrganizationService)conn.OrganizationServiceProxy;
            }
            catch (Exception ex)
            {
                Console.WriteLine("Error while connecting to CRM " + ex.Message);
                Console.ReadKey();
                return null;
            }
        }
    }
}