Getting Started With dotConnect for QuickBooks Online

using Devart.Data.QuickBooks;

namespace QuickBooksConsoleApp
{
    class Program
    {
        static void Main(string[] args)
        {

            bool sandbox = true;
            string clientId = "YOUR_CLIENT_ID";
            string clientSecret = "YOUR_CLIENT_SECRET";

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

            try
            {
                using (QuickBooksConnection quickBooksConnection = new QuickBooksConnection(connectionString))
                {
                    quickBooksConnection.Open();
                    Console.WriteLine("Connected to QuickBooks Online successfully.");
                    quickBooksConnection.Close();
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine("An error occurred:");
                Console.WriteLine(ex.Message);
            }
        }
    }
}

using Devart.Data.QuickBooks;

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

            try
            {
                using (QuickBooksConnection quickBooksConnection = new QuickBooksConnection())
                {
                    quickBooksConnection.ConnectionString = connectionString;
                    quickBooksConnection.Open();

                    Console.WriteLine("Connected to QuickBooks Online successfully.");

                    string query = "SELECT Id, Name, FullyQualifiedName, Description FROM Account";

                    using (QuickBooksCommand command = new QuickBooksCommand(query, quickBooksConnection))
                    {
                        using (QuickBooksDataReader reader = command.ExecuteReader())
                        {
                            if (reader.HasRows)
                            {
                                Console.WriteLine("Fetching Account data:");
                                Console.WriteLine("--------------------------------------------------");

                                while (reader.Read())
                                {
                                    string id = reader["Id"]?.ToString() ?? "N/A";
                                    string name = reader["Name"]?.ToString() ?? "N/A";
                                    string fullyQualifiedName = reader["FullyQualifiedName"]?.ToString() ?? "N/A";
                                    string description = reader["Description"]?.ToString() ?? "N/A";

                                    Console.WriteLine($"Id: {id}");
                                    Console.WriteLine($"Name: {name}");
                                    Console.WriteLine($"FullyQualifiedName: {fullyQualifiedName}");
                                    Console.WriteLine($"Description: {description}");
                                    Console.WriteLine("--------------------------------------------------");
                                }
                            }
                            else
                            {
                                Console.WriteLine("No data found in the Account table.");
                            }
                        }
                    }

                    quickBooksConnection.Close();
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
            Console.ReadKey();
        }
    }
}

using Microsoft.EntityFrameworkCore;

namespace QuickBooksConsoleApp
{
    class Program
    {
        static void Main(string[] args)
        {
            using (var context = new Model())
            {
                try
                {
                    var accounts = context.Accounts
                        .Select(a => new {
                            Name = a.Name,
                            Classification = a.Classification,
                            AccountType = a.AccountType
                        })
                        .Take(10)
                        .ToList();

                    foreach (var account in accounts)
                    {
                        Console.WriteLine($"Name: {account.Name}");
                        Console.WriteLine($"Classification: {account.Classification}");
                        Console.WriteLine($"Account type: {account.AccountType}");
                        Console.WriteLine(new string('-', 20));
                    }
                }
                catch (Exception ex)
                {
                    Console.WriteLine($"An error occurred: {ex.Message}");
                }
            }
        }
    }
}

using System.Data;
using Devart.Data.QuickBooks;

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

            try
            {
                using (QuickBooksConnection connection = new QuickBooksConnection(connectionString))
                {
                    connection.Open();
                    Console.WriteLine("Connected to QuickBooks Online successfully.");

                    LoadCustomers(connection);
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine("An error occurred:");
                Console.WriteLine(ex.Message);
            }

            Console.WriteLine("Press any key to exit...");
            Console.ReadKey();
        }

        static void LoadCustomers(QuickBooksConnection connection)
        {
            Console.WriteLine("\n=== Loading Customers ===");

            try
            {
                // Create command to select customers
                string selectCommand = "SELECT Id, DisplayName, FullyQualifiedName FROM Customer";

                using (QuickBooksDataAdapter adapter = new QuickBooksDataAdapter(selectCommand, connection))
                {
                    // Create DataSet to hold the data
                    DataSet dataSet = new DataSet();

                    // Fill DataSet with customers data
                    int recordCount = adapter.Fill(dataSet, "Customers");

                    Console.WriteLine($"Loaded {recordCount} customers:");

                    // Display the data
                    foreach (DataRow row in dataSet.Tables["Customers"].Rows)
                    {
                        Console.WriteLine($"ID: {row["Id"]}, Name: {row["DisplayName"]}, Company: {row["FullyQualifiedName"]}");
                    }
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine($"Error loading customers: {ex.Message}");
            }
        }
    }
}