C# (CSharp) CRM.Helper.Web_API_Helper_Code.Logging.QueryBuilder QueryStubs Examples

Example #1

        public List <string> GetDistinctColumnValues(string column)
        {
            List <string> values = new List <string>();

            using (this.connection)
            {
                try
                {
                    this.connection.Open();
                    SqlCommand    cmd    = new SqlCommand(QueryStubs.getDistinctColumn(column, this.dbName), this.connection);
                    SqlDataReader reader = cmd.ExecuteReader();
                    while (reader.Read())
                    {
                        values.Add(reader[0].ToString());
                    }
                    reader.Close();
                }
                catch (Exception ex)
                {
                }
            }
            return(values);
        }

Example #2

 public QueryBuilder(FilteredRequest request)
 {
     this.request = request;
     this.SQL     = QueryStubs.getFilteredResults();
 }