Following Locode Tutorial not working

Locode
1

I am following the tutorial for Locode here https://www.youtube.com/watch?v=hkuO_DMFXmc&t=3s

When I run the project, I get

Snag_287b42cf
Snag_287b42cf1920×1080 266 KB
.

After Adding the DbFactory in Configure.AutoQuery.cs like

using ServiceStack;
using ServiceStack.OrmLite;

[assembly: HostingStartup(typeof(TestLocode.ConfigureAutoQuery))]

namespace TestLocode;

public class ConfigureAutoQuery : IHostingStartup
{
    public void Configure(IWebHostBuilder builder) => builder
        .ConfigureServices((context,services) => {

            var dbFactory = new OrmLiteConnectionFactory(
                context.Configuration.GetConnectionString("DefaultConnection")
                ?? "northwind.sqlite",
                SqliteDialect.Provider);

            services.AddPlugin(new AutoQueryFeature {
                MaxLimit = 1000,
                GenerateCrudServices = new GenerateCrudServices()
                {
                    AutoRegister = true,
                    DbFactory = dbFactory,
                }
                //IncludeTotal = true,
            });
        });
}

Once this is set up, I don’t get any of the Northwind tables back, but only the App Uer and User Auth Role Tables.

Snag_2888df10
Snag_2888df101920×1080 120 KB

2

As per the docs:

When using Endpoint Routing the DB Factory also needs to be initialized on GenerateCrudServices

As for why only it’s only finding those 2 tables, that’s all it can find in the default connection. I’d need a repo I can run locally (or let me know if you’re starting with one of our repos) to identify if there are any other tables it’s supposed to find.

3

I started with Create new .NET 8 project - ServiceStack with ASP.NET Identity Auth

4

Make sure there exists missing tables in the App’s configured database that were missed, if there is upload the project to GitHub and I’ll take a look.