Queries

Dashing attempts to provide an intuitive api for performing most of the common sql functions that you'd expect to be able to perform i.e. selecting data as objects from the database, updating or deleting that data, inserting new data. We like to think of Dashing as a tool for quickly performing sql functions, as opposed to a complete abstraction of the database, and as such you can also perform bulk updates to your database.

The following sections detail how to perform the various functions:

• Sessions - how to set up a connection to the database
• Getting data out - how to SELECT data
• Saving and deleting entities - how to INSERT, UPDATE, DELETE
• Fetching associations - how to eagerly load related entities
• Bulk queries - how to perform bulk updates/deletes
• Dapper - how to revert to using Dapper
• Async/sync support - async and sync apis
• Performance - how does Dashing perform?