Skip to Content
0
Former Member
Apr 24, 2015 at 03:33 PM

Hana Ado NET Multiple SELECT

245 Views

Hi everyone,

Is it possible to get multiple result set from the only one call of HanaDataAdapter.Fill(DataSet set) method?

What I mean, in Hana Studio I can easily excequte the following query:

Select * From "MyDatabase"."MyTable";

Select * From "YourDatabase"."YourTable";

which returns multiple results.

However, the same HanaDataAdapter.SelectCommand.CommandText will rise an Exception: Incorrect SQL syntax near ";" ...

The same issue at HanaDataAdapter.ExcecuteReader() call.

Is it any way to solve this problem, I need to minimize the number of queries to database.

Best regards, Evgeny.