Getting Started With dotConnect for SugarCRM

using Devart.Data.Sugar;

namespace SugarConsoleApp
{
    class Program
    {
        static void Main(string[] args)
        {
            string host = "https://test.sugaropencloud.com";
            string userId = "test";
            string password = "test";
            string licenseKey = "**********";

            string connectionString = $"Host={host};User Id={userId};Password={password};License Key={licenseKey}";

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

        public static void ReadContactsData(string myConnString)
        {
            using (SugarConnection sugarConnection = new SugarConnection(myConnString))
            {
                try
                {
                    sugarConnection.Open();
                    Console.WriteLine("Connection successful.");
                    Console.WriteLine(); // Break line
                }
                catch (Exception ex)
                {
                    Console.WriteLine("Connection failed: " + ex.Message);
                    Console.WriteLine(); // Break line
                    return;
                }

                using (SugarCommand sugarCommand = (SugarCommand)sugarConnection.CreateCommand())
                {
                    sugarCommand.CommandText = "SELECT Id, Name FROM Contacts";

                    using (SugarDataReader sugarReader = sugarCommand.ExecuteReader())
                    {
                        try
                        {
                            // Always call Read before accessing data.
                            int rowCount = 0;
                            while (sugarReader.Read() && rowCount < 15)
                            {
                                Console.WriteLine($"Id: {sugarReader["Id"]}");
                                Console.WriteLine($"Name: {sugarReader["Name"]}");
                                Console.WriteLine(); // Break line
                                rowCount++;
                            }
                        }
                        finally
                        {
                            // Always call Close when done reading.
                            sugarReader.Close();
                        }
                    }
                }
            }
        }
    }
}

using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.Configuration;
using SugarEFCore;

// Build configuration
var configuration = new ConfigurationBuilder()
    .AddJsonFile("appsettings.json", optional: false, reloadOnChange: true)
    .Build();

// Get connection string
var connectionString = configuration.GetConnectionString("sugarModelConnectionString");

// Configure DbContext
var optionsBuilder = new DbContextOptionsBuilder();
optionsBuilder.UseSugar(connectionString);

// Create DbContext instance
using (var db = new sugarModel(optionsBuilder.Options))
{
    Console.WriteLine("Contacts Table:");

    // Print header
    Console.WriteLine("{0,-25} | {1,-15} | {2,-20} | {3,-30}", "Name", "Work Phone", "City", "Email");
    Console.WriteLine(new string('-', 90));

    // Query and display contacts
    var contacts = db.Contacts.Take(10).ToList();
    foreach (var contact in contacts)
    {
        var fullName = $"{contact.FirstName} {contact.LastName}";
        Console.WriteLine("{0,-25} | {1,-15} | {2,-20} | {3,-30}", 
            fullName, 
            contact.PhoneWork, 
            contact.PrimaryAddressCity, 
            contact.Email1);
    }
}

using System.Data;
using Devart.Data.Sugar;

namespace SugarConsoleApp
{
    class Program
    {
        static void Main(string[] args)
        {
            string host = "https://test.sugaropencloud.com";
            string userId = "test";
            string password = "test";
            string licenseKey = "**********";

            string connectionString = $"Host={host};User Id={userId};Password={password};License Key={licenseKey}";

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

        public static void FetchContactsWithDataAdapter(string myConnString)
        {
            using (SugarConnection sugarConnection = new SugarConnection(myConnString))
            {
                try
                {
                    sugarConnection.Open();
                    Console.WriteLine("Connection successful.");
                    Console.WriteLine();

                    // Create a SugarDataAdapter instance
                    SugarDataAdapter sugarDataAdapter = new SugarDataAdapter("SELECT Id, Name FROM Contacts", sugarConnection);

                    // Create a DataSet to hold the results
                    DataSet dataSet = new DataSet();

                    // Fill the DataSet with data from the adapter
                    sugarDataAdapter.Fill(dataSet);

                    // Access the data from the DataSet
                    if (dataSet.Tables.Count > 0)
                    {
                        DataTable contactsTable = dataSet.Tables[0];
                        int rowCount = 0;

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

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