/// <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); } } }