Multi result using HanaCommand in .NET

[former_member815937]

Hi all, I want to get multiple select result while executing HanaCommand, but HANA DB throws a error: Sap.Data.Hana.HanaException (0x80004005): sql syntax error: incorrect syntax near "SELECT": line 2 col 1 (at pos 28)

when I'm doing like in the code below. Is it possible to put in there multiple queries to read many results?

using (var con = new HanaConnection(conString))
{
	con.Open();

	using var cmd = new HanaCommand(@"SELECT COUNT(*) FROM ITEM1;SELECT ID FROM ITEM2;", con);
	using var reader = cmd.ExecuteReader();
		
	while (reader.Read())
	{
		// do stuff
	}

	reader.NextResult();

	while (reader.Read())
	{
		// do stuff...
	}
}

[HakanHaslaman]

There was a fix to a similar issue:

https://launchpad.support.sap.com/#/notes/2407947

I guess, you stay on a newer version of HAN DB. But, could you try the mentioned workaround and check, if that helps further?

[former_member815937]

Sorry, don't have an S user to check the link provided by you hakan.haslaman .
FIY: I'm using SAP HANA Cloud trial project for my proof of concept, is this workaround can be applied there too?

[HakanHaslaman]

not sure about the trial project, but I can give you the workaround mentioned in the SAP note:

>>><<<

• Use \"mySchema\".\"myTable\", instead of mySchema.\"myTable\"
  

>>><<<

I hope it helps. If not, may anyone have another idea.