Getting Started With dotConnect for Adobe Commerce

using Devart.Data.Magento;

namespace MagentoConsoleApp
{
    class Program
    {
        static void Main(string[] args)
        {
            string domain = "https://testdomain.com/";
            string user = "TestUser";
            string password = "TestPassword";
            string licenseKey = "***********";

            string connectionString = $"Domain={domain};Service Version=Ver2;User={user};Password={password};License Key={licenseKey}";

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

        public static void ReadCustomersData(string myConnString)
        {
            using (MagentoConnection magentoConnection = new MagentoConnection(myConnString))
            {
                try
                {
                    magentoConnection.Open();
                    Console.WriteLine("Connection successful.");
                    Console.WriteLine();
                }
                catch (Exception ex)
                {
                    Console.WriteLine("Connection failed: " + ex.Message);
                    Console.WriteLine();
                    return;
                }

                using (MagentoCommand magentoCommand = (MagentoCommand)magentoConnection.CreateCommand())
                {
                    magentoCommand.CommandText = "SELECT Id, Email FROM Customers";

                    using (MagentoDataReader magentoReader = magentoCommand.ExecuteReader())
                    {
                        try
                        {
                            int rowCount = 0;
                            while (magentoReader.Read() && rowCount < 15)
                            {
                                Console.WriteLine($"Id: {magentoReader["Id"]}");
                                Console.WriteLine($"Email: {magentoReader["Email"]}");
                                Console.WriteLine();
                                rowCount++;
                            }
                        }
                        finally
                        {
                            magentoReader.Close();
                        }
                    }
                }
            }
        }
    }
}

using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.Configuration;
using MagentoEFCore;
 
// Build configuration
var configuration = new ConfigurationBuilder()
    .AddJsonFile("appsettings.json", optional: false, reloadOnChange: true)
    .Build();
 
// Get connection string
var connectionString = configuration.GetConnectionString("magentoModelConnectionString");
 
// Configure DbContext
var optionsBuilder = new DbContextOptionsBuilder();
optionsBuilder.UseMagento(connectionString);
 
// Create DbContext instance
using (var db = new magentoModel(optionsBuilder.Options))
{
    Console.WriteLine("Customers Table:");
 
    // Print header
    Console.WriteLine("{0,-25} | {1,-15} | {2,-30}", "First Name", "Last Name", "Email");
    Console.WriteLine(new string('-', 75));
 
    // Query and display customers
    var customers = db.Customers.Take(10).ToList();
    foreach (var customer in customers)
    {
        Console.WriteLine("{0,-25} | {1,-15} | {2,-30}",
            customer.FirstName,
            customer.LastName,
            customer.Email);
    }
}

using Devart.Data.Magento;

namespace MagentoConsoleApp
{
    class Program
    {
        static void Main(string[] args)
        {
            string domain = "https://testdomain.com/";
            string user = "TestUser";
            string password = "TestPassword";
            string licenseKey = "***********";

            string connectionString = $"Domain={domain};Service Version=Ver2;User={user};Password={password};License Key={licenseKey}";

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

        public static void FetchCustomersWithDataAdapter(string myConnString)
        {
            using (MagentoConnection magentoConnection = new MagentoConnection(myConnString))
            {
                try
                {
                    magentoConnection.Open();
                    Console.WriteLine("Connection successful.");
                    Console.WriteLine();

                    MagentoDataAdapter magentoDataAdapter = new MagentoDataAdapter("SELECT Id, FirstName, LastName, Email FROM Customers", magentoConnection);

                    DataSet dataSet = new DataSet();

                    magentoDataAdapter.Fill(dataSet);

                    if (dataSet.Tables.Count > 0)
                    {
                        DataTable customersTable = dataSet.Tables[0];
                        int rowCount = 0;

                        foreach (DataRow row in customersTable.Rows)
                        {
                            if (rowCount >= 15)
                                break;

                            Console.WriteLine($"Id: {row["Id"]}");
                            Console.WriteLine($"First Name: {row["FirstName"]}");
                            Console.WriteLine($"Last Name: {row["LastName"]}");
                            Console.WriteLine($"Email: {row["Email"]}");
                            Console.WriteLine();
                            rowCount++;
                        }
                    }
                }
                catch (Exception ex)
                {
                    Console.WriteLine("Connection failed: " + ex.Message);
                }
            }
        }
    }
}