LenQueryField

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

This functional query field is only supported for the SQL Server data provider.

Usability

var where = new LenQueryField("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 LEN function.

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