SisoDatabase

The Database-class is designed for being longlived. An instance of the ISisoDatabase is always (despite which provider you use) designed for being longlived. Create it once per distinct connection string (database) and then keep it alive for the rest of the application. This is really important. Since the ISisoDatabase implementation holds cached representation of Db-Schemas and any assigned cache-provider (data-cache).

Example

var cnInfo = new Sql2012ConnectionInfo("connectionstring | connectionstring name");
var database = new Sql2012DbFactory().CreateDatabase(cnInfo);

Using extension methods

var database = "connectionstring | connectionstring name".CreateSql2012Db();

Read more about the connectionstring format here: Connections.