Sphyrnidae.Common.DynamicSql.Enums Namespace Reference

Enumerations
enum class	Aggregate {   Sum , Avg , Min , Max ,   Count }
	Aggregation types More...
enum class	CompareOperator {   Equals , NotEquals , GreaterThan , LessThan ,   GreaterThanOrEqual , LessThanOrEqual , Contains , NotContains ,   BeginsWith , EndsWith , In , DateOffset ,   DateRange }
	For a condition, how the left side compares to the right side More...
enum class	ConditionJoin { And , Or }
	How will multiple conditions be joined together More...
enum class	JoinType { Inner , Left , Right , Full }
	Type of table join condition More...
enum class	OrderDirection { None , Asc , Desc }
	Ordering direction for a column More...
enum class	SqlType { SqlServer , MySql }
	What type of SQL should be built More...

Enumeration Type Documentation

Aggregate

enum Sphyrnidae.Common.DynamicSql.Enums.Aggregate

strong

Aggregation types

Enumerator
Sum	Sum
Avg	Average
Min	Minimum
Max	Maximum
Count	Count of

CompareOperator

enum Sphyrnidae.Common.DynamicSql.Enums.CompareOperator

strong

For a condition, how the left side compares to the right side

Enumerator
Equals	=
NotEquals	<>
GreaterThan	>
LessThan	<
GreaterThanOrEqual	>=
LessThanOrEqual	<=
Contains	LIKE %{item}%
NotContains	NOT LIKE %{item}%
BeginsWith	LIKE {item}%
EndsWith	LIKE %{item}
In	IN ({list})
DateOffset	BETWEEN now() AND offset()
DateRange	BETWEEN date1 AND date2

ConditionJoin

enum Sphyrnidae.Common.DynamicSql.Enums.ConditionJoin

strong

How will multiple conditions be joined together

Enumerator
And	AND
Or	OR

JoinType

enum Sphyrnidae.Common.DynamicSql.Enums.JoinType

strong

Type of table join condition

Enumerator
Inner	INNER JOIN
Left	LEFT OUTER JOIN
Right	RIGHT OUTER JOIN
Full	FULL OUTER JOIN

OrderDirection

enum Sphyrnidae.Common.DynamicSql.Enums.OrderDirection

strong

Ordering direction for a column

Enumerator
None	No ordering
Asc	ORDER BY ASC
Desc	ORDER BY DESC

SqlType

enum Sphyrnidae.Common.DynamicSql.Enums.SqlType

strong

What type of SQL should be built

Enumerator
SqlServer	T-SQL (SQL Server)
MySql	MySQL