Skip to content

Instantly share code, notes, and snippets.

Last active Jun 22, 2019
What would you like to do?
Configure AppHost to use OrmLite with PostgreSQL
dotnet add package ServiceStack.OrmLite.PostgreSQL
using Microsoft.Extensions.Configuration;
using Microsoft.Extensions.DependencyInjection;
using ServiceStack;
using ServiceStack.Data;
using ServiceStack.DataAnnotations;
using ServiceStack.OrmLite;
namespace MyApp
public class MyTable
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(
?? "Server=localhost;User Id=test;Password=test;Database=test;Pooling=true;MinPoolSize=0;MaxPoolSize=200",
public void Configure(IAppHost appHost)
appHost.GetPlugin<SharpPagesFeature>()?.ScriptMethods.Add(new DbScriptsAsync());
using (var db = appHost.Resolve<IDbConnectionFactory>().Open())
if (db.CreateTableIfNotExists<MyTable>())
db.Insert(new MyTable { Name = "Seed Data for new MyTable" });
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment