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; } } } }