Getting Started With dotConnect for Zoho CRM

using Devart.Data.Zoho;

namespace ZohoCrmConsoleApp
{
    class Program
    {
        static void Main(string[] args)
        {
            string domain = "YOUR_DOMAIN";
            string clientId = "YOUR_CLIENT_ID";
            string clientSecret = "YOUR_CLIENT_SECRET";

            string connectionString = "Authentication Type=OAuthInteractive;" +
                                      $"Domain={domain};" +
                                      $"Client Id={clientId};" +
                                      $"Client Secret={clientSecret};" +
                                      "License key=**********";

            try
            {
                using (ZohoConnection connection = new ZohoConnection(connectionString))
                {
                    connection.Open();
                    Console.WriteLine("Connection successful.");
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine("An error occurred: " + ex.Message);
            }
        }
    }
}

using System;

using System.Data;
using Devart.Data.Zoho;

namespace ZohoCrmConsoleApp
{
    class Program
    {
        static void Main(string[] args)
        {
            string connectionString = "Authentication Type=OAuthInteractive;License key=**********";

            try
            {
                using (ZohoConnection connection = new ZohoConnection(connectionString))
                {
                    connection.Open();
                    Console.WriteLine("Connection successful.");

                    string sql = "SELECT \"Account Name\", Phone, Website, \"Account Type\" FROM Accounts";

                    using (ZohoCommand command = new ZohoCommand(sql, connection))
                    using (ZohoDataAdapter adapter = new ZohoDataAdapter(command))
                    {
                        DataTable accountsTable = new DataTable();
                        adapter.Fill(accountsTable);

                            foreach (DataRow row in accountsTable.Rows)
                        {
                                string accountName = row.Field("Account_Name") ?? string.Empty;
                                string phone = row.Field("Phone") ?? string.Empty;
                                string website = row.Field("Website") ?? string.Empty;
                                string accountType = row.Field("Account_Type") ?? string.Empty;

                            Console.WriteLine($"Name: {accountName} | Phone: {phone} | Website: {website} | Type: {accountType}");
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine("An error occurred: " + ex.Message);
            }
        }
    }
}

using System;
using System.Linq;

namespace ZohoEFCore
{
    class Program
    {
        static void DisplayAccounts()
        {
            using (var context = new ZohoModel())
            {
                var accounts = context.Accounts
                    .Select(a => new { a.AccountName, a.Phone, a.Website, a.AccountType })
                    .ToList();

                foreach (var account in accounts)
                {
                    Console.WriteLine($"Account Name: {account.AccountName}");
                    Console.WriteLine($"Phone: {account.Phone}");
                    Console.WriteLine($"Website: {account.Website}");
                    Console.WriteLine($"Account Type: {account.AccountType}");
                    Console.WriteLine(new string('-', 20));
                }
            }
        }
    }
}

using System;
using Devart.Data.Zoho;

namespace ZohoCrmConsoleApp
{
    class Program
    {
        static void Main(string[] args)
        {
            string connectionString = "Authentication Type=OAuthInteractive;License key=**********";

            try
            {
                using (ZohoConnection connection = new ZohoConnection(connectionString))
                {
                    connection.Open();
                    Console.WriteLine("Connection successful.");

                    // Example: insert a new Account using ZohoLoader
                    Console.WriteLine("\nInserting a sample Account via ZohoLoader...");
                    using (ZohoLoader loader = new ZohoLoader())
                    {
                        loader.Connection = connection;
                        loader.TableName = "Accounts";
                        loader.Open();

                        loader.SetValue("Account Name", "Example Account via Loader");
                        loader.SetValue("Phone", "123-456-7890");
                        loader.SetValue("Website", "https://example.com");
                        loader.SetValue("Account Type", "Customer");

                        loader.NextRow();
                        loader.Close();
                    }
                    Console.WriteLine("Insert complete.\n");
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine("An error occurred: " + ex.Message);
            }
        }
    }
}

using System;
using System.Data;
using Devart.Data.Zoho;

namespace ZohoCrmConsoleApp
{
    class Program
    {
        static void Main(string[] args)
        {
            string connectionString = "Authentication Type=OAuthInteractive;License key=**********";

            try
            {
                using (ZohoConnection connection = new ZohoConnection(connectionString))
                {
                    connection.Open();
                    Console.WriteLine("Connection successful.");

                    // Example: UPDATE with parameters
                    ZohoCommand cmd = connection.CreateCommand();
                    cmd.CommandText = "UPDATE Accounts SET Website = :website WHERE \"Account Name\" = :name";
                    cmd.Parameters.Add("website", DbType.String).Value = "www.devart.com";
                    cmd.Parameters.Add("name", DbType.String).Value = "sample name 1";

                    int affected = cmd.ExecuteNonQuery();
                    Console.WriteLine($"Updated {affected} row(s).");
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine("An error occurred: " + ex.Message);
            }
        }
    }
}

using System;
using System.Data;
using Devart.Data.Zoho;

namespace ZohoCrmConsoleApp
{
    class Program
    {
        static void Main(string[] args)
        {
            string connectionString = "Authentication Type=OAuthInteractive;License key=*********";

            try
            {
                PerformAsync(connectionString);
            }
            catch (Exception ex)
            {
                Console.WriteLine("An error occurred: " + ex.Message);
            }
        }

        static void PerformAsync(string connectionString)
        {
            ZohoConnection myConnection = new ZohoConnection(connectionString);
            ZohoCommand myCommand = new ZohoCommand(
                "UPDATE Accounts SET Website = 'www.devart.com' WHERE \"Account Name\" = 'sample name 1'");

            myCommand.Connection = myConnection;
            myConnection.Open();
            int rowsAffected;
            try
            {
                IAsyncResult myResult = myCommand.BeginExecuteNonQuery(null, null);
                Console.Write("In progress...");
                while (!myResult.IsCompleted)
                {
                    Console.Write(".");
                    // Perform here any operation you need
                }
                rowsAffected = myCommand.EndExecuteNonQuery(myResult);
                Console.WriteLine();
                Console.WriteLine("Operation complete. Rows Affected: " + rowsAffected);
            }
            catch
            {
                Console.WriteLine("Error during execution.");
            }
            finally
            {
                myConnection.Close();
            }
        }
    }
}