/// <summary> /// Init the specified directory. /// </summary> /// <param name="directory">string</param> public static void Init(string directory) { if (Directory.Exists(directory)) { string[] filePaths = Directory.GetFiles(directory); foreach (string file in filePaths) { FileInfo fileInfo = new FileInfo(file); string key = fileInfo.Name; try { key = key.Substring(0, fileInfo.Name.Length - 4); if (!storedProcedures.ContainsKey(key)) { SQLStoredProcedure sp = new SQLStoredProcedure(file, key); storedProcedures.Add(key, sp); } } catch (Exception ex) { Console.WriteLine(ex); } } } }
/// <summary> /// Executes a stored procedure. /// </summary> /// <returns>SQLQueryResult</returns> /// <param name="procedure">SQLStoredProcedure</param> public SQLQueryResult ExecuteQuery(SQLStoredProcedure procedure) { return(ExecuteQuery(procedure.Text)); }