Sqlite: DbDataReader resets if called Read again after reader is finished

[smitpatel]

using System;
using Microsoft.Data.Sqlite;

namespace SqliteDemo
{
    public class Program
    {
        public static void Main(string[] args)
        {
            using (var connection = new SqliteConnection("Data Source=:memory:"))
            {
                connection.Open();
                using (var createCommand = connection.CreateCommand())
                {
                    createCommand.CommandText =
                    @"CREATE TABLE Test (value INTEGER);
INSERT INTO Test VALUES(1);
INSERT INTO Test VALUES(2);
INSERT INTO Test VALUES(3);";
                    createCommand.ExecuteNonQuery();
                }

                using (var queryCommand = connection.CreateCommand())
                {
                    queryCommand.CommandText = "Select * from Test";
                    using (var dbreader = queryCommand.ExecuteReader())
                    {
                        while (dbreader.Read())
                        {
                            Console.WriteLine(dbreader.GetInt32(0));
                        }

                        Console.WriteLine(dbreader.Read());
                    }
                }
            }

            Console.WriteLine("Hello World!");
        }
    }
}

Version: 3.0.0-preview5.19227.1
Output:

PM> dotnet run
1
2
3
True
Hello World!
PM>