load last result from multi-statement query into DataTable

[jakobstanford]

Hi there,

I have this code:

using (var command = connection.CreateCommand())
{
    command.CommandText = sqlQuery;
    var reader = command.ExecuteReader();
    var result = new DataTable();

    do { result.Load(reader)} while (reader.NextResult());

    return result;
}

For reference, my query: SELECT 1,2; SELECT 3;

I'd expect this to store the last result set into result, but this doesn't happen. Instead I get the first result set.

Does anyone know how to accomplish this?

Thanks