How to Connect to Oracle With Dapper Using C#

public class Employee{
    public int Id{
        get;
        set;
    }
    public string Name{
        get;
        set;
    }
    public int DepartmentId{
        get;
        set;
    }
}

using(var connection=new OracleConnection(connectionString)){
    connection.Open();
    string sql="SELECT * FROM EMPLOYEE";
    var employees=connection.Query<Employee>(sql).ToList();

    foreach(var employee in employees){
        Console.WriteLine($"{employee.Id}: {employee.Name} (Department ID: {employee.DepartmentId})");
    }
}

using Dapper;
using Devart.Data.Oracle;

namespace DapperOracleExample
{
    class Program
    {

        static async Task Main(string[] args)
        {
            try
            {
                // Sample data to insert with new names and positions 
                var employees = new[]{
                    new{
                        NAME = "Karen White", POSITION = "Project Manager"
                    },
                    new{
                        NAME = "Liam Green", POSITION = "Software Engineer"
                    },
                    new{
                        NAME = "Mia Black", POSITION = "UX Designer"
                    },
                    new{
                        NAME = "Noah Blue", POSITION = "Data Scientist"
                    },
                    new{
                        NAME = "Olivia Red", POSITION = "QA Engineer"
                    },
                    new{
                        NAME = "Peter Yellow", POSITION = "Technical Support"
                    },
                    new{
                        NAME = "Quinn Pink", POSITION = "Recruiter"
                    },
                    new{
                        NAME = "Rachel Purple", POSITION = "Marketing Specialist"
                    },
                    new{
                        NAME = "Samuel Orange", POSITION = "Sales Representative"
                    },
                    new{
                        NAME = "Tina Grey", POSITION = "Business Analyst"
                    }
                };

                using(var connection = new OracleConnection(DatabaseConnection.ConnectionString))
                {
                    connection.Open();

                    // Define the SQL insert statement without the ID column 
                    string insertSql = "INSERT INTO EMPLOYEE (NAME, POSITION) VALUES (:NAME, :POSITION)";

                    // Execute the insert operation for each employee 
                    foreach(var employee in employees)
                    {
                        connection.Execute(insertSql, employee);
                    }

                    Console.WriteLine("Data inserted successfully.");

                    // Define the SQL select statement to retrieve all rows 
                    string selectSql = "SELECT * FROM EMPLOYEE";

                    // Execute the select query and map the results to a list of dynamic objects 
                    var allEmployees = connection.Query(selectSql).ToList();

                    // Display the retrieved data 
                    Console.WriteLine("\nAll rows in the EMPLOYEE table:");

                    foreach(var employee in allEmployees)
                    {
                        Console.WriteLine($"ID: {employee.ID}, Name: {employee.NAME}, Position: {employee.POSITION}");
                    }
                }
            }
            catch(Exception ex)
            {
                Console.WriteLine($"An error occurred: {ex.Message}");
            }
        }
    }
}

using Dapper;
using Devart.Data.Oracle;

namespace DapperOracleExample
{
    class Program
    {

        static async Task Main(string[] args)
        {
            try
            {
                using (var connection = new OracleConnection(DatabaseConnection.ConnectionString))
                {
                    await connection.OpenAsync();

                    string deleteSql = "DELETE FROM employees WHERE employee_id = :Id";
                    connection.Execute(deleteSql, new { Id = 63 });
                    Console.WriteLine("Employee deleted successfully.\n");

                    Console.WriteLine("Fetching all employees:\n");

                    var query = "SELECT employee_id AS Employee_Id, first_name AS First_Name, last_name AS Last_Name, email AS Email, hire_date AS Hire_Date, salary AS Salary FROM employees";
                    var employees = await connection.QueryAsync<Employees>(query);

                    foreach (var employee in employees)
                    {
                        Console.WriteLine($"ID: {employee.Employee_Id}, Name: {employee.First_Name} {employee.Last_Name}, Email: {employee.Email}, Hire Date: {employee.Hire_Date}, Salary: {employee.Salary}");
                    }
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine($"An error occurred: {ex.Message}");
            }
        }
    }
}