Lightweight high-performance db-independent DAL for .NET Core: SQL commands generation, CRUD operations for POCO models and schema-less structures (dictionary/RecordSet).
Classes
| Class | Description | |
|---|---|---|
 | CommandParameter | |
| DataReaderResult |
Represents IDataReader result that can be mapped to POCO model, dictionary or RecordSet.
|
| DbBatchCommandBuilder |
Batch command builder that can produce several SQL statements into one IDbCommand.
|
| DbCommandBuilder |
Automatically generates SQL commands for SELECT/INSERT/UPDATE/DELETE queries.
|
| DbCommandBuilderExtensions |
Extension methods for IDbCommandBuilder interface.
|
| DbDataAdapter |
Data adapter between database and application data models. Implements select, insert, update and delete operations.
|
| DbDataAdapter SelectQuery |
Represents select query (returned by Select(Query) method).
|
| DbDataView |
Represents application-level read-only data view (complex query that can be queries a table).
|
| DbFactory |
Generic IDbFactory implementation that may be used with most ADO.NET Data Providers.
|
| DbSqlExpressionBuilder |
Generic implementation of DB-specific SQL expression builder.
|
| ExecuteDbCommandException |
The exception that is thrown when execution of IDbCommand is failed.
|
| QConditionNode | |
| QConst |
Represents query constant.
|
| QField |
Represents query field.
|
| QGroupNode |
Represents group of nodes combined with logical OR/AND operator
|
| QNegationNode |
Represents logical negation operator
|
| QNode |
Represents abstract query node that contains child nodes.
|
| QRawSql |
Represents raw SQL query value
|
| QRawSqlNode | |
| QSort |
Represents query sort option.
|
| QTable |
Represents query table information
|
| Query |
Represents abstract data query structure.
|
| QVar |
Represents query variable
|
| RecordSet |
Represents a set of in-memory data records with the same schema.
|
| RecordSet Column |
Represents the schema of a column in a RecordSet.
|
| RecordSet ColumnCollection |
Represents a collection of RecordSet Column objects for a RecordSet.
|
| RecordSet Row |
Represents a row of data in a RecordSet.
|
| RecordSetReader |
The RecordSetReader obtains the contents of one RecordSet as form of read-only, forward-only result set.
|
| SqlExpressionBuilder |
Generaic SQL expressions builder.
|
| StringTemplate |
Conditional string template parser.
|
| StringTemplate TokenResult |
Represents token evaluation result.
|
Interfaces
| Interface | Description | |
|---|---|---|
 | DbDataAdapter IMapperContext |
Represents DbDataAdapter SelectQuery context for custom data mapping to POCO models.
|
| IDataReaderMapperContext |
Represents context for custom DataReaderResult data mapping to POCO models.
|
| IDbCommandBuilder |
Automatically generates single-table commands to create-update-delete-retrieve database records.
|
| IDbFactory |
Represents factory for creating db-specific ADO.NET component implementations.
|
| IQueryDictionaryResult |
Represents query result that can be mapped to dictionary.
|
| IQueryModelResult |
Represents query result that can be mapped to POCO model.
|
| IQueryRecordSetResult |
Represents query result that can be mapped to RecordSet.
|
| IQueryValue |
Marker interface for query values.
|
| IRecordSetAdapter |
Represents data adapter between database and RecordSet models.
|
| ISqlExpressionBuilder |
Represents SQL builder interface.
|
Enumerations
| Enumeration | Description | |
|---|---|---|
 | Conditions | |
| QGroupType |
Describes the group node types
|
| RecordSet RowState |
Gets the state of a RecordSet Row object.
|