Daniel Flower Dot Com Banner

Available Data Types

The actual data types allowed with their corresponding SQL Server types, and types to signify "null" (note that .NET primitive types such as integers cannot be  null, yet it is useful to be able to specify a number is null, meaning, for example, "not applicable") are shown below:

 .NET Type
SQL Server Type
Null Value Notes
string nvarchar  ""  This is applicable to single-line strings.  The length of the column is equal to the max length specified on the DBColumn. Note that Shunde cannot distinguish between null and an empty string.
string ntext ""  When no maximum length is specified on the DBColumn it becomes an ntext column which can hold vast amounts of text.
bool
bit
n/a
There is no way to represent a null boolean in Shunde
short
smallint
DBColumn.ShortNullValue
 
int
int
DBColumn.IntNullValue
 
long
bigint
DBColumn.LongNullValue
 
float
float(24)
DBColumn.FloatNullValue
 
double
float(53) DBColumn.DoubleNullValue  
DateTime
DateTime
DBColumn.DateTimeNullValue
 
BinaryData
image
BinaryData.Exists == false
A Shunde.Framework.BinaryData structure contains an array of bytes, a mime type, and filename.  Therefore, a single BinaryData field gets mapped to 3 columns in the database.
DBObject
int
null
A class extending DBObject gets translated to the field name with "Id" appended to it, and it becomes a foreign key to the table of the type of object it is pointing to.  The full .NET type is also recorded to identify the type of object without having to check in the DBObject table.  For example, if "owner" is a field of type "MyNamespace.Person" in the "Car" table, then "ownerId" will point to the "id" column in the "Person" table, and "ownerClassName" will be "MyNamespace.Person".

 

 
 
 
Comments for this page
GSycmZtvhB
posted by Silvana on 1/10/2012 12:23:29 p.m. (NZ time)
Collectible show bus Beautiful Asian partner who I spoke to over the bus going with the Antique show. I extpeecd that many of us would have intersected paths again i looking for a man nside to go the talk and hopefully We would get your telephone number. Bad plan with my part. I didn't find that opportunity again and I regret not understanding you. It might be amazing if y swinger site ou actually read this plus gave me another possibility to meet you. Whores in Minot Kheurbet El Barh, Ivanishchevskoye, Kampung Sejirin lonely rich women search dating black men
Add your comment below
 
Your Name:
Comment Title:
Comment: