How to update custom services after upgrade to v2.0.0

[kharaei]

Considering that SqlQuery has been removed in version 2.0.0, after updating from version 1.8.3, it is not clear to me what changes I should apply to the following code. Could you please provide guidance

public async Task<IEnumerable<GetCategoriesResult>> GetCategoriesAsync(IQueryManager queryManager, CancellationToken cToken)
{
    var sqlQuery = new SqlQuery
    {
        Name = "category-list",
        Schema = "{ \"type\" : \"ContentItem/Categories\" }",
        Template = $"select * from {Keys.ViewNames.Categories}",
        ReturnDocuments = false
    };

    var categoriesQueryResult = await queryManager.ExecuteQueryAsync(sqlQuery, new Dictionary<string, object>());
    if (categoriesQueryResult is null)
        throw new CategoryExecutingException();

    var categories = categoriesQueryResult?.Items?.Select(x => JsonSerializer.Deserialize<OrchardCategoriesResult>(x.ToString() ?? string.Empty));
    var result = categories?.Select(s => new GetCategoriesResult
    {
        Id = s?.ContentItemId,
        Title = s?.Title,
        Slug = s?.Slug
    });

    return result ?? Enumerable.Empty<GetCategoriesResult>();
}

[gvkries]

If I'm not mistaken, instead of using SqlQuery you need to attach a SqlQueryMetadata to a Query itself:

var sqlQuery = new Query() 
{
    Source = SqlQuerySource.SourceName,
    Name = "category-list",
    Schema = "{ \"type\" : \"ContentItem/Categories\" }",
    ReturnDocuments = false
};
sqlQuery.Put(new SqlQueryMetadata()
{
    Template = $"select * from {Keys.ViewNames.Categories}"
});

[kharaei]

Thank you, it worked...