Rock.Data.DbService.GetDataSet C# (CSharp) Method

        public static DataSet GetDataSet( string query, CommandType commandType, Dictionary<string, object> parameters, int? timeOut = null )
        {
            string connectionString = GetConnectionString();
            if ( !string.IsNullOrWhiteSpace( connectionString ) )
            {
                using ( SqlConnection con = new SqlConnection( connectionString ) )
                {
                    con.Open();

                    using ( SqlCommand sqlCommand = new SqlCommand( query, con ) )
                    {
                        if ( timeOut.HasValue )
                        {
                            sqlCommand.CommandTimeout = timeOut.Value;
                        }
                        sqlCommand.CommandType = commandType;

                        if ( parameters != null )
                        {
                            foreach ( var parameter in parameters )
                            {
                                SqlParameter sqlParam = new SqlParameter();
                                sqlParam.ParameterName = parameter.Key.StartsWith( "@" ) ? parameter.Key : "@" + parameter.Key;
                                sqlParam.Value = parameter.Value;
                                sqlCommand.Parameters.Add( sqlParam );
                            }
                        }

                        SqlDataAdapter adapter = new SqlDataAdapter( sqlCommand );
                        DataSet dataSet = new DataSet( "rockDs" );
                        adapter.Fill( dataSet );
                        return dataSet;
                    }
                }
            }

            return null;
        }

        /// <summary>
        /// Gets a data table.
        /// </summary>
        /// <param name="query">The query.</param>
        /// <param name="commandType">Type of the command.</param>
        /// <param name="parameters">The parameters.</param>
        /// <returns></returns>
        public static DataTable GetDataTable(string query, CommandType commandType, Dictionary <string, object> parameters)
        {
            DataSet dataSet = DbService.GetDataSet(query, commandType, parameters);

            if (dataSet.Tables.Count > 0)
            {
                return(dataSet.Tables[0]);
            }

            return(null);
        }