public List<ProcedureInfo> LoadProcedures(string databaseName) { this.Connect(); List<ProcedureInfo> views = new List<ProcedureInfo>(); foreach (MyMeta.Procedure proc in _root.Databases[databaseName].Procedures) { if (proc.Schema == "sys") continue; string pname = proc.Name; if (Array.IndexOf(this.ignoreProcName, pname) != -1) continue; ProcedureInfo item = new ProcedureInfo(); item.Name = pname; //item.Loader = this; views.Add(item); } return views; }
private void LoadProcedures() { if (_procLoaded) return; loader.Connect(); this.procs = new List<IProcedureInfo>(); foreach (MyMeta.Procedure proc in loader.Root.Databases[this.Name].Procedures) { if (proc.Schema == "sys") continue; string pname = proc.Name; if (Array.IndexOf(loader.ignoreProcName, pname) != -1) continue; IProcedureInfo item = new ProcedureInfo(this); item.Name = pname; item.Schema = proc.Schema; procs.Add(item); } //this.procs = loader.LoadProcedures(this.name); _procLoaded = true; }