PostgreSqlFunctions Class

Set of extension methods to be used in Linq for various query fragments.

Inheritance Hierarchy

SystemObject
SD.LLBLGen.Pro.DQE.PostgreSqlPostgreSqlFunctions

Namespace: SD.LLBLGen.Pro.DQE.PostgreSql
Assembly: SD.LLBLGen.Pro.DQE.PostgreSql (in SD.LLBLGen.Pro.DQE.PostgreSql.dll) Version: 5.9.0.0 (5.9.0)

Syntax

Copy

public static class PostgreSqlFunctions

<ExtensionAttribute>
Public NotInheritable Class PostgreSqlFunctions

Methods

	Name	Description
	AllILike(String, String)	Will generate a toCompare ILIKE ALL(likePatternArray) fragment in the SQL query using the mapping of this function.
	AllILike(IEntityFieldCore, String)	Will generate a stringField ILIKE ALL(likePatternArray) fragment in the SQL query using the mapping of this function.
	AllLike(String, String)	Will generate a toCompareWith LIKE ALL(likePatternArray) fragment in the SQL query using the mapping of this function.
	AllLike(IEntityFieldCore, String)	Will generate a stringField LIKE ALL(likePatternArray) fragment in the SQL query using the mapping of this function.
	AnyGreaterEqualThanT(T, T)	Will generate a toCompareWith <= ANY(arrayValue) fragment in the SQL query using the mapping of this function.
	AnyGreaterEqualThanT(IEntityFieldCore, T)	Will generate a toCompareWith <= ANY(arrayField) fragment in the SQL query using the mapping of this function.
	AnyGreaterThanT(T, T)	Will generate a toCompareWith < ANY(arrayValue) fragment in the SQL query using the mapping of this function.
	AnyGreaterThanT(IEntityFieldCore, T)	Will generate a toCompareWith < ANY(arrayField) fragment in the SQL query using the mapping of this function.
	AnyILike(String, String)	Will generate a toCompare ILIKE ANY(likePatternArray) fragment in the SQL query using the mapping of this function.
	AnyILike(IEntityFieldCore, String)	Will generate a stringField ILIKE ANY(likePatternArray) fragment in the SQL query using the mapping of this function.
	AnyLesserEqualThanT(T, T)	Will generate a toCompareWith >= ANY(arrayValue) fragment in the SQL query using the mapping of this function.
	AnyLesserEqualThanT(IEntityFieldCore, T)	Will generate a toCompareWith >= ANY(arrayField) fragment in the SQL query using the mapping of this function.
	AnyLesserThanT(T, T)	Will generate a toCompareWith > ANY(arrayValue) fragment in the SQL query using the mapping of this function.
	AnyLesserThanT(IEntityFieldCore, T)	Will generate a toCompareWith > ANY(arrayField) fragment in the SQL query using the mapping of this function.
	AnyLike(String, String)	Will generate a toCompare LIKE ANY(likePatternArray) fragment in the SQL query using the mapping of this function.
	AnyLike(IEntityFieldCore, String)	Will generate a stringField LIKE ANY(likePatternArray) fragment in the SQL query using the mapping of this function.
	IsContainedBy(IEntityFieldCore, Object)	Will generate a arrayField <@ containingArray fragment in the SQL query using the mapping of this function.
	IsContainedByT(T, T)	Will generate a containedArray <@ containingArray fragment in the SQL query using the mapping of this function.
	IsOverlappedBy(IEntityFieldCore, Object)	Will generate an arrayField && array2 fragment in the SQL query using the mapping of this function. Returns true if the arrays share at least one common element
	IsOverlappedByT(T, T)	Will generate an array1 && array2 fragment in the SQL query using the mapping of this function. Returns true if the arrays share at least one common element

Top

Reference

SD.LLBLGen.Pro.DQE.PostgreSql Namespace