/// <summary> /// Executes the external query. /// </summary> /// <param name="select">The select.</param> /// <returns>DataSet.</returns> /// <exception cref="System.Exception"></exception> private DataSet ExecuteQueryExternal(string select) { ExternalQueryModel model = new ExternalQueryModel(DateTime.Now.Ticks.ToString()); try { var results = model.ExecuteQuery(this.ConnectionString, select); return(results); } catch (Exception ex) { throw ex; } finally { model.PerformCleanup(); } }
/// <summary> /// Defines the entry point of the application. /// </summary> /// <param name="args">The arguments.</param> static void Main(string[] args) { ExternalQueryModel model = new ExternalQueryModel(args[0]); try { Console.Write("Executing External Query...\r\n"); DqlConnectionStringBuilder builder = new DqlConnectionStringBuilder(model.GetConnectionString()); builder.Password = new string('*', builder.Password.Length); Console.Title = builder.ConnectionString; Console.WriteLine(builder.ConnectionString + Environment.NewLine); Console.WriteLine(model.GetQueryString()); model.WriteQuery(); } catch (Exception ex) { model.WriteError(ex); } }