public DataSet Execute(string sql)
{
var parserManager = new ParserManager(Configuration);
var parseStatementsResult = parserManager.ParseStatements(sql);
if (parseStatementsResult.Errors.Any())
{
var sb = new StringBuilder();
foreach (var error in parseStatementsResult.Errors)
{
sb.AppendLine($"{error.Message}");
}
throw new Exception(sb.ToString());
}
var statements = parseStatementsResult.Value;
var dataSet = new DataSet();
using (var service = OrganizationService.Create(Credential))
{
foreach (var statement in statements)
{
if (statement is SelectStatement)
{
var crmInstance = new CRMInstance(service);
var selectEngine = new SelectEngine(crmInstance, Configuration);
var selectStatement = (SelectStatement)statement;
var dt = selectEngine.Execute(selectStatement);
dataSet.Tables.Add(dt);
}
else if (statement is UpdateStatement)
{
throw new NotSupportedException($"'Update' statement is currently not supported.");
}
else if (statement is DeleteStatement)
{
throw new NotSupportedException($"'Delete' statement is currently not supported.");
}
}
}
return(dataSet);
}