public void DropFunction(ProcRef funcName)
{
using (Log.DebugTraceMethodCallFormat("DropFunction", "Dropping function [{0}]", funcName))
{
_provider.DropFunction(funcName);
}
}
public string GetProcedureDefinition(ProcRef proc)
{
if (proc == null)
{
return(null);
}
var procs = db.GetSchema(OleDbMetaDataCollectionNames.Procedures, new string[] { null, null, proc.Name });
if (procs.Rows.Count != 1)
{
throw new InvalidOperationException(string.Format("Did not get exactly one result for Procedure {0}", proc));
}
var def = procs.Rows[0]["PROCEDURE_TYPE"] + Environment.NewLine + procs.Rows[0]["PROCEDURE_DEFINITION"];
return(def.ToString());
}
public abstract void DropFunction(ProcRef funcName);
public abstract void ExecRefreshRightsOnProcedure(ProcRef procName);
public string GetProcedureDefinition(ProcRef proc)
{
throw new NotImplementedException();
}
public abstract void DropProcedure(ProcRef procName);
/// <summary>Not supported.</summary>
void ISchemaProvider.DropProcedure(ProcRef procName)
{
throw new NotSupportedException();
}
public bool CheckFunctionExists(ProcRef funcName)
{
return(_provider.CheckFunctionExists(funcName));
}
public void CreateRefreshRightsOnProcedure(ProcRef procName, TableRef viewUnmaterializedName, TableRef tblName, TableRef tblNameRights)
{
Log.InfoFormat("Creating refresh rights procedure for [{0}]", tblName);
_provider.CreateRefreshRightsOnProcedure(procName, viewUnmaterializedName, tblName, tblNameRights);
}
public void ExecRefreshRightsOnProcedure(ProcRef procName)
{
_provider.ExecRefreshRightsOnProcedure(procName);
}
public bool CheckFunctionExists(ProcRef funcName)
{
var result = _provider.CheckFunctionExists(funcName);
LogExistance("Function", funcName, result);
return result;
}
public bool CheckProcedureExists(ProcRef procName)
{
var result = _provider.CheckProcedureExists(procName);
LogExistance("Procedure", procName, result);
return result;
}
bool ISchemaProvider.CheckFunctionExists(ProcRef funcName)
{
throw new NotSupportedException();
}
/// <summary>Not supported.</summary>
void ISchemaProvider.ExecRefreshRightsOnProcedure(ProcRef procName)
{
throw new NotSupportedException();
}
/// <summary>Not supported.</summary>
void ISchemaProvider.CreateRefreshRightsOnProcedure(ProcRef procName, TableRef viewUnmaterializedName, TableRef tblName, TableRef tblNameRights)
{
throw new NotSupportedException();
}
public bool CheckProcedureExists(ProcRef procName)
{
return _provider.CheckProcedureExists(procName);
}
public bool CheckProcedureExists(ProcRef procName)
{
return(_provider.CheckProcedureExists(procName));
}
public void DropFunction(ProcRef funcName)
{
using (Log.DebugTraceMethodCallFormat("DropFunction", "Dropping function [{0}]", funcName))
{
_provider.DropFunction(funcName);
}
}
public void CreateRefreshRightsOnProcedure(ProcRef procName, TableRef viewUnmaterializedName, TableRef tblName, TableRef tblNameRights)
{
_provider.CreateRefreshRightsOnProcedure(procName, viewUnmaterializedName, tblName, tblNameRights);
}
public void DropFunction(ProcRef funcName)
{
Log.InfoFormat("Dropping function [{0}]", funcName);
_provider.DropFunction(funcName);
}
/// <summary>Not supported.</summary>
bool ISchemaProvider.CheckProcedureExists(ProcRef procName)
{
throw new NotSupportedException();
}
public void DropProcedure(ProcRef procName)
{
Log.DebugFormat("Dropping procedure [{0}]", procName);
_provider.DropProcedure(procName);
}
public void ExecRefreshRightsOnProcedure(ProcRef procName)
{
using (Log.InfoTraceMethodCallFormat("RefreshRights", "Refreshing [{0}]", procName))
{
_provider.ExecRefreshRightsOnProcedure(procName);
}
}
public void ExecRefreshRightsOnProcedure(ProcRef procName)
{
_provider.ExecRefreshRightsOnProcedure(procName);
}
public string GetProcedureDefinition(ProcRef proc)
{
var result = _provider.GetProcedureDefinition(proc);
Log.DebugFormat("Fetched procedure {0} definition:\n{1}", proc, result);
return result;
}
public string GetProcedureDefinition(ProcRef proc)
{
if (proc == null) return null;
var procs = db.GetSchema(OleDbMetaDataCollectionNames.Procedures, new string[] { null, null, proc.Name });
if (procs.Rows.Count != 1)
{
throw new InvalidOperationException(string.Format("Did not get exactly one result for Procedure {0}", proc));
}
var def = procs.Rows[0]["PROCEDURE_TYPE"] + Environment.NewLine + procs.Rows[0]["PROCEDURE_DEFINITION"];
return def.ToString();
}
bool ISchemaProvider.CheckFunctionExists(ProcRef funcName)
{
throw new NotSupportedException();
}
public abstract bool CheckProcedureExists(ProcRef procName);
/// <summary>Not supported.</summary>
bool ISchemaProvider.CheckProcedureExists(ProcRef procName)
{
throw new NotSupportedException();
}
public abstract bool CheckFunctionExists(ProcRef funcName);
/// <summary>Not supported.</summary>
void ISchemaProvider.CreateRefreshRightsOnProcedure(ProcRef procName, TableRef viewUnmaterializedName, TableRef tblName, TableRef tblNameRights)
{
throw new NotSupportedException();
}
public abstract void CreateRefreshRightsOnProcedure(ProcRef procName, TableRef viewUnmaterializedName, TableRef tblName, TableRef tblNameRights);
void ISchemaProvider.DropFunction(ProcRef funcName)
{
throw new NotSupportedException();
}
public bool CheckFunctionExists(ProcRef funcName)
{
return _provider.CheckFunctionExists(funcName);
}
/// <summary>Not supported.</summary>
void ISchemaProvider.DropProcedure(ProcRef procName)
{
throw new NotSupportedException();
}
public void CreateRefreshRightsOnProcedure(ProcRef procName, TableRef viewUnmaterializedName, TableRef tblName, TableRef tblNameRights)
{
_provider.CreateRefreshRightsOnProcedure(procName, viewUnmaterializedName, tblName, tblNameRights);
}
/// <summary>Not supported.</summary>
void ISchemaProvider.ExecRefreshRightsOnProcedure(ProcRef procName)
{
throw new NotSupportedException();
}
public void DropProcedure(ProcRef procName)
{
Log.DebugFormat("Dropping procedure [{0}]", procName);
_provider.DropProcedure(procName);
}
public string GetProcedureDefinition(ProcRef proc)
{
return(_provider.GetProcedureDefinition(proc));
}
public string GetProcedureDefinition(ProcRef proc)
{
return _provider.GetProcedureDefinition(proc);
}
void ISchemaProvider.DropFunction(ProcRef funcName)
{
throw new NotSupportedException();
}