Link Search Menu Expand Document


An extended query field class that is being used to define a query expression for the SQL statement using the LENGTH function. It inherits the QueryField object.

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


Below is a sample code on how to use this class.

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

The result would contain all the records where the lenght of the Column is equals 3.


The GetString() method returns a command text that utilizes the LENGTH function.

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