create a method that uses dapper to call a sql script referenced as an embedded resource in csharp

main.cs
using System.Data;
using System.Data.SqlClient;
using System.Reflection;
using Dapper;

public static class SqlScriptRunner
{
    public static void RunScript(string scriptName, IDbConnection connection)
    {
        var assembly = Assembly.GetExecutingAssembly();
        
        using (var stream = assembly.GetManifestResourceStream(scriptName))
        {
            if (stream == null)
            {
                throw new ArgumentException($"The script '{scriptName}' was not found as an embedded resource.");
            }

            string script;
            using (var reader = new System.IO.StreamReader(stream))
            {
                script = reader.ReadToEnd();
            }

            connection.Execute(script);
        }
    }
}
763 chars
29 lines

main.cs
using (var connection = new SqlConnection(connectionString))
{
    connection.Open();
    SqlScriptRunner.RunScript("MyAssemblyName.MyScript.sql", connection);
}
162 chars
6 lines