Getting Started With dotConnect for BigCommerce

using System.Data;
using Devart.Data.Bigcommerce;

namespace BigcommerceConsoleApp
{
    class Program
    {
        static void Main(string[] args)
        {
            string connectionString = $"API Version=v3;Authentication Type=OAuth;Store Id=*****;Client Id=*****;Access Token=*****;License Key=*****";

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

                    string sql = "SELECT Id, Name, Sku, Price, Availability FROM Products";

                    using (BigcommerceCommand command = new BigcommerceCommand(sql, connection))
                    using (BigcommerceDataAdapter adapter = new BigcommerceDataAdapter(command))
                    {
                        DataTable productsTable = new DataTable();
                        adapter.Fill(productsTable);

                        foreach (DataRow row in productsTable.Rows)
                        {
                            int id = row.Field("Id");
                            string name = row.Field("Name") ?? string.Empty;
                            string sku = row.Field("Sku") ?? string.Empty;
                            decimal price = row.Field("Price") ?? 0m;
                            string availability = row.Field("Availability") ?? string.Empty;

                            Console.WriteLine($"ID: {id} | Name: {name} | SKU: {sku} | Price: {price:C} | Availability: {availability}");
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine("An error occurred: " + ex.Message);
            }
        }
    }
}

using System.Linq;

namespace BigcommerceEFCore
{
    class Program
    {
        static void DisplayProducts()
        {
            using (var context = new BigcommerceModel())
            {
                var products = context.Products
                    .Select(p => new { p.Id, p.Name, p.Sku, p.Price, p.Availability })
                    .ToList();
                    
                foreach (var product in products)
                {
                    Console.WriteLine($"ID: {product.Id}");
                    Console.WriteLine($"Name: {product.Name}");
                    Console.WriteLine($"SKU: {product.Sku}");
                    Console.WriteLine($"Price: {product.Price:C}");
                    Console.WriteLine($"Availability: {product.Availability}");
                    Console.WriteLine(new string('-', 20));
                }
            }
        }
        
        static void Main(string[] args)
        {
            try
            {
                DisplayProducts();
            }
            catch (Exception ex)
            {
                Console.WriteLine("An error occurred: " + ex.Message);
            }
        }
    }
}

using System.Data;
using Devart.Data.Bigcommerce;

namespace BigcommerceConsoleApp
{
    class Program
    {
        static void Main(string[] args)
        {
            string connectionString = $"API Version=v3;Authentication Type=OAuth;Store Id=*****;Client Id=*****;Access Token=*****;License Key=*****";

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

                    // Insert a new Product using a parameterized BigcommerceCommand
                    Console.WriteLine("\nInserting a sample Product via BigcommerceCommand...");
                    string insertSql = @"INSERT INTO Products
                        (Name, Type, Sku, Price, Weight, Categories, Availability)
                        VALUES (@Name, @Type, @Sku, @Price, @Weight, @Categories, @Availability)";

                    using (BigcommerceCommand insertCmd = new BigcommerceCommand(insertSql, connection))
                    {
                        // Devart Bigcommerce provider matches parameter names without the '@' prefix.
                        insertCmd.Parameters.AddWithValue("Name", "Sample Product via Command");
                        insertCmd.Parameters.AddWithValue("Type", "physical");
                        insertCmd.Parameters.AddWithValue("Sku", "SAMPLE-SKU-001");
                        insertCmd.Parameters.AddWithValue("Price", 29.99m);
                        insertCmd.Parameters.AddWithValue("Weight", 1.5m);
                        insertCmd.Parameters.AddWithValue("Categories", "[2095]");
                        insertCmd.Parameters.AddWithValue("Availability", "available");

                        int affected = insertCmd.ExecuteNonQuery();
                        Console.WriteLine($"Insert complete. Rows affected: {affected}\n");
                    }
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine("An error occurred: " + ex.Message);
            }
        }
    }
}

using System.Data;
using Devart.Data.Bigcommerce;

namespace BigcommerceConsoleApp
{
    class Program
    {
        static void Main(string[] args)
        {
            string connectionString = $"API Version=v3;Authentication Type=OAuth;Store Id=*****;Client Id=*****;Access Token=*****;License Key=*****";

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

                    // Example: UPDATE with parameters
                    BigcommerceCommand cmd = connection.CreateCommand();
                    cmd.CommandText = "UPDATE Products SET Categories = :categories WHERE Name = :name";
                    cmd.Parameters.Add("categories", DbType.String).Value = "[2095]";
                    cmd.Parameters.Add("name", DbType.String).Value = "Sample Product via Command";

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

using System.Data;
using Devart.Data.Bigcommerce;

namespace BigcommerceConsoleApp
{
    class Program
    {
        static void Main(string[] args)
        {
            string connectionString = $"API Version=v3;Authentication Type=OAuth;Store Id=*****;Client Id=*****;Access Token=*****;License Key=*****";

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

        static void ExecuteUpdate(string connectionString)
        {
            using (var myConnection = new BigcommerceConnection(connectionString))
            using (var myCommand = new BigcommerceCommand(
                "UPDATE Products SET Categories = '[2095]' WHERE Name = 'Sample Product via Command'", myConnection))
            {
                try
                {
                    myConnection.Open();
                    Console.WriteLine("Connection opened. Executing update...");
                    int rowsAffected = myCommand.ExecuteNonQuery();
                    Console.WriteLine("Operation complete. Rows Affected: " + rowsAffected);
                }
                catch (Exception ex)
                {
                    Console.WriteLine("Error during execution: " + ex.Message);
                    Console.WriteLine(ex.ToString());
                }
                finally
                {
                    if (myConnection.State != ConnectionState.Closed)
                        myConnection.Close();
                }
            }
        }
    }
}