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.

{: .important }

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)