public static bool SwitchToMo(
this StoredProcedure self,
Database inMemDatabase,
ref string error,
ILog logger
)
{
var retValue = false;
if (self.IsSystemObject)
{
return(true);
}
if (inMemDatabase.StoredProcedures.Contains(self.Name, self.Schema))
{
logger.Log("\t" + "Already exists", self.FName());
return(true);
}
logger.Log("SP", self.FName());
var newsp = new StoredProcedure(inMemDatabase, self.Name, self.Schema);
newsp.CopyPropertiesFrom(self);
try
{
newsp.Create();
logger.Log("OK", self.FName());
retValue = true;
}
catch (Exception ex)
{
logger.Log("Error", self.FName());
error = string.Join(Environment.NewLine + "\t", ex.CollectThemAll(ex1 => ex1.InnerException)
.Select(ex1 => ex1.Message));
}
newsp = null;
return(retValue);
}
