Introduce support for some DB functions. See CargoPostEvaluationTranslator and CargoTests for supported functions and how to call them with C# Expressions.
UPPER ("string".ToUpper())
LOWER ("string".ToLower())
TRIM ("string".Trim())
INSTR & LOCATE ("string".Contains(), "string".IndexOf()) (Not supported by Cargo by default)
SUBSTRING ("string".Substring())
LEN ("string".Length) (Not supported by Cargo by default)
NOW (DateTime.Now, DateTimeOffset.Now)
YEAR, MONTH, DAY, DATE (dt.Year, dt.Month, dt.Day, dt.Date)
Follow-up on #77
CargoPostEvaluationTranslator
andCargoTests
for supported functions and how to call them with C# Expressions.UPPER
("string".ToUpper()
)LOWER
("string".ToLower()
)TRIM
("string".Trim()
)INSTR
&LOCATE
("string".Contains()
,"string".IndexOf()
) (Not supported by Cargo by default)SUBSTRING
("string".Substring()
)LEN
("string".Length
) (Not supported by Cargo by default)NOW
(DateTime.Now
,DateTimeOffset.Now
)YEAR
,MONTH
,DAY
,DATE
(dt.Year
,dt.Month
,dt.Day
,dt.Date
)DATE_ADD
,DATE_SUB
(dt + timespan
,dt.Add(timespan)
,dt - timespan
,dt.Subtract(timespan)
)LIKE
(CargoFunctions.Like
)HOLDS
(CargoFunctions.Holds
)HOLDS LIKE
(CargoFunctions.HoldsLike
)FLOOR
,CEIL
,POWER
,LOG
,ROUND
(Math.Floor
,Math.Ceiling
,Math.Pow
,Math.Exp
,Math.Log
,Math.Round
)ICollection<T>
property in data model.Nullable<T>
orT?
).CargoListAttribute
to customize the list behavior.CargoQueryContext.PaginationSize
for adjusting internal pagination size when requesting a long sequence of record set from MediaWiki server.