LengthQueryField

An extended query field class for defining SQL expressions using the LENGTH function. Inherits QueryField.

This functional query field is only supported for PostgreSQL, MySQL, and SQLite data providers.

Usability

var where = new LengthQueryField("Column", 3);
var result = connection.Query<Entity>(where);

The result contains all records where the length of Column equals 3.

GetString

The GetString() method returns the command text using the LENGTH function.

var where = new LengthQueryField("Column", 3);
var text = where.GetString(connection.GetDbSetting()); // Returns (LENGTH([Column]) = @Column)