/// <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();
            }
        }
Пример #2
0
        /// <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);
            }
        }