Skip to content

Latest commit

 

History

History
55 lines (35 loc) · 2.03 KB

README.md

File metadata and controls

55 lines (35 loc) · 2.03 KB

ServiceStack App

.NET - Mono switching

When in Mono - Monodevelop (Tested on Mac OS X Mountain Lion)

  • In WebApp.Bootstrap.AppHost uncomment 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);

When in .NET - Visual Studio

  • In WebApp.Bootstrap.AppHost uncomment 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);

Creating SQL Server Express Db Tables for first time

Connection string in web.config:

<connectionStrings>
<add name="ServiceStackTest" providerName="System.Data.SqlClient" connectionString="Data Source=.\sqlexpress;Initial Catalog=test-servicestack;Integrated Security=true;MultipleActiveResultSets=True" />
</connectionStrings>

Create Database

  • Go to SSMS and add new Database named test-servicestack.

Create Tables

  • Add CreateSqliteInMemoryTables below 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);