public ScimoreDb()
{
try
{
IPathManager pathManager = ServiceRegistration.Get <IPathManager>();
string dataDirectory = pathManager.GetPath("<DATA>");
string databasePath = Path.Combine(dataDirectory, DEFAULT_DATABASE_FILE);
const string DATABASE_NAME = "MediaPortal";
_connectionString = "Initial Catalog=" + DATABASE_NAME;
_db.Create(databasePath);
_db.Open(databasePath);
using (ScimoreConnection conn = _db.CreateConnection(_connectionString))
{
using (IDbCommand command = conn.CreateCommand())
{
command.CommandText = "CREATE DATABASE IF NOT EXISTS " + DATABASE_NAME;
command.ExecuteNonQuery();
}
}
}
catch (Exception e)
{
ServiceRegistration.Get <ILogger>().Critical("Error establishing database connection", e);
throw;
}
}
public void Dispose()
{
if (_connection != null)
{
_connection.Close();
_connection = null;
}
}
public void Dispose()
{
if (_connection != null)
{
_connection.Close();
_connection = null;
}
}
public ScimoreDbTransaction(ScimoreDb database, ScimoreConnection connection, IsolationLevel level)
{
_database = database;
_connection = connection;
_transaction = new ScimoreTransaction(level, connection);
}
public ScimoreDbTransaction(ScimoreDb database, ScimoreConnection connection, IsolationLevel level)
{
_database = database;
_connection = connection;
_transaction = new ScimoreTransaction(level, connection);
}
