AipGateway/AipDatabase.API/Repositories/SqlHelper.cs

using System.Reflection;

namespace AipDatabase.API.Repositories
{
    public class SqlHelper<T>
    {
        public string GetSqlFromEmbeddedResource(string name)
        {
            using var resourceStream = typeof(T).Assembly.GetManifestResourceStream(typeof(T).Namespace + ".Mapper." + name + ".sql");
            using var reader = new StreamReader(resourceStream!);
            return reader.ReadToEnd();
        }
    }
}