Getting Started With dotConnect for SQLite

using Devart.Data.SQLite;

namespace SQLiteConsoleApp
{
    class Program
    {
        static void Main(string[] args)
        {
            string databasePath = @"path\to\your\sakila.db";

            string connectionString = $"Data Source={databasePath};Encryption=AES256;FailIfMissing=false;Password=best;License Key=**********";

            using (SQLiteConnection connection = new SQLiteConnection(connectionString))
            {
                try
                {
                    connection.Open();
                    Console.WriteLine("Connection successful!");
                }
                catch (Exception ex)
                {
                    Console.WriteLine($"Connection failed: {ex.Message}");
                }
            }

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

using Devart.Data.SQLite;

namespace SQLiteConsoleApp
{
    class Program
    {
        static void Main(string[] args)
        {
            string connectionString = @"Data Source=path\to\your\sakila.db;License Key=**********";

            using (SQLiteConnection connection = new SQLiteConnection(connectionString))
            {
                try
                {
                    connection.Open();
                    Console.WriteLine("Connection successful!\n");

                    string query = "SELECT ActorId, FirstName, LastName FROM Actor LIMIT 15";

                    using (SQLiteCommand command = new SQLiteCommand(query, connection)) 
                    using (SQLiteDataReader reader = command.ExecuteReader())
                    {
                        Console.WriteLine("ActorId\tFirstName\tLastName");
                        Console.WriteLine("-------\t---------\t--------");

                        while (reader.Read())
                        {
                            Console.WriteLine($"{reader["ActorId "]}\t{reader["FirstName "]}\t\t{reader["LastName "]}");
                        }
                    }
                }
                catch (Exception ex)
                {
                    Console.WriteLine("Error: " + ex.Message);
                }
            }

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

using System;
using System.Linq;
using Devart.Data.SQLite.EFCore;
using Microsoft.EntityFrameworkCore;

namespace EfCoreDotConnectSqliteDemo
{

    public class Actor
    {
        public int ActorId { get; set; }
        public string FirstName { get; set; } = "";
        public string LastName { get; set; } = "";
        public DateTime LastUpdate { get; set; }
    }

    public class SakilaContext : DbContext
    {
        private readonly string _connectionString;

        public SakilaContext(string connectionString) => _connectionString = connectionString;

        public DbSet Actors => Set();

        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            optionsBuilder.UseSQLite(_connectionString);
        }

        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            var e = modelBuilder.Entity();
            e.ToTable("Actor");
            e.HasKey(a => a.ActorId);
            e.Property(a => a.ActorId).HasColumnName("ActorId");
            e.Property(a => a.FirstName).HasColumnName("FirstName");
            e.Property(a => a.LastName).HasColumnName("LastName");
            e.Property(a => a.LastUpdate).HasColumnName("LastUpdate");
        }
    }
    class Program
    {
        static void Main(string[] args)
        {
            var connString = @"Data Source=path\to\your\sakila.db;License Key=**********";
            using
            var db = new SakilaContext(connString);
            Console.WriteLine("Fetching first 15 actors...\n");
            var actors = db.Actors.OrderBy(a => a.ActorId).Take(15).Select(a => new {
                a.ActorId,
                a.FirstName,
                a.LastName,
            }).ToList();
            Console.WriteLine("ActorId\tFirstName\tLastName");
            Console.WriteLine("-------\t---------\t--------");
            foreach (var a in actors)
            {
                Console.WriteLine($"{a.ActorId}\t{a.FirstName, -10}\t{a.LastName}");
            }
            Console.WriteLine("\nDone. Press any key to exit...");
            Console.ReadKey();
        }
    }
}

using Devart.Data.SQLite;
using System.Data;
namespace SQLiteConsoleApp
{
    class Program
    {
        static void Main(string[] args)
        {
            string connectionString = @"Data Source=path\to\your\sakila.db;License Key=**********";
            using (SQLiteConnection connection = new SQLiteConnection(connectionString))
            {
                try
                {
                    connection.Open();
                    Console.WriteLine("Connection successful!\n");
                    string query = "SELECT ActorId, FirstName, LastName FROM Actor LIMIT 15";

                    SQLiteDataAdapter adapter = new SQLiteDataAdapter(query, connection);

                    DataTable table = new DataTable();
                    adapter.Fill(table);

                    Console.WriteLine("ActorId\tFirstName\tLastName");
                    Console.WriteLine("-------\t---------\t--------");
                    foreach (DataRow row in table.Rows)
                    {
                        Console.WriteLine($"{row["ActorId "]}\t{row["FirstName "],-10}\t{row["LastName "]}");
                    }
                }
                catch (Exception ex)
                {
                    Console.WriteLine("Error: " + ex.Message);
                }
            }
            Console.WriteLine("\nPress any key to exit...");
            Console.ReadKey();
        }
    }
}

using Devart.Data.SQLite;
namespace SQLiteConsoleApp
{
    class Program
    {
        static void Main(string[] args)
        {

            string connectionString = @"Data Source=path\to\your\sakila.db;License Key=**********";
            using (SQLiteConnection connection = new SQLiteConnection(connectionString))
            {
                connection.Open();
                Console.WriteLine("Connection successful!\n");

                SQLiteTransaction transaction = connection.BeginTransaction();
                try
                {
                    string insertSql = "INSERT INTO Actor (FirstName, LastName, LastUpdate) " + "VALUES (@FirstName, @LastName, CURRENT_TIMESTAMP)";
                    using (SQLiteCommand cmd = new SQLiteCommand(insertSql, connection))
                    {
                        cmd.Transaction = transaction;
                        cmd.Parameters.AddWithValue("@FirstName", "JANE");
                        cmd.Parameters.AddWithValue("@LastName", "SMITH");
                        int rows = cmd.ExecuteNonQuery();
                        Console.WriteLine($"{rows} row(s) inserted.");
                    }

                    transaction.Commit();
                    Console.WriteLine("Transaction committed successfully.");
                }
                catch (Exception ex)
                {
                    Console.WriteLine("Error: " + ex.Message);

                    transaction.Rollback();
                    Console.WriteLine("Transaction rolled back.");
                }
            }
            Console.WriteLine("\nPress any key to exit...");
            Console.ReadKey();
        }
    }
}

using Devart.Data.SQLite;
namespace SQLiteConsoleApp
{
    class Program
    {
        static void Main(string[] args)
        {

            string connectionString = @"Data Source=path\to\your\sakila.db;License Key=**********";
            using (SQLiteConnection connection = new SQLiteConnection(connectionString))
            {
                try
                {
                    connection.Open();
                    Console.WriteLine("Connection successful!\n");

                    string sql = "INSERT INTO Actor (FirstName, LastUpdate) VALUES (@FirstName, CURRENT_TIMESTAMP)";
                    using (SQLiteCommand cmd = new SQLiteCommand(sql, connection))
                    {
                        cmd.Parameters.AddWithValue("@FirstName", "ONLY_FIRSTNAME");
                        int rows = cmd.ExecuteNonQuery();
                        Console.WriteLine($"{rows} row(s) inserted.");
                    }
                }
                catch (SQLiteException ex) // dotConnect-specific exception
                {
                    Console.WriteLine("SQLiteException caught!");
                    Console.WriteLine($"Error Code: {ex.ErrorCode}");
                    Console.WriteLine($"Message   : {ex.Message}");
                }
                catch (Exception ex) // fallback for other runtime errors
                {
                    Console.WriteLine("General Exception caught!");
                    Console.WriteLine($"Message: {ex.Message}");
                }
            }
            Console.WriteLine("\nPress any key to exit...");
            Console.ReadKey();
        }
    }
}