Hi, I'm using a Http Handler in my project to serve data as json on a certain URL, now I need to fetch some data from a custom database table with NPoco. I figured out I need to use the IScopeProvider to create a scope and use it with Database, though it looks like I can't use the scope provider in my http handler since it throws an error that I can't use a constructor.

How can I use my database inside the http handler? Code below:

class CustomJsonHandler : IHttpHandler
{
    //private readonly IScopeProvider _scopeProvider;

    //public CustomJsonHandler(IScopeProvider scopeProvider)
    //{
    //  _scopeProvider = scopeProvider;
    //}

    public void ProcessRequest(HttpContext context)
    {
        JsonRoot file = new JsonRoot();

        // This doesn't work, but works in a controller I'm using somewhere else.
        //using (var scope = _scopeProvider.CreateScope())
        //{
        //   var result = scope.Database.Query<CustomJsonDto>().Where(x => x.NodeId == 1053).FirstOrDefault();
        //
        //  scope.Complete();
        //}

        // I want to fill this with database data.
        file.name = "Blabla";
        file.version = 2;

        string jsonOutput = JToken.Parse(JsonConvert.SerializeObject(file)).ToString(Formatting.Indented);

        context.Response.ContentType = "application/json";
        context.Response.Write(jsonOutput);
    }
}