You can create window form application c#. Create connection with crm and get service then update records.
Use below code for connection
private Uri homeRealUri = null;
IOrganizationService service = null;
private OrganizationServiceProxy serviceOrganizationProxy = null;
private ClientCredentials credentials;
private Uri organizationUri;
public IOrganizationService getService()
{
credentials = new ClientCredentials();
credentials.Windows.ClientCredential = CredentialCache.DefaultNetworkCredentials;
credentials.UserName.UserName = "";
credentials.UserName.Password = "";
string orgUrl = "";
if(!String.IsNullOrEmpty(orgUrl) && orgUrl.Contains("https"))
{
ServicePointManager.ServerCertificateValidationCallback = delegate (object s, X509Certificate Certificate, X509Chain Chain,
SslPolicyErrors PolicyErrors)
{
return true;
};
System.Net.ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12;
}
organizationUri = new Uri(orgUrl);
using (
serviceOrganizationProxy = new OrganizationServiceProxy(organizationUri, homeRealUri, credentials, null))
{
// serviceOrganizationProxy.EnableProxyTypes();
serviceOrganizationProxy.ServiceConfiguration.CurrentServiceEndpoint.Behaviors.Add(new ProxyTypesBehavior());
service = serviceOrganizationProxy;
}
return service;
}
Hope it helps,
Thanks