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
Lh zfck
posted by Aline on 22/08/2021 6:00:23 a.m. (NZ time)
Hi there

Buy medical disposable face mask to protect your loved ones from the deadly CoronaVirus. The price is $0.28 each. If interested, please visit our site: pharmacyoutlets.online

Regards,

Aline
Dxpcyoku
posted by Milagros Lamothe on 1/09/2021 11:47:04 p.m. (NZ time)
Hi from Order-Fulfillment.net

Who would I speak with at your company about any of your order fulfillment and drop shipping needs?

My company Order-Fulfillment.net can warehouse, inventory, and manage your drop shipping / order fulfillment for your customer orders.

Based in the USA for almost 2 decades, near major USA air and sea ports.

Here are some of the items we currently pick, pack and ship for clients:

-Books, training manuals, guides
-New member welcomes boxes and gifts
-Product samples
-Marketing materials
-Medical program test kits
-Follow up gifts to clients, leads, and prospects

Thank you!

Fulfillment Warehouse
Order-Fulfillment.net
Drop Shipping and Order Fulfillment Specialists since 2003
Add your comment below
 
Your Name:
Comment Title:
Comment: