Operations (Core)
These are the provider-agnostic CRUD and aggregate operations available on every supported RDBMS. They cover fetching data (Query, QueryAll, BatchQuery, QueryMultiple), writing data (Insert, InsertAll, Update, UpdateAll, Merge, MergeAll, Delete, DeleteAll), row/table introspection (Count, CountAll, Exists, Truncate), aggregation (Average, AverageAll, Max, MaxAll, Min, MinAll, Sum, SumAll), and raw-SQL execution (ExecuteQuery, ExecuteQueryMultiple, ExecuteReader, ExecuteNonQuery, ExecuteScalar). Each operation has both a synchronous and an Async counterpart.
Table of contents
- Average
- AverageAll
- BatchQuery
- Count
- CountAll
- Delete
- DeleteAll
- ExecuteNonQuery
- ExecuteQuery
- ExecuteQueryMultiple
- ExecuteReader
- ExecuteScalar
- Exists
- Insert
- InsertAll
- Max
- MaxAll
- Merge
- MergeAll
- Min
- MinAll
- Query
- QueryAll
- QueryMultiple
- Sum
- SumAll
- Truncate
- Update
- UpdateAll