_employees.cs

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

			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(EmployeesSchema.Title.FieldName);
			    else
			        this.Title = base.SetStringAsString(EmployeesSchema.Title.FieldName, value);
			}
		}
		public virtual string s_TitleOfCourtesy
		{
			get
			{
			    return this.IsColumnNull(EmployeesSchema.TitleOfCourtesy.FieldName) ? string.Empty : base.GetStringAsString(EmployeesSchema.TitleOfCourtesy.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(EmployeesSchema.TitleOfCourtesy.FieldName);
			    else
			        this.TitleOfCourtesy = base.SetStringAsString(EmployeesSchema.TitleOfCourtesy.FieldName, value);
			}
		}
		public virtual string s_BirthDate
		{
			get
			{
			    return this.IsColumnNull(EmployeesSchema.BirthDate.FieldName) ? string.Empty : base.GetDateTimeAsString(EmployeesSchema.BirthDate.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(EmployeesSchema.BirthDate.FieldName);
			    else
			        this.BirthDate = base.SetDateTimeAsString(EmployeesSchema.BirthDate.FieldName, value);
			}
		}
		public virtual string s_HireDate
		{
			get
			{
			    return this.IsColumnNull(EmployeesSchema.HireDate.FieldName) ? string.Empty : base.GetDateTimeAsString(EmployeesSchema.HireDate.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(EmployeesSchema.HireDate.FieldName);
			    else
			        this.HireDate = base.SetDateTimeAsString(EmployeesSchema.HireDate.FieldName, value);
			}
		}
		public virtual string s_Address
		{
			get
			{
			    return this.IsColumnNull(EmployeesSchema.Address.FieldName) ? string.Empty : base.GetStringAsString(EmployeesSchema.Address.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(EmployeesSchema.Address.FieldName);
			    else
			        this.Address = base.SetStringAsString(EmployeesSchema.Address.FieldName, value);
			}
		}
		public virtual string s_City
		{
			get
			{
			    return this.IsColumnNull(EmployeesSchema.City.FieldName) ? string.Empty : base.GetStringAsString(EmployeesSchema.City.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(EmployeesSchema.City.FieldName);
			    else
			        this.City = base.SetStringAsString(EmployeesSchema.City.FieldName, value);
			}
		}
		public virtual string s_Region
		{
			get
			{
			    return this.IsColumnNull(EmployeesSchema.Region.FieldName) ? string.Empty : base.GetStringAsString(EmployeesSchema.Region.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(EmployeesSchema.Region.FieldName);
			    else
			        this.Region = base.SetStringAsString(EmployeesSchema.Region.FieldName, value);
			}
		}
		public virtual string s_PostalCode
		{
			get
			{
			    return this.IsColumnNull(EmployeesSchema.PostalCode.FieldName) ? string.Empty : base.GetStringAsString(EmployeesSchema.PostalCode.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(EmployeesSchema.PostalCode.FieldName);
			    else
			        this.PostalCode = base.SetStringAsString(EmployeesSchema.PostalCode.FieldName, value);
			}
		}
		public virtual string s_Country
		{
			get
			{
			    return this.IsColumnNull(EmployeesSchema.Country.FieldName) ? string.Empty : base.GetStringAsString(EmployeesSchema.Country.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(EmployeesSchema.Country.FieldName);
			    else
			        this.Country = base.SetStringAsString(EmployeesSchema.Country.FieldName, value);
			}
		}
		public virtual string s_HomePhone
		{
			get
			{
			    return this.IsColumnNull(EmployeesSchema.HomePhone.FieldName) ? string.Empty : base.GetStringAsString(EmployeesSchema.HomePhone.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(EmployeesSchema.HomePhone.FieldName);
			    else
			        this.HomePhone = base.SetStringAsString(EmployeesSchema.HomePhone.FieldName, value);
			}
		}
		public virtual string s_Extension
		{
			get
			{
			    return this.IsColumnNull(EmployeesSchema.Extension.FieldName) ? string.Empty : base.GetStringAsString(EmployeesSchema.Extension.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(EmployeesSchema.Extension.FieldName);
			    else
			        this.Extension = base.SetStringAsString(EmployeesSchema.Extension.FieldName, value);
			}
		}
		public virtual string s_Notes
		{
			get
			{
			    return this.IsColumnNull(EmployeesSchema.Notes.FieldName) ? string.Empty : base.GetStringAsString(EmployeesSchema.Notes.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(EmployeesSchema.Notes.FieldName);
			    else
			        this.Notes = base.SetStringAsString(EmployeesSchema.Notes.FieldName, value);
			}
		}
		public virtual string s_ReportsTo
		{
			get
			{
			    return this.IsColumnNull(EmployeesSchema.ReportsTo.FieldName) ? string.Empty : base.GetIntegerAsString(EmployeesSchema.ReportsTo.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(EmployeesSchema.ReportsTo.FieldName);
			    else
			        this.ReportsTo = base.SetIntegerAsString(EmployeesSchema.ReportsTo.FieldName, value);
			}
		}
		public virtual string s_PhotoPath
		{
			get
			{
			    return this.IsColumnNull(EmployeesSchema.PhotoPath.FieldName) ? string.Empty : base.GetStringAsString(EmployeesSchema.PhotoPath.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(EmployeesSchema.PhotoPath.FieldName);
			    else
			        this.PhotoPath = base.SetStringAsString(EmployeesSchema.PhotoPath.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 EmployeeID
				{
					get
					{
							WhereParameter wp = new WhereParameter(EmployeesSchema.EmployeeID);
							this._clause._entity.Query.AddWhereParameter(wp);
							return wp;
					}
				}

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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


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

			public WhereParameter LastName
		    {
				get
		        {
					if(_LastName_W == null)
	        	    {
						_LastName_W = TearOff.LastName;
					}
					return _LastName_W;
				}
			}

			public WhereParameter FirstName
		    {
				get
		        {
					if(_FirstName_W == null)
	        	    {
						_FirstName_W = TearOff.FirstName;
					}
					return _FirstName_W;
				}
			}

			public WhereParameter Title
		    {
				get
		        {
					if(_Title_W == null)
	        	    {
						_Title_W = TearOff.Title;
					}
					return _Title_W;
				}
			}

			public WhereParameter TitleOfCourtesy
		    {
				get
		        {
					if(_TitleOfCourtesy_W == null)
	        	    {
						_TitleOfCourtesy_W = TearOff.TitleOfCourtesy;
					}
					return _TitleOfCourtesy_W;
				}
			}

			public WhereParameter BirthDate
		    {
				get
		        {
					if(_BirthDate_W == null)
	        	    {
						_BirthDate_W = TearOff.BirthDate;
					}
					return _BirthDate_W;
				}
			}

			public WhereParameter HireDate
		    {
				get
		        {
					if(_HireDate_W == null)
	        	    {
						_HireDate_W = TearOff.HireDate;
					}
					return _HireDate_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;
				}
			}

			public WhereParameter Country
		    {
				get
		        {
					if(_Country_W == null)
	        	    {
						_Country_W = TearOff.Country;
					}
					return _Country_W;
				}
			}

			public WhereParameter HomePhone
		    {
				get
		        {
					if(_HomePhone_W == null)
	        	    {
						_HomePhone_W = TearOff.HomePhone;
					}
					return _HomePhone_W;
				}
			}

			public WhereParameter Extension
		    {
				get
		        {
					if(_Extension_W == null)
	        	    {
						_Extension_W = TearOff.Extension;
					}
					return _Extension_W;
				}
			}

			public WhereParameter Photo
		    {
				get
		        {
					if(_Photo_W == null)
	        	    {
						_Photo_W = TearOff.Photo;
					}
					return _Photo_W;
				}
			}

			public WhereParameter Notes
		    {
				get
		        {
					if(_Notes_W == null)
	        	    {