Microsoft. NET Pet Shop 4.0 learning Tour (1)-database field type and real-layer (model) Data Structure

Microsoft. NET Pet Shop 4.0 learning Tour (1)-database field type and real-layer (model) Data Structure

1. lists the types of all fields in the pet shop 4.0 database.
2. lists the corresponding data structures in the model of pet shop 4.0.
3. Sort out the corresponding relationship graph.

. Net Pet Shop 4.0
Column	Datatype	Length	Allow null		C # model datatype
Orderid	Int	4			Int
Itemid	Varchar	10			String
Eventid	Char	32			String
Message	Nvarchar	1024	V		String
Details	Ntext	16	V		String
Orderdate	Datetime	8			Datetime
Unitprice	Decimal	9 (10, 2)			Decimal
Isanoymous	Bit	1			Bool
Roleid	Uniqueidentifier	16			?
Propertyvaluesbinary	Image	6000			?

Summary:
The design of the database, and the structure of the actual layer will give priority to the above types.
Key data structures: int, String, datetime, decimal, bool.

Note! In blogCommunityOther than reprinted, must note:
By Clark Chan
And Source: http://clarkchan.cnblogs.com/
Otherwise, reprint is declined!

//////////////////////////////////////// //////////////////////////////////////// //////////////////////////////////////