Gazel.System

Gazel Value Types

Gazel.System introduces new value types to be used just like the value types in System namespace.

Value Type Database Column Service Format UI
AppToken [Property_Name](nvarchar(255)) string(Guid, Hash, Text)
Binary [Property_Name](varbinary(max)) string (Base64)
CardNumber [Property_Name](nvarchar(255)) string ("########"), ("#### ####"), ("################"), ("#### #### #### ####")
CodeContent [Property_Name](text) string
CountryCode [Property_Name](nvarchar(255)) string ("__")
CreditCardNumber [Property_Name](nvarchar(255)) string ("###############"), ("#### #### #### ###"), ("################"), ("#### #### #### ####")
CurrencyCode [Property_Name](nvarchar(255)) string ("___")
Date [Property_Name](datetime) string ("yyyyMMdd")
DateRange [Property_Name]Start(datetime), [Property_Name]End(datetime) string ("yyyyMMdd-yyyyMMdd")
DateTimeRange [Property_Name]Start(datetime), [Property_Name]End(datetime) string ("yyyyMMddHHmmss-yyyyMMddHHmmss")
Email [Property_Name](nvarchar(255)) string("___@__")
EncryptedString [Property_Name](nvarchar(344)) string
Geoloc [Property_Name]Latitude(float), [Property_Name]Longitude(float) string ("##.#######, ##.#######")
Iban [Property_Name](nvarchar(255)) char(26)
MimeType [Property_Name](nvarchar(255)) string
Money [Property_Name]Value(decimal(19,5)), [Property_Name]Currency(nvarchar(255)) string ("(-)###.#####___"), ("(-)###.#####"), ("(-)######___"), ("(-)#######")
MoneyRange [Property_Name]StartValue(decimal(19,5)), [Property_Name]EndValue(decimal(19,5)),[Property_Name]Currency(nvarchar(255)) string ("<MoneyFormat>-<MoneyFormat>")
Password [Property_Name](nvarchar(255)) string
Rate [Property_Name](float) string ("###.######")
Tckn [Property_Name](nvarchar(255)) string ("###########")
Time [Property_Name](bigint) string ("hhmmss")
TimeRange [Property_Name]Start(bigint),[Property_Name]End(bigint) string ("hhmmss-hhmmss")
Timestamp [Property_Name](datetime) string ("yyyyMMddHHmmssfff")
TriState [Property_Name](bit) string ("notdefined", "true", "false")
Vkn [Property_Name](nvarchar(255)) string ("##########")
VknOrTckn [Property_Name](nvarchar(255)) string ("##########" ya da "###########")

.Net Value Types

Below are the supported value types for service and database mapping.

Value Type Database Column Service Format UI
bool [Property_Name](bit)
byte [Property_Name](tynint)
char [Property_Name](nchar)
Datetime [Property_Name](datetime)
decimal [Property_Adi](decimal(19,5))
double [Property_Name](float)
enum [Property_Name](int)
float [Property_Name](real)
int [Property_Name](int)
long [Property_Name](bigint)
short [Property_Name](smallint)
string [Property_Name](nvarchar)
Timespan [Property_Name](bigint)