SQL Query result processing in C#

The SqlResultSet class provides a collection of column names as property ColumnNames and rows as objects of class SqlTuple. These can be iterated using C# foreach loops as in the following code snippet:

 
    using (SqlResultSet result = con.ExecuteQuery("select * from Person"))
    {
        foreach (string column in result.ColumnNames)
        { 
            Console.Write(column + ", ");
        }
        Console.Write();
        foreach (SqlTuple tuple in result)
        {
            Console.WriteLine(tuple[0] + ", " + tuple["value"]);
        }
    }