- In
WebApp.Bootstrap.AppHostuncomment Sqlite and comment SQL Server:
IDbConnectionFactory dbFactory = new OrmLiteConnectionFactory(":memory:", false, SqliteOrmLiteDialectProvider.Instance);
this.CreateSqliteInMemoryTables(dbFactory);
// string connectionString = ConfigurationManager.ConnectionStrings["QcoachServiceStack"].ConnectionString;
// IDbConnectionFactory dbFactory = new OrmLiteConnectionFactory(connectionString, false, SqlServerOrmLiteDialectProvider.Instance);- In
WebApp.Bootstrap.AppHostuncomment SQL Server and comment Sqlite:
// IDbConnectionFactory dbFactory = new OrmLiteConnectionFactory(":memory:", false, SqliteOrmLiteDialectProvider.Instance);
// this.CreateSqliteInMemoryTables(dbFactory);
string connectionString = ConfigurationManager.ConnectionStrings["ServiceStackTest"].ConnectionString;
IDbConnectionFactory dbFactory = new OrmLiteConnectionFactory(connectionString, false, SqlServerOrmLiteDialectProvider.Instance);<connectionStrings>
<add name="ServiceStackTest" providerName="System.Data.SqlClient" connectionString="Data Source=.\sqlexpress;Initial Catalog=test-servicestack;Integrated Security=true;MultipleActiveResultSets=True" />
</connectionStrings>- Go to SSMS and add new Database named
test-servicestack.
- Add
CreateSqliteInMemoryTablesbelow the dbFactory of SQL Server. - After first run make sure this line of code is commented, because it will always DROP Table and recreate it.
string connectionString = ConfigurationManager.ConnectionStrings["ServiceStackTest"].ConnectionString;
IDbConnectionFactory dbFactory = new OrmLiteConnectionFactory(connectionString, false, SqlServerOrmLiteDialectProvider.Instance);
this.CreateSqliteInMemoryTables(dbFactory);