[IGNITE-18478] .NET: Thin 3.0: Add ExecuteReader to SQL API

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.0
• Component/s: platforms, thin client
• Labels: ignite-3
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Pavel Tupitsyn
• Reporter: Pavel Tupitsyn
• Reviewer: Igor Sapego
• Created: 28/Dec/22 06:37
• Updated: 04/Sep/24 16:19
• Resolved: 24/Jan/23 14:46

Description

Add a new method to ISql API:

Task<IgniteDbDataReader> ExecuteReaderAsync(ITransaction? transaction, SqlStatement statement, params object?[]? args)

• IgniteDbDataReader inherits from System.Data.Common.DbDataReader, providing a standard interface to work with query results.
• DbDataReader API is an efficient way to retrieve query results without object mapping. It can be implemented in a high-performance allocation-free way. This is a good alternative to allocation-heavy IResultSet<IIgniteTuple>.

Issue Links

• is blocked by: IGNITE-18588 .NET: Thin 3.0: BinaryTupleReader incorrect behavior on type mismatch
• is related to: IGNITE-17333 .NET: Thin 3.0: SQL ResultSet object mapping
• links to: GitHub Pull Request #1567