public void Example()
{
var credential = new D365Credential("instanceName", "crm4", "username", "password");
var engine = new SqlEngine(credential);
var sql = @"
select top 5 c.firstname, lastname 'Last Name', emailaddress1 Email
from contact as c
where emailaddress1 is not null and firstname = 'abc' and emailaddress1 like'*****@*****.**'
order by c.firstname asc, lastname desc";
var dsResults = engine.Execute(sql);
Assert.IsNotNull(dsResults);
}
public static OrganizationService Create(D365Credential credential)
{
var uri = new Uri($"https://{credential.InstanceName}.api.{credential.InstanceRegion}.dynamics.com/XRMServices/2011/Organization.svc");
var credentials = new ClientCredentials()
{
UserName =
{
UserName = credential.Username,
Password = credential.Password,
}
};
var instance = new OrganizationService(uri, credentials);
return(instance);
}