Class QueryInfo
Information about SQL query generated by ISqlExpressionVisitor.
Inheritance
Namespace: Kros.KORM.Query.Sql
Assembly: Kros.KORM.dll
Syntax
public class QueryInfoRemarks
QueryInfo contains SQL query itself (Query) and may also contain reader
for that query. Reader is uset in situations where database engine cannot handle query correctly. For example
when offset is used (Skip method in Linq), SQL Server older than 2008 is not able to ally it. In this case,
query itself does not know about limit, but special reader is created (LimitOffsetDataReader,
which will skip first N rows manually.
Constructors
QueryInfo(String)
Creates an instance with specified query.
Declaration
public QueryInfo(string query)Parameters
| Type | Name | Description |
|---|---|---|
| System.String | query | SQL query. |
QueryInfo(String, IDataReaderEnvelope)
Creates an instance with specified query and reader.
Declaration
public QueryInfo(string query, IDataReaderEnvelope reader)Parameters
| Type | Name | Description |
|---|---|---|
| System.String | query | SQL query. |
| IDataReaderEnvelope | reader | Reader used for query, if database engine itself cannot handle query itself. |
Properties
Query
SQL query.
Declaration
public string Query { get; }Property Value
| Type | Description |
|---|---|
| System.String |
Reader
Reader used for query, if database engine itself cannot handle query itself.
Declaration
public IDataReaderEnvelope Reader { get; }Property Value
| Type | Description |
|---|---|
| IDataReaderEnvelope |