Exemple #1
0
        /// <summary>
        /// Returns a list of resulted rows represented as arrays of objects.
        /// </summary>
        /// <param name="query"></param>
        /// <returns></returns>
        public List <object[]> FetchAll(string query)
        {
            var returnable = new List <object[]>();

            var reader = new FbCommand(query, _conn).ExecuteReader();

            while (reader.Read())
            {
                int limit = reader.FieldCount;
                var row   = new object[limit];
                for (int i = 0; i < limit; i++)
                {
                    row[i] = reader.GetValue(i);
                }
                returnable.Add(row);
            }

            return(returnable);
        }