/// <summary>
/// Returns a prepared statement to execute (in case of virtual stored procedures)
/// or the name of a stored procedure to execute (in case of stored procedures executed from the database)
/// </summary>
/// <param name="StoredProcedureName"></param>
private string GetCommandText(string storedProcedureName, out CommandType commandType)
{
string val;
ProcedureStorageLocationType procedureStorageLocationType = ProcedureStorageLocationProvider.GetLocation(storedProcedureName);
if (procedureStorageLocationType == ProcedureStorageLocationType.None) //Get default
{
procedureStorageLocationType = GetSPOption();
}
switch (procedureStorageLocationType)
{
case ProcedureStorageLocationType.Db:
commandType = CommandType.StoredProcedure;
val = storedProcedureName;
break;
case ProcedureStorageLocationType.Resource:
commandType = CommandType.Text;
val = LookUpText(storedProcedureName);
break;
case ProcedureStorageLocationType.None:
default:
throw new InvalidOperationException(string.Format("specified option not implemented. Option was {0}", procedureStorageLocationType));
}
return(val);
}
private static void PopulateInternalCache()
{
if (_InternalCache == null)
{
_InternalCache = new Dictionary <string, string>(100);
}
List <string> procedureNames = ProcedureStorageLocationProvider.GetResourceCommands();
if (procedureNames != null && procedureNames.Count > 0)
{
foreach (string procName in procedureNames)
{
GetText(procName);
}
}
}
