sqlserver files

_init

dotnet add package ServiceStack.OrmLite.SqlServer

Configure.Db.cs

using Microsoft.Extensions.Configuration;
using Microsoft.Extensions.DependencyInjection;
using ServiceStack;
using ServiceStack.Data;
using ServiceStack.DataAnnotations;
using ServiceStack.OrmLite;

namespace MyApp
{
    // Example Data Model
    // public class MyTable
    // {
    //     [AutoIncrement]
    //     public int Id { get; set; }
    //     public string Name { get; set; }
    // }

    public class ConfigureDb : IConfigureServices, IConfigureAppHost
    {
        IConfiguration Configuration { get; }
        public ConfigureDb(IConfiguration configuration) => Configuration = configuration;

        public void Configure(IServiceCollection services)
        {
            services.AddSingleton<IDbConnectionFactory>(new OrmLiteConnectionFactory(
                Configuration.GetConnectionString("DefaultConnection")
                    ?? "Server=localhost;Database=test;User Id=test;Password=test;MultipleActiveResultSets=True;",
                SqlServer2012Dialect.Provider));
        }

        public void Configure(IAppHost appHost)
        {
            appHost.GetPlugin<SharpPagesFeature>()?.ScriptMethods.Add(new DbScriptsAsync());

            // Create non-existing Table and add Seed Data Example
            // using var db = appHost.Resolve<IDbConnectionFactory>().Open();
            // if (db.CreateTableIfNotExists<MyTable>())
            // {
            //     db.Insert(new MyTable { Name = "Seed Data for new MyTable" });
            // }
        }
    }
}