Database Functions

Database functions can be used in building queries by using fx. If you're using dbExpression in static mode, fx is a property of the db database accessor (or the name of the database accessor if it was overridden in scaffolding configuration). If you're using dbExpression with dependency injection, fx is a property of the instance (representing the database accessor) injected into your service.

When using dbExpression in static mode:

public string GetSomeValue()
{
    return db.SelectOne(
            db.fx.Cast(dbo.Person.Id).AsVarChar(20)
        )
        .From(dbo.Person)
        .Execute();
}

When using dbExpression with dependency injection:

...

private readonly MyDatabase _myDb;
public SomeService(MyDatabase myDb)
{
    _myDb = myDb;
}

public string GetSomeValue()
{
    return _myDb.SelectOne(
            _myDb.fx.Cast(dbo.Person.Id).AsVarChar(20)
        )
        .From(dbo.Person)
        .Execute();
}

Supported Functions

dbExpression supports many of the native SQL functions provided by Microsoft SQL Server. The following tables list all of the functions dbExpression supports, grouped by general category.

Mathematical

Aggregate

Conversion

Date and Time

String

Expressions

System