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








