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