public IScriptReponse Execute(AbstractConnection connection, string script, int timeOut = 0)
{
var response = new ScriptResponse();
var server = new Server();
var logger = connection.Logger;
try {
logger.Debug("Connecting to {0} on {1}.", connection.Database, connection.Server);
server.Connect(connection.GetConnectionString());
var results = server.Execute(script);
foreach (XmlaResult result in results)
{
foreach (XmlaMessage message in result.Messages)
{
response.Messages.Add(message.Description);
}
}
response.Success = response.Messages.Count == 0;
} catch (Exception e) {
logger.Debug(e.Message + (e.InnerException != null ? " " + e.InnerException.Message : string.Empty));
response.Messages.Add(e.Message);
} finally {
if (server.Connected)
{
logger.Debug("Disconnecting from {0} on {1}.", connection.Database, connection.Server);
server.Disconnect();
}
}
return(response);
}
public IScriptReponse Execute(AbstractConnection connection, string script, int timeOut = 0) {
var response = new ScriptResponse();
var server = new Server();
var logger = connection.Logger;
try {
logger.Debug("Connecting to {0} on {1}.", connection.Database, connection.Server);
server.Connect(connection.GetConnectionString());
var results = server.Execute(script);
foreach (XmlaResult result in results) {
foreach (XmlaMessage message in result.Messages) {
response.Messages.Add(message.Description);
}
}
response.Success = response.Messages.Count == 0;
} catch (Exception e) {
logger.Debug(e.Message + (e.InnerException != null ? " " + e.InnerException.Message : string.Empty));
response.Messages.Add(e.Message);
} finally {
if (server.Connected) {
logger.Debug("Disconnecting from {0} on {1}.", connection.Database, connection.Server);
server.Disconnect();
}
}
return response;
}
public bool Check(AbstractConnection connection) {
bool isReady;
var server = new Server();
try {
server.Connect(connection.GetConnectionString());
isReady = server.Connected;
server.Disconnect();
} catch (Exception e) {
_logger.Warn("Error checking {0} connection. {1}", connection.Name, e.Message);
return false;
}
return isReady;
}
public bool Check(AbstractConnection connection)
{
bool isReady;
var server = new Server();
try {
server.Connect(connection.GetConnectionString());
isReady = server.Connected;
server.Disconnect();
} catch (Exception e) {
_logger.Warn("Error checking {0} connection. {1}", connection.Name, e.Message);
return(false);
}
return(isReady);
}
public bool Check(AbstractConnection connection, ILogger logger) {
if (CachedResults.ContainsKey(connection.Name)) {
return CachedResults[connection.Name];
}
if (!new FileInfo(connection.Server).Exists) {
logger.Warn("{0} not found.", connection.Server);
var type = System.Type.GetType("System.Data.SqlServerCe.SqlCeEngine, System.Data.SqlServerCe", false, true);
dynamic engine = System.Activator.CreateInstance(type, connection.GetConnectionString());
engine.CreateDatabase();
logger.Warn("Created {0} database file.", connection.Server);
};
return CheckConnection(connection);
}
public bool Check(AbstractConnection connection, ILogger logger)
{
if (CachedResults.ContainsKey(connection.Name))
{
return(CachedResults[connection.Name]);
}
if (!new FileInfo(connection.Server).Exists)
{
logger.Warn("{0} not found.", connection.Server);
var type = System.Type.GetType("System.Data.SqlServerCe.SqlCeEngine, System.Data.SqlServerCe", false, true);
dynamic engine = System.Activator.CreateInstance(type, connection.GetConnectionString());
engine.CreateDatabase();
logger.Warn("Created {0} database file.", connection.Server);
}
;
return(CheckConnection(connection));
}
