Theme
Getting Started
Why dbExpression?
Up and Running in 10 Minutes
Sync and Async Execution
ASP.NET
Dependency Injection
Supported Versions
Core Concepts
Basic Queries
Select Statements
Insert Statements
Update Statements
Delete Statements
Joins
Order By
Group By
Having
In
Top
Like
Offset and Limit (Pagination)
Union and Union All
Advanced Queries
Database Functions
Arithmetic
Subqueries
Views
Null Handling
Enums
Multiple Schemas
Multiple Databases
Aliasing
Column Aliasing
Table Aliasing
Subquery Aliasing
Element Composition Aliasing
Filter Expressions
Comparison Expressions
Logical Expressions
Filter Expressions
Stored Procedures
Parameters
Execution
Utilities
dbex
Logging
Configuration
Scaffolding
Runtime
Enums
Query Execution
Factories and Services
Execution Pipelines
Execute a Query
Connections
Transactions
Pipeline Events
Reference
Syntax Conventions
Elements
Execute
ExecuteAsync
ExecuteAsyncEnumerable
Configuration
Scaffolding
General Options
Object Overrides
Enums
Language Features
Runtime
Query Expressions
Statement Builders
Element Appenders
Value Converters
Entity Factories
Entity Mapping
Parameter Builders
Output Options
Connection Strings
Statement Executor
Database Connections
Execution Pipelines
Select Pipeline Events
Insert Pipeline Events
Update Pipeline Events
Delete Pipeline Events
Stored Procedure Pipeline Events
Logging
Utilities
dbex
dbex.Null
dbex.Coerce
dbex.Alias
dbex.GetDefaultMappingFor
dbex.SelectAllFor
dbex.BuildAssignmentsFor
Functions
Mathematical
Abs
ACos
ASin
ATan
Ceiling
Cos
Cot
Exp
Floor
Log
Rand
Round
Sin
Sqrt
Square
Tan
Aggregate
Avg
Count
Max
Min
StDev
StDevP
Sum
Var
VarP
Conversion
Cast
Date and Time
Current_Timestamp
DateAdd
DateDiff
DatePart
GetDate
GetUtcDate
SysDateTime
SysDateTimeOffset
SysUtcDateTime
String
CharIndex
Concat
Left
Len
LTrim
PatIndex
Replace
Right
RTrim
Substring
Soundex
Trim
Expressions
Coalesce
IsNull
System
NewId
Operators
Logical
In
Like
Reference > Utilities
dbExpression - read the docs
Previous
←
Logging
Next
dbex
→
