public void InitialiseDatabase(Result result)
{
if (!result.Succeeded)
{
return;
}
SqlConnection conn = null;
try
{
using (TransactionScope scope = new TransactionScope())
{
conn = (SqlConnection)DatabaseManager.DatabaseEngine.GetConnection();
SqlServer2005Database db = (SqlServer2005Database)DatabaseManager.DatabaseEngine;
Result r = db.ExecuteScript(conn, ResourceLoader.LoadTextResource("Sprocket.Web.FileManager.SqlServer2005.scripts.sql"));
if (!r.Succeeded)
{
result.SetFailed(r.Message);
return;
}
scope.Complete();
}
}
finally
{
DatabaseManager.DatabaseEngine.ReleaseConnection(conn);
}
return;
}
public void Initialise(Result result)
{
if (!result.Succeeded)
{
return;
}
SqlConnection conn = null;
try
{
using (TransactionScope scope = new TransactionScope())
{
conn = (SqlConnection)DatabaseManager.DatabaseEngine.GetConnection();
SqlServer2005Database db = (SqlServer2005Database)DatabaseManager.DatabaseEngine;
string[] scripts = new string[] {
"Sprocket.Web.Merchant.Database.Sql2005DataProvider.paypal-tables.sql",
"Sprocket.Web.Merchant.Database.Sql2005DataProvider.paypal-procs.sql"
};
foreach (string sql in scripts)
{
Result r = db.ExecuteScript(conn, ResourceLoader.LoadTextResource(sql));
if (!r.Succeeded)
{
result.SetFailed(sql + ": " + r.Message);
return;
}
}
scope.Complete();
}
}
catch (Exception ex)
{
result.SetFailed(ex.Message);
return;
}
finally
{
DatabaseManager.DatabaseEngine.ReleaseConnection();
}
}
public void InitialiseDatabase(Result result)
{
if (!result.Succeeded)
{
return;
}
SqlConnection conn = null;
try
{
using (TransactionScope scope = new TransactionScope())
{
conn = (SqlConnection)DatabaseManager.DatabaseEngine.GetConnection();
SqlServer2005Database db = (SqlServer2005Database)DatabaseManager.DatabaseEngine;
string[] scripts = new string[] {
"Sprocket.Web.Forums.SqlServer2005.schema.sql",
"Sprocket.Web.Forums.SqlServer2005.Generated.Entity.Procedures.sql",
"Sprocket.Web.Forums.SqlServer2005.procedures.sql",
"Sprocket.Web.Forums.SqlServer2005.data.sql"
};
foreach (string sql in scripts)
{
Result r = db.ExecuteScript(conn, ResourceLoader.LoadTextResource(sql));
if (!r.Succeeded)
{
result.SetFailed(sql + ": " + r.Message);
return;
}
}
scope.Complete();
}
}
finally
{
DatabaseManager.DatabaseEngine.ReleaseConnection();
}
return;
}
