C#/MariaDB code that lets you easily pick an isolation level and read only flag to maximize throughput of queries that can be read only with dirty reads allowed

MariaDB C# Boilerplate

using MySql.Data.MySqlClient;
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Linq;
using System.Web;
using Dapper;

namespace Gist
{
    public class Utils
    {
        public static readonly string ConnectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
        
        private const string ReadOnlySession = "set session transaction isolation level read uncommitted, READ ONLY";

        internal static MySqlConnection CreateConnection()
        {
            var connection = new MySqlConnection(ConnectionString);
            connection.Open();
            return connection;
        }

        internal static MySqlConnection CreateConnectionReadUncommitted()
        {
            var connection = new MySqlConnection(ConnectionString);
            connection.Open();
            connection.Execute(ReadOnlySession);
            return connection;
        }
    }
}