Skip to content

GetSchemaTable returns information about first result set #581

@bgrainger

Description

@bgrainger

When executing a command that returns multiple result sets, calling GetSchemaTable on the first result set caches the schema for the lifetime of the MySqlDataReader.

using (var cmd = new MySqlCommand("select * from table1; select * from table2;", connection))
using (var reader = cmd.ExecuteReader())
{
	do
	{
		// always returns the schema for 'table1'
		var table = reader.GetSchemaTable();
		while (reader.Read())
		{
		}
	} while (reader.NextResult());
}

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions