Dapper relationship query example

example.cs

using (var connection = new SqlConnection(_config["Connection"]))
{
    string query = @"SELECT * 
        FROM [Template]
        WHERE [Type] = @type;

        SELECT tct.TemplateId as TemplateId, tc.Name as CategoryName
        FROM [TemplateCategory_Template] tct
        JOIN [TemplateCategory] tc ON tct.TemplateCategoryId = tc.Id;

        SELECT ts.TemplateId, ts.Url 
        FROM [TemplateScreenshots] ts
        JOIN [Template] t on ts.TemplateId = t.Id
        WHERE t.[Type] = @type;";

    using (var results = connection.QueryMultiple(query, new { type })) {
        var templates = connection.Read<TemplateDto>(templatesQuery, new { type }).ToList();

        connection.Read<TemplateCategory>(templateCategoriesQuery)
            .GroupBy(t => t.TemplateId).ToList()
            .ForEach(categories =>
            {
                var template = templates.First(t => t.Id == categories.Key);
                template.Categories = categories.Select(c => c.CategoryName).ToArray();
            });

        connection.Read<TemplateScreenshot>(templateScreenshotsQuery)
            .GroupBy(t => t.TemplateId).ToList()
            .ForEach(screenshots =>
            {
                var template = templates.First(t => t.Id == screenshots.Key);
                template.Screenshots = screenshots.Select(c => c.Url).ToArray();
            });

        return templates;
    }
}