Query Rgearding Fetch data from multiple tables in ServiceStack ORMLite

[SharmaRohit22]

Problem Statement:
The ORMLite framework in Azure Function with.NET 8 is what we're using to fetch data from multiple tables using SQL joins and select into a single model. However, when I run this query, the only table that returns is NoteTemplateFolders, even though I want the data from every table that I select in the SQL expression.

Please provide guidance and possible solutions for the above mentioned scenario.

My Code:

SqlExpression<NoteTemplateFolders> sqlExpression = _tenantDatabase.From<NoteTemplateFolders>()
    .Join<NoteTemplateFolders, NoteTemplates>((folder, template) => folder.Id == template.FolderId)
    .Where<NoteTemplates>(x => x.Name == "Template 342079")
    .Select<NoteTemplateFolders, NoteTemplates>((folder, template) => new
    {
        FolderId = folder.Id,
        FolderName = folder.Name,
        Id = template.Id,
        Name = template.Name,
        ClientName = "Test"
    });

List<NoteTemplateFolders> response = _tenantDatabase.Select(sqlExpression);