Blog: IDataReader, .NET Core & Multiple Tables (2)

GetValues.cs

using (var connection = new SqlConnection(CONNECTION_STRING))
{
  const int WIDTH = 15;
  const string COMMAND_TEXT =
    @"SELECT [Id],[Description] 
     FROM [dbo].[Table1]; 
     SELECT [Id],[Description] 
     FROM [dbo].[Table2];";

  using (var command = connection.CreateCommand())
  {
    command.CommandText = COMMAND_TEXT;
    command.CommandType = CommandType.Text;
    connection.Open();

    using (var dataReader = command.ExecuteReader())
    {
      do
      {
        var columnCount = dataReader.FieldCount;
        WriteLine();
        WriteLine($"|{new string('-', WIDTH)}|{new string('-', WIDTH)}|");
        WriteLine($"|{dataReader.GetName(0),WIDTH}|{dataReader.GetName(1),WIDTH}|");
        WriteLine($"|{new string('-', WIDTH)}|{new string('-', WIDTH)}|");

        while (dataReader.Read())
        {
          for (var i = 0; i < columnCount; i++)
          {
            Write($"|{dataReader[i],WIDTH}");
          }
          WriteLine("|");
        }
        WriteLine($"|{new string('-', WIDTH)}|{new string('-', WIDTH)}|");
    } while (dataReader.NextResult());
  }
}