EasyQueryManagerSql class

Represents an implementation of Korzh.EasyQuery.Services.EasyQueryManager which generates SQL queries and can work with some relational DB directly.

public class Korzh.EasyQuery.Services.EasyQueryManagerSql
    : EasyQueryManager

Properties

Type	Name	Description
`Func<String, DbConnection>`	ConnectionResolver	Gets or sets the connection resolver - a faunction that returs a connection object by model’s ID.
`Action<DbCommand>`	DbCommandTuner	Gets or sets the function which is called before execution of some DbCommand.

Methods

Type	Name	Description
`QueryBuilderResult`	BuildQuery(`JObject` options = null, `Boolean` addPaging = False)	Builds SQL statement by the DbQuery object. This methods calls QueryBuilder delegate to build SQL.
`DataModel`	CreateModelCore(`String` modelId)	Creates new DataModel object
`Query`	CreateQueryCore(`DataModel` model)	Creates new DbQuery object.
`IEqResultSet`	ExecuteQueryCore(`JObject` options = null)	The actual implemenation of ExecuteQuery function. This method is overridden in EasyQueryManagerBase descendants like EasyQueryManagerSql or EasyQueryManagerLinq.
`DbConnection`	GetConnection(`String` modelId)	Gets the DbConnection associated with this service. If connection is not defined yet - it wil be resolved using ConnectionResolver. This method opens the connection if it’s not opened yet.
`DbConnection`	GetConnectionCore(`String` modelId)	Returns the connection object. The default implementations just calls ConnectionResolved to get the connection. You can override this function in dervived class to implement your own behavior of resolving the connnection by the model ID.
`IDataReader`	GetDataReader(`JObject` options = null, `Boolean` addPaging = False)	Gets the data reader by query. This function is called from ExecuteQuery or ExportQueryResult.
`IEqResultSet`	GetEmptyResultSet()	Gets any empty result set.
`IQueryBuilder`	GetQueryBuilderCore(`Query` query, `JObject` options)	Returns the query builder. In this particular kind of EasyQueryManager it will be an instance of SqlQueryBuilder. This method also builds the query so you can read the result via GetResult method call.
`Int64`	GetRecordCount()	Gets the record count for the current query
`DbCommand`	PrepareDbCommand(`String` sql, `QueryParamList` queryParams = null)	Creates and prepares the database command.
`IEqResultSet`	RetrieveResultSet(`String` modelId, `QueryBuilderResult` qbr)	Creates and returns a ResultSet object by SQL statement.

Static Methods

Type	Name	Description
`void`	RegisterDbGate()