_customers.cs

EasyObjects 是ORM的典型应用的例子是学习研究的很好的范例

			set
			{
				this.SetString(CustomersSchema.Phone.FieldName, value);
			}
		}
		public virtual string Fax
		{
			get
			{
				return this.GetString(CustomersSchema.Fax.FieldName);
	    	}
			set
			{
				this.SetString(CustomersSchema.Fax.FieldName, value);
			}
		}

		public override string TableName
		{
			get { return "Customers"; }
		}
		
		#endregion		
		
		#region String Properties
		public virtual string s_CustomerID
		{
			get
			{
			    return this.IsColumnNull(CustomersSchema.CustomerID.FieldName) ? string.Empty : base.GetStringAsString(CustomersSchema.CustomerID.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(CustomersSchema.CustomerID.FieldName);
			    else
			        this.CustomerID = base.SetStringAsString(CustomersSchema.CustomerID.FieldName, value);
			}
		}
		public virtual string s_CompanyName
		{
			get
			{
			    return this.IsColumnNull(CustomersSchema.CompanyName.FieldName) ? string.Empty : base.GetStringAsString(CustomersSchema.CompanyName.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(CustomersSchema.CompanyName.FieldName);
			    else
			        this.CompanyName = base.SetStringAsString(CustomersSchema.CompanyName.FieldName, value);
			}
		}
		public virtual string s_ContactName
		{
			get
			{
			    return this.IsColumnNull(CustomersSchema.ContactName.FieldName) ? string.Empty : base.GetStringAsString(CustomersSchema.ContactName.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(CustomersSchema.ContactName.FieldName);
			    else
			        this.ContactName = base.SetStringAsString(CustomersSchema.ContactName.FieldName, value);
			}
		}
		public virtual string s_ContactTitle
		{
			get
			{
			    return this.IsColumnNull(CustomersSchema.ContactTitle.FieldName) ? string.Empty : base.GetStringAsString(CustomersSchema.ContactTitle.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(CustomersSchema.ContactTitle.FieldName);
			    else
			        this.ContactTitle = base.SetStringAsString(CustomersSchema.ContactTitle.FieldName, value);
			}
		}
		public virtual string s_Address
		{
			get
			{
			    return this.IsColumnNull(CustomersSchema.Address.FieldName) ? string.Empty : base.GetStringAsString(CustomersSchema.Address.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(CustomersSchema.Address.FieldName);
			    else
			        this.Address = base.SetStringAsString(CustomersSchema.Address.FieldName, value);
			}
		}
		public virtual string s_City
		{
			get
			{
			    return this.IsColumnNull(CustomersSchema.City.FieldName) ? string.Empty : base.GetStringAsString(CustomersSchema.City.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(CustomersSchema.City.FieldName);
			    else
			        this.City = base.SetStringAsString(CustomersSchema.City.FieldName, value);
			}
		}
		public virtual string s_Region
		{
			get
			{
			    return this.IsColumnNull(CustomersSchema.Region.FieldName) ? string.Empty : base.GetStringAsString(CustomersSchema.Region.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(CustomersSchema.Region.FieldName);
			    else
			        this.Region = base.SetStringAsString(CustomersSchema.Region.FieldName, value);
			}
		}
		public virtual string s_PostalCode
		{
			get
			{
			    return this.IsColumnNull(CustomersSchema.PostalCode.FieldName) ? string.Empty : base.GetStringAsString(CustomersSchema.PostalCode.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(CustomersSchema.PostalCode.FieldName);
			    else
			        this.PostalCode = base.SetStringAsString(CustomersSchema.PostalCode.FieldName, value);
			}
		}
		public virtual string s_Country
		{
			get
			{
			    return this.IsColumnNull(CustomersSchema.Country.FieldName) ? string.Empty : base.GetStringAsString(CustomersSchema.Country.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(CustomersSchema.Country.FieldName);
			    else
			        this.Country = base.SetStringAsString(CustomersSchema.Country.FieldName, value);
			}
		}
		public virtual string s_Phone
		{
			get
			{
			    return this.IsColumnNull(CustomersSchema.Phone.FieldName) ? string.Empty : base.GetStringAsString(CustomersSchema.Phone.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(CustomersSchema.Phone.FieldName);
			    else
			        this.Phone = base.SetStringAsString(CustomersSchema.Phone.FieldName, value);
			}
		}
		public virtual string s_Fax
		{
			get
			{
			    return this.IsColumnNull(CustomersSchema.Fax.FieldName) ? string.Empty : base.GetStringAsString(CustomersSchema.Fax.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(CustomersSchema.Fax.FieldName);
			    else
			        this.Fax = base.SetStringAsString(CustomersSchema.Fax.FieldName, value);
			}
		}
		#endregion		
	
		#region Where Clause
		public class WhereClause
		{
			public WhereClause(EasyObject entity)
			{
				this._entity = entity;
			}
			
			public TearOffWhereParameter TearOff
			{
				get
				{
					if(_tearOff == null)
					{
						_tearOff = new TearOffWhereParameter(this);
					}

					return _tearOff;
				}
			}

			#region TearOff's
			public class TearOffWhereParameter
			{
				public TearOffWhereParameter(WhereClause clause)
				{
					this._clause = clause;
				}
				
				
				public WhereParameter CustomerID
				{
					get
					{
							WhereParameter wp = new WhereParameter(CustomersSchema.CustomerID);
							this._clause._entity.Query.AddWhereParameter(wp);
							return wp;
					}
				}

				public WhereParameter CompanyName
				{
					get
					{
							WhereParameter wp = new WhereParameter(CustomersSchema.CompanyName);
							this._clause._entity.Query.AddWhereParameter(wp);
							return wp;
					}
				}

				public WhereParameter ContactName
				{
					get
					{
							WhereParameter wp = new WhereParameter(CustomersSchema.ContactName);
							this._clause._entity.Query.AddWhereParameter(wp);
							return wp;
					}
				}

				public WhereParameter ContactTitle
				{
					get
					{
							WhereParameter wp = new WhereParameter(CustomersSchema.ContactTitle);
							this._clause._entity.Query.AddWhereParameter(wp);
							return wp;
					}
				}

				public WhereParameter Address
				{
					get
					{
							WhereParameter wp = new WhereParameter(CustomersSchema.Address);
							this._clause._entity.Query.AddWhereParameter(wp);
							return wp;
					}
				}

				public WhereParameter City
				{
					get
					{
							WhereParameter wp = new WhereParameter(CustomersSchema.City);
							this._clause._entity.Query.AddWhereParameter(wp);
							return wp;
					}
				}

				public WhereParameter Region
				{
					get
					{
							WhereParameter wp = new WhereParameter(CustomersSchema.Region);
							this._clause._entity.Query.AddWhereParameter(wp);
							return wp;
					}
				}

				public WhereParameter PostalCode
				{
					get
					{
							WhereParameter wp = new WhereParameter(CustomersSchema.PostalCode);
							this._clause._entity.Query.AddWhereParameter(wp);
							return wp;
					}
				}

				public WhereParameter Country
				{
					get
					{
							WhereParameter wp = new WhereParameter(CustomersSchema.Country);
							this._clause._entity.Query.AddWhereParameter(wp);
							return wp;
					}
				}

				public WhereParameter Phone
				{
					get
					{
							WhereParameter wp = new WhereParameter(CustomersSchema.Phone);
							this._clause._entity.Query.AddWhereParameter(wp);
							return wp;
					}
				}

				public WhereParameter Fax
				{
					get
					{
							WhereParameter wp = new WhereParameter(CustomersSchema.Fax);
							this._clause._entity.Query.AddWhereParameter(wp);
							return wp;
					}
				}


				private WhereClause _clause;
			}
			#endregion
		
			public WhereParameter CustomerID
		    {
				get
		        {
					if(_CustomerID_W == null)
	        	    {
						_CustomerID_W = TearOff.CustomerID;
					}
					return _CustomerID_W;
				}
			}

			public WhereParameter CompanyName
		    {
				get
		        {
					if(_CompanyName_W == null)
	        	    {
						_CompanyName_W = TearOff.CompanyName;
					}
					return _CompanyName_W;
				}
			}

			public WhereParameter ContactName
		    {
				get
		        {
					if(_ContactName_W == null)
	        	    {
						_ContactName_W = TearOff.ContactName;
					}
					return _ContactName_W;
				}
			}

			public WhereParameter ContactTitle
		    {
				get
		        {
					if(_ContactTitle_W == null)
	        	    {
						_ContactTitle_W = TearOff.ContactTitle;
					}
					return _ContactTitle_W;
				}
			}

			public WhereParameter Address
		    {
				get
		        {
					if(_Address_W == null)
	        	    {
						_Address_W = TearOff.Address;
					}
					return _Address_W;
				}
			}

			public WhereParameter City
		    {
				get
		        {
					if(_City_W == null)
	        	    {
						_City_W = TearOff.City;
					}
					return _City_W;
				}
			}

			public WhereParameter Region
		    {
				get
		        {
					if(_Region_W == null)
	        	    {
						_Region_W = TearOff.Region;
					}
					return _Region_W;
				}
			}

			public WhereParameter PostalCode
		    {
				get
		        {
					if(_PostalCode_W == null)
	        	    {
						_PostalCode_W = TearOff.PostalCode;
					}
					return _PostalCode_W;
				}