/branches/v41/Source/Widgetsphere.Generator.DAL/ProjectItemGenerators/BusinessCollection/BusinessCollectionGeneratedTemplate.cs

Large files files are truncated, but you can click here to view the full file

#region Copyright (c) 2006-2011 Widgetsphere LLC, All Rights Reserved

//--------------------------------------------------------------------- *

//                          Widgetsphere  LLC                           *

//             Copyright (c) 2006-2011 All Rights reserved              *

//                                                                      *

//                                                                      *

//This file and its contents are protected by United States and         *

//International copyright laws.  Unauthorized reproduction and/or       *

//distribution of all or any portion of the code contained herein       *

//is strictly prohibited and will result in severe civil and criminal   *

//penalties.  Any violations of this copyright will be prosecuted       *

//to the fullest extent possible under law.                             *

//                                                                      *

//THE SOURCE CODE CONTAINED HEREIN AND IN RELATED FILES IS PROVIDED     *

//TO THE REGISTERED DEVELOPER FOR THE PURPOSES OF EDUCATION AND         *

//TROUBLESHOOTING. UNDER NO CIRCUMSTANCES MAY ANY PORTION OF THE SOURCE *

//CODE BE DISTRIBUTED, DISCLOSED OR OTHERWISE MADE AVAILABLE TO ANY     *

//THIRD PARTY WITHOUT THE EXPRESS WRITTEN CONSENT OF WIDGETSPHERE LLC   *

//                                                                      *

//UNDER NO CIRCUMSTANCES MAY THE SOURCE CODE BE USED IN WHOLE OR IN     *

//PART, AS THE BASIS FOR CREATING A PRODUCT THAT PROVIDES THE SAME, OR  *

//SUBSTANTIALLY THE SAME, FUNCTIONALITY AS ANY WIDGETSPHERE PRODUCT.    *

//                                                                      *

//THE REGISTERED DEVELOPER ACKNOWLEDGES THAT THIS SOURCE CODE           *

//CONTAINS VALUABLE AND PROPRIETARY TRADE SECRETS OF WIDGETSPHERE,      *

//INC.  THE REGISTERED DEVELOPER AGREES TO EXPEND EVERY EFFORT TO       *

//INSURE ITS CONFIDENTIALITY.                                           *

//                                                                      *

//THE END USER LICENSE AGREEMENT (EULA) ACCOMPANYING THE PRODUCT        *

//PERMITS THE REGISTERED DEVELOPER TO REDISTRIBUTE THE PRODUCT IN       *

//EXECUTABLE FORM ONLY IN SUPPORT OF APPLICATIONS WRITTEN USING         *

//THE PRODUCT.  IT DOES NOT PROVIDE ANY RIGHTS REGARDING THE            *

//SOURCE CODE CONTAINED HEREIN.                                         *

//                                                                      *

//THIS COPYRIGHT NOTICE MAY NOT BE REMOVED FROM THIS FILE.              *

//--------------------------------------------------------------------- *

#endregion



using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using Widgetsphere.Generator.Common.Util;

using Widgetsphere.Generator.Models;



namespace Widgetsphere.Generator.DAL.ProjectItemGenerators.BusinessCollection

{

	class BusinessCollectionGeneratedTemplate : DomainProjectTemplate

	{

		private readonly StringBuilder sb = new StringBuilder();

		private readonly Table _currentTable;



		public BusinessCollectionGeneratedTemplate(ModelRoot model, Table currentTable)

		{

			_model = model;

			_currentTable = currentTable;

		}



		#region BaseClassTemplate overrides



		public override string FileName

		{

			get { return string.Format("{0}Collection.Generated.cs", _currentTable.PascalName); }

		}



		public string ParentItemName

		{

			get { return string.Format("{0}Collection.cs", _currentTable.PascalName); }

		}



		public override string FileContent

		{

			get

			{

				GenerateContent();

				return sb.ToString();

			}

		}



		#endregion



		#region GenerateContent



		private void GenerateContent()

		{

			try

			{

				Widgetsphere.Generator.GenerationHelper.AppendCopyrightInCode(sb, _model);

				this.AppendUsingStatements();

				sb.AppendLine("namespace " + this.GetLocalNamespace() + ".Business.Objects");

				sb.AppendLine("{");

				this.AppendClass();

				this.AppendSearchClass();

				this.AppendPagingClass();

				sb.AppendLine("}");

			}

			catch (Exception ex)

			{

				throw;

			}

		}



		#endregion



		#region namespace / objects



		public void AppendUsingStatements()

		{

			sb.AppendLine("using System;");

			sb.AppendLine("using System.Data;");

			sb.AppendLine("using System.Xml;");

			sb.AppendLine("using System.Collections;");

			sb.AppendLine("using System.Runtime.Serialization;");

			sb.AppendLine("using System.ComponentModel;");

			sb.AppendLine("using " + this.GetLocalNamespace() + ".Business.Rules;");

			sb.AppendLine("using " + this.GetLocalNamespace() + ".Business.SelectCommands;");

			sb.AppendLine("using " + this.GetLocalNamespace() + ".Domain.Objects;");

			sb.AppendLine("using Widgetsphere.Core.DataAccess;");

			sb.AppendLine("using Widgetsphere.Core.Util;");

			sb.AppendLine("using Widgetsphere.Core.Logging;");

			sb.AppendLine("using Widgetsphere.Core.Exceptions;");

			sb.AppendLine("using " + this.GetLocalNamespace() + ".Business.LINQ;");

			sb.AppendLine("using System.IO;");

			sb.AppendLine("using System.Collections.Generic;");

			sb.AppendLine("using System.Linq.Expressions;");

			sb.AppendLine("using System.Data.Linq;");

			sb.AppendLine("using System.Linq;");

			sb.AppendLine("using System.Text;");

			sb.AppendLine("using Widgetsphere.Core.EventArgs;");

			sb.AppendLine("using System.Text.RegularExpressions;");

			sb.AppendLine();

		}



		private void AppendClass()

		{



			var baseClass = "Widgetsphere.Core.DataAccess.BusinessCollectionPersistableBase";

			var baseInterface = "Widgetsphere.Core.DataAccess.IPersistableBusinessCollection";



			if (_currentTable.Immutable)

			{

				baseClass = "Widgetsphere.Core.DataAccess.BusinessCollectionBase";

				baseInterface = "Widgetsphere.Core.DataAccess.IBusinessCollection";

			}



			if (_currentTable.ParentTable != null)

				baseClass = _currentTable.ParentTable.PascalName + "Collection";



			var additional40Interface = string.Empty;

			if (_model.FrameworkVersion == FrameworkVersionConstants.v40)

				additional40Interface = ", System.Collections.Specialized.INotifyCollectionChanged";



			sb.AppendLine("	/// <summary>");

			sb.AppendLine("	/// The collection to hold '" + _currentTable.PascalName + "' entities");

			StringHelper.WriteGeneratedCommentSection(1, sb, _currentTable.Description);

			sb.AppendLine("	/// </summary>");

			sb.AppendLine("	[Serializable()]");

			sb.AppendLine("	" + this.ClassScope + " partial class " + _currentTable.PascalName + "Collection : " + baseClass + ", " + baseInterface + ", System.IDisposable, System.ComponentModel.IListSource, System.Collections.IList, System.Collections.IEnumerator, System.Collections.Generic.IEnumerable<" + this.GetLocalNamespace() + ".Business.Objects." + _currentTable.PascalName + ">, Widgetsphere.Core.DataAccess.IWrappingClass" + additional40Interface);

			sb.AppendLine("	{");

			this.AppendMemberVariables();

			this.AppendConstructors();

			this.AppendProperties();

			this.AppendOperatorIndexer();

			this.AppendMethods();

			//this.AppendIListImplementation();

			this.AppendRegionIBusinessCollectionExplicit();

			//this.AppendRegionGetFilteredList();

			this.AppendRegionGetDatabaseFieldName();

			this.AppendClassEnumerator();

			this.AppendRegionSearch();

			this.AppendRegionCustomSelectByRules();

			this.AppendRegionSelectByDates();

			this.AppendRegionEnumerator();

			this.AppendInterfaces();

			this.Append40Features();



			sb.AppendLine("	}");

			sb.AppendLine();

		}



		private void AppendRegionSearch()

		{

			if (!_model.SupportLegacySearchObject)

			{

				sb.AppendLine("		#region Search Members");

				sb.AppendLine();

				sb.AppendLine("		/// <summary>");

				sb.AppendLine("		/// Creates a search object to query this collection.");

				sb.AppendLine("		/// </summary>");

				sb.AppendLine("		IBusinessObjectSearch IBusinessCollection.CreateSearchObject(SearchType searchType)");

				sb.AppendLine("		{");

				sb.AppendLine("			throw new Exception(\"This functionality is not supported because the model did not support legacy search objects.\");");

				sb.AppendLine("		}");

				sb.AppendLine();

				sb.AppendLine("		#endregion");

				sb.AppendLine();

			}

			else

			{

				sb.AppendLine("		#region Search Members");

				sb.AppendLine();

				sb.AppendLine("		/// <summary>");

				sb.AppendLine("		/// Creates a search object to query this collection.");

				sb.AppendLine("		/// </summary>");

				sb.AppendLine("		IBusinessObjectSearch IBusinessCollection.CreateSearchObject(SearchType searchType)");

				sb.AppendLine("		{");

				sb.AppendLine("			return (IBusinessObjectSearch)this.CreateSearchObject(searchType);");

				sb.AppendLine("		}");

				sb.AppendLine();

				sb.AppendLine("		/// <summary>");

				sb.AppendLine("		/// Creates a search object to query this collection.");

				sb.AppendLine("		/// </summary>");

				if (_model.Database.AllowZeroTouch)

				{

					if (_currentTable.ParentTable == null)

						sb.AppendLine("		public virtual IBusinessObjectSearch CreateSearchObject(SearchType searchType)");

					else

						sb.AppendLine("		public new IBusinessObjectSearch CreateSearchObject(SearchType searchType)");



					sb.AppendLine("		{");

					sb.AppendLine("			return null;");

					sb.AppendLine("		}");

				}

				else

				{

					if (_currentTable.ParentTable == null)

						sb.AppendLine("		public virtual " + _currentTable.PascalName + "Search CreateSearchObject(SearchType searchType)");

					else

						sb.AppendLine("		public new " + _currentTable.PascalName + "Search CreateSearchObject(SearchType searchType)");



					sb.AppendLine("		{");

					sb.AppendLine("			return new " + _currentTable.PascalName + "Search(searchType);");

					sb.AppendLine("		}");

				}

				sb.AppendLine();

				sb.AppendLine("		#endregion");

				sb.AppendLine();

			}



		}



		private void AppendRegionSelectByDates()

		{

			sb.AppendLine("		#region Select By Dates");

			sb.AppendLine();

			if (_currentTable.Generated && _currentTable.AllowCreateAudit)

			{

				sb.AppendLine("		/// <summary>");

				sb.AppendLine("		/// Select objects by their created date.");

				sb.AppendLine("		/// </summary>");

				sb.AppendLine("		/// <param name=\"startDate\">The inclusive date on which to start the search.</param>");

				sb.AppendLine("		/// <param name=\"endDate\">The inclusive date on which to end the search.</param>");

				sb.AppendLine("		/// <param name=\"modifier\">The identifier used for the create and modify audits.</param>");

				if (_currentTable.ParentTable == null)

					sb.AppendLine("		public static " + _currentTable.PascalName + "Collection SelectByCreatedDateRange(DateTime? startDate, DateTime? endDate, string modifier)");

				else

					sb.AppendLine("		public new static " + _currentTable.PascalName + "Collection SelectByCreatedDateRange(DateTime? startDate, DateTime? endDate, string modifier)");

				sb.AppendLine("		{");



				if (_model.Database.AllowZeroTouch)

				{

					//If zero-touch then use LINQ

					sb.AppendLine("			return " + _currentTable.PascalName + "Collection.RunSelect(x => ((startDate == null) || startDate <= x.CreatedDate) && ((endDate == null) || x.CreatedDate <= endDate));");

				}

				else

				{

					sb.AppendLine("			var subDomain = new SubDomain(modifier);");

					sb.AppendLine("			var selectCommand = new " + _currentTable.PascalName + "SelectByCreatedDateRange(startDate, endDate);");

					sb.AppendLine("			subDomain.AddSelectCommand(selectCommand);");

					sb.AppendLine("			subDomain.RunSelectCommands();");

					sb.AppendLine("			return subDomain.GetCollection<" + _currentTable.PascalName + "Collection>();");

				}

				sb.AppendLine("		}");

				sb.AppendLine();

			}



			if (_currentTable.Generated && _currentTable.AllowModifiedAudit)

			{

				sb.AppendLine("		/// <summary>");

				sb.AppendLine("		/// Select objects by their modified date.");

				sb.AppendLine("		/// </summary>");

				sb.AppendLine("		/// <param name=\"startDate\">The inclusive date on which to start the search.</param>");

				sb.AppendLine("		/// <param name=\"endDate\">The inclusive date on which to end the search.</param>");

				sb.AppendLine("		/// <param name=\"modifier\">The identifier used for the create and modify audits.</param>");

				if (_currentTable.ParentTable == null)

					sb.AppendLine("		public static " + _currentTable.PascalName + "Collection SelectByModifiedDateRange(DateTime? startDate, DateTime? endDate, string modifier)");

				else

					sb.AppendLine("		public new static " + _currentTable.PascalName + "Collection SelectByModifiedDateRange(DateTime? startDate, DateTime? endDate, string modifier)");

				sb.AppendLine("		{");



				if (_model.Database.AllowZeroTouch)

				{

					//If zero-touch then use LINQ

					sb.AppendLine("			return " + _currentTable.PascalName + "Collection.RunSelect(x => ((startDate == null) || startDate <= x.ModifiedDate) && ((endDate == null) || x.ModifiedDate <= endDate));");

				}

				else

				{

					sb.AppendLine("			var subDomain = new SubDomain(modifier);");

					sb.AppendLine("			var selectCommand = new " + _currentTable.PascalName + "SelectByModifiedDateRange(startDate, endDate);");

					sb.AppendLine("			subDomain.AddSelectCommand(selectCommand);");

					sb.AppendLine("			subDomain.RunSelectCommands();");

					sb.AppendLine("			return subDomain.GetCollection<" + _currentTable.PascalName + "Collection>();");

				}

				sb.AppendLine("		}");

				sb.AppendLine();

			}



			sb.AppendLine("		#endregion");

			sb.AppendLine();

		}



		private void AppendRegionCustomSelectByRules()

		{

			if (_model.Database.AllowZeroTouch) return;



			if (_currentTable.CustomRetrieveRules.Count == 0)

				return;



			sb.AppendLine("		#region CustomSelectBy CustomRules");

			sb.AppendLine();



			//Create a method for all custom retrieve rules

			foreach (Reference reference in _currentTable.CustomRetrieveRules)

			{

				var rule = (CustomRetrieveRule)reference.Object;

				if (rule.Generated)

				{

					#region Overload

					sb.AppendLine("		/// <summary>");

					sb.AppendLine("		/// Select rows based on the '" + rule.PascalName + "' custom retrieve rule for the '" + _currentTable.DatabaseName + "' table.");

					sb.AppendLine("		/// </summary>");

					sb.Append("		public static " + _currentTable.PascalName + "Collection SelectBy" + rule.PascalName + "(");

					if (rule.UseSearchObject)

					{

						sb.Append(_currentTable.PascalName + "Search " + _currentTable.CamelName);

						if (rule.Parameters.Count > 0)

							sb.Append(", ");

					}



					foreach (var parameter in rule.GeneratedParameters)

					{

						if (parameter.IsOutputParameter)

							sb.Append("out ");

						sb.Append(parameter.GetCodeType() + " " + parameter.CamelName);

						if (rule.GeneratedParameters.IndexOf(parameter) < rule.GeneratedParameters.Count() - 1)

							sb.Append(", ");

					}

					sb.AppendLine(")");

					sb.AppendLine("		{");

					sb.Append("			return SelectBy" + rule.PascalName + "(");



					if (rule.UseSearchObject)

					{

						sb.Append(_currentTable.CamelName);

						if (rule.Parameters.Count > 0)

							sb.Append(", ");

					}

					foreach (var parameter in rule.GeneratedParameters)

					{

						if (parameter.IsOutputParameter)

							sb.Append("out ");

						sb.Append(parameter.CamelName + ", ");

					}



					sb.AppendLine("string.Empty);");

					sb.AppendLine("		}");

					sb.AppendLine();

					#endregion



					sb.AppendLine("		/// <summary>");

					sb.AppendLine("		/// Select rows based on the '" + rule.PascalName + "' custom retrieve rule for the '" + _currentTable.DatabaseName + "' table.");

					sb.AppendLine("		/// </summary>");

					sb.Append("		public static " + _currentTable.PascalName + "Collection SelectBy" + rule.PascalName + "(");

					if (rule.UseSearchObject)

					{

						sb.Append(_currentTable.PascalName + "Search " + _currentTable.CamelName);

						if (rule.Parameters.Count > 0)

							sb.Append(", ");

					}

					foreach (var parameter in rule.GeneratedParameters)

					{						

						if (parameter.IsOutputParameter)

							sb.Append("out ");

						sb.Append(parameter.GetCodeType() + " " + parameter.CamelName + ", ");

					}

					sb.AppendLine("string modifier)");



					sb.AppendLine("		{");

					sb.AppendLine("			var subDomain = new SubDomain(modifier);");

					sb.Append("			var selectCommand = new " + _currentTable.PascalName + "CustomSelectBy" + rule.PascalName + "(");

					if (rule.UseSearchObject)

					{

						sb.Append(_currentTable.CamelName);

						if (rule.Parameters.Count > 0)

							sb.Append(", ");

					}

					foreach (var parameter in rule.GeneratedParameters)

					{						

						if (!parameter.IsOutputParameter)

						{

							sb.Append(parameter.CamelName + ", ");

						}

					}

					if (sb.ToString().EndsWith(", ")) sb.Remove(sb.ToString().Length - 2, 2);

					sb.AppendLine(");");



					sb.AppendLine("			subDomain.AddSelectCommand(selectCommand);");

					sb.AppendLine("			subDomain.RunSelectCommands();");



					foreach (var parameter in rule.GeneratedParameters)

					{						

						if (parameter.IsOutputParameter)

						{

							sb.AppendLine("			" + parameter.CamelName + " = selectCommand." + parameter.PascalName + ";");

						}

					}

					

					sb.AppendLine("			return subDomain.GetCollection<" + _currentTable.PascalName + "Collection>();");

					sb.AppendLine("		}");

					sb.AppendLine();

				}



			}

			sb.AppendLine("		#endregion");

			sb.AppendLine();

		}



		private void AppendInterfaces()

		{

			sb.AppendLine("		#region IDisposable Members");

			sb.AppendLine();

			sb.AppendLine("		void IDisposable.Dispose()");

			sb.AppendLine("		{");

			sb.AppendLine();

			sb.AppendLine("		}");

			sb.AppendLine();

			sb.AppendLine("		#endregion");

			sb.AppendLine();

		}



		private void Append40Features()

		{

			if (_model.FrameworkVersion != FrameworkVersionConstants.v40) return;



			sb.AppendLine("		#region Framework 4.0 Functionality");

			sb.AppendLine();

			sb.AppendLine("		/// <summary>");

			sb.AppendLine("		/// ");

			sb.AppendLine("		/// </summary>");

			sb.AppendLine("		public event System.Collections.Specialized.NotifyCollectionChangedEventHandler CollectionChanged;");

			sb.AppendLine();

			sb.AppendLine("		/// <summary>");

			sb.AppendLine("		/// ");

			sb.AppendLine("		/// </summary>");

			sb.AppendLine("		/// <param name=\"e\"></param>");

			sb.AppendLine("		protected virtual void OnCollectionChanged(System.Collections.Specialized.NotifyCollectionChangedEventArgs e)");

			sb.AppendLine("		{");

			sb.AppendLine("			if (this.CollectionChanged != null)");

			sb.AppendLine("				this.CollectionChanged(this, e);");

			sb.AppendLine("		}");

			sb.AppendLine();

			sb.AppendLine("		#endregion");

			sb.AppendLine();

		}



		private void AppendRegionEnumerator()

		{

			sb.AppendLine("		#region IEnumerator Members");

			sb.AppendLine();

			sb.AppendLine("		object System.Collections.IEnumerator.Current");

			sb.AppendLine("		{");

			sb.AppendLine("			get { return this.GetEnumerator().Current; }");

			sb.AppendLine("		}");

			sb.AppendLine();

			sb.AppendLine("		bool System.Collections.IEnumerator.MoveNext()");

			sb.AppendLine("		{");

			sb.AppendLine("			return this.GetEnumerator().MoveNext();");

			sb.AppendLine("		}");

			sb.AppendLine();

			sb.AppendLine("		void System.Collections.IEnumerator.Reset()");

			sb.AppendLine("		{");

			sb.AppendLine("			this.GetEnumerator().Reset();");

			sb.AppendLine("		}");

			sb.AppendLine();

			sb.AppendLine("		#endregion");

			sb.AppendLine();



			sb.AppendLine("		#region IEnumerable<" + _currentTable.PascalName + "> Members");

			sb.AppendLine();

			sb.AppendLine("		IEnumerator<" + _currentTable.PascalName + "> IEnumerable<" + _currentTable.PascalName + ">.GetEnumerator()");

			sb.AppendLine("		{");

			sb.AppendLine("			var retval = new List<" + _currentTable.PascalName + ">();");

			sb.AppendLine("			foreach (" + _currentTable.PascalName + " item in this)");

			sb.AppendLine("			{");

			sb.AppendLine("				retval.Add(item);");

			sb.AppendLine("			}");

			sb.AppendLine("			return retval.GetEnumerator();");

			sb.AppendLine("		}");

			sb.AppendLine();

			sb.AppendLine("		#endregion");

			sb.AppendLine();



		}



		private void AppendRegionIBusinessCollectionExplicit()

		{

			if (!_currentTable.Immutable)

			{

				sb.AppendLine("		#region IPersistableBusinessCollection Explicit Members");

				sb.AppendLine();

				sb.AppendLine("		/// <summary>");

				sb.AppendLine("		/// Returns an item in this collection by index.");

				sb.AppendLine("		/// </summary>");

				sb.AppendLine("		/// <param name=\"index\">The zero-based index of the element to get or set. </param>");

				sb.AppendLine("		/// <returns>The element at the specified index.</returns>");

				sb.AppendLine("		IPersistableBusinessObject IPersistableBusinessCollection.this[int index]");

				sb.AppendLine("		{");

				sb.AppendLine("			get { return this[index]; }");

				sb.AppendLine("		}");

				sb.AppendLine();

				sb.AppendLine("		void IPersistableBusinessCollection.AddItem(IPersistableBusinessObject newItem)");

				sb.AppendLine("		{");

				sb.AppendLine("			this.AddItem((" + _currentTable.PascalName + ")newItem);");

				sb.AppendLine("		}");

				sb.AppendLine();

				sb.AppendLine("		IPersistableBusinessObject IPersistableBusinessCollection.NewItem()");

				sb.AppendLine("		{");

				sb.AppendLine("			return this.NewItem();");

				sb.AppendLine("		}");

				sb.AppendLine();

				sb.AppendLine("		#endregion");

				sb.AppendLine();

			}



			sb.AppendLine("		#region IBusinessCollection Explicit Members");

			sb.AppendLine();

			sb.AppendLine("		/// <summary>");

			sb.AppendLine("		/// Returns an item in this collection by index.");

			sb.AppendLine("		/// </summary>");

			sb.AppendLine("		/// <param name=\"index\">The zero-based index of the element to get or set. </param>");

			sb.AppendLine("		/// <returns>The element at the specified index.</returns>");

			sb.AppendLine("		IBusinessObject IBusinessCollection.this[int index]");

			sb.AppendLine("		{");

			sb.AppendLine("			get { return this[index]; }");

			sb.AppendLine("		}");

			sb.AppendLine();

			sb.AppendLine("		Enum IBusinessCollection.Collection");

			sb.AppendLine("		{");

			sb.AppendLine("			get { return this.Collection; }");

			sb.AppendLine("		}");

			sb.AppendLine();

			sb.AppendLine("		Type IBusinessCollection.ContainedType");

			sb.AppendLine("		{");

			sb.AppendLine("			get { return this.ContainedType; }");

			sb.AppendLine("		}");

			sb.AppendLine();

			sb.AppendLine("		SubDomainBase IBusinessCollection.SubDomain");

			sb.AppendLine("		{");

			sb.AppendLine("			get { return this.SubDomain; }");

			sb.AppendLine("		}");

			sb.AppendLine();

			sb.AppendLine("		Type ITyped.GetContainedType()");

			sb.AppendLine("		{");

			sb.AppendLine("		return typeof(" + _currentTable.PascalName + ");");

			sb.AppendLine("		}");

			sb.AppendLine();

			sb.AppendLine("		#endregion");

			sb.AppendLine();

		}



		private void AppendRegionGetFilteredList()

		{

			sb.AppendLine("		#region GetFilteredList");

			sb.AppendLine();

			sb.AppendLine("		/// <summary>");

			sb.AppendLine("		/// Returns a list filtered on the specified field with the specified value.");

			sb.AppendLine("		/// </summary>");

			sb.AppendLine("		[Obsolete(\"Use a LINQ query for more robust functionality\")]");

			sb.AppendLine("		public BusinessObjectList<" + _currentTable.PascalName + "> GetFilteredList(" + _currentTable.PascalName + ".FieldNameConstants field, object value)");

			sb.AppendLine("		{");

			sb.AppendLine("			var retval = new BusinessObjectList<" + _currentTable.PascalName + ">();");

			sb.AppendLine("			if (value == null)");

			sb.AppendLine("				return retval;");

			sb.AppendLine();

			sb.AppendLine("			string fieldName = string.Empty;");

			sb.AppendLine("			switch (field)");

			sb.AppendLine("			{");

			foreach (var column in _currentTable.GeneratedColumns)

			{				

				sb.AppendLine("				case " + _currentTable.PascalName + ".FieldNameConstants." + column.PascalName + ": fieldName = \"" + column.DatabaseName + "\"; break;");

			}



			if (_currentTable.AllowCreateAudit)

			{

				sb.AppendLine("				case " + _currentTable.PascalName + ".FieldNameConstants." + _model.Database.CreatedByPascalName + ": fieldName = \"" + _model.Database.CreatedByPascalName + "\"; break;");

				sb.AppendLine("				case " + _currentTable.PascalName + ".FieldNameConstants." + _model.Database.CreatedDatePascalName + ": fieldName = \"" + _model.Database.CreatedDatePascalName + "\"; break;");

			}



			if (_currentTable.AllowModifiedAudit)

			{

				sb.AppendLine("				case " + _currentTable.PascalName + ".FieldNameConstants." + _model.Database.ModifiedByPascalName + ": fieldName = \"" + _model.Database.ModifiedByPascalName + "\"; break;");

				sb.AppendLine("				case " + _currentTable.PascalName + ".FieldNameConstants." + _model.Database.ModifiedDatePascalName + ": fieldName = \"" + _model.Database.ModifiedDatePascalName + "\"; break;");

			}



			sb.AppendLine("			}");

			sb.AppendLine();

			sb.AppendLine("			DataRow[] rows = null;");

			sb.AppendLine("			if (value == null)");

			sb.AppendLine("			{");

			sb.AppendLine("				rows = this.wrappedClass.Select(fieldName + \" IS NULL\");");

			sb.AppendLine("			}");

			sb.AppendLine("			else");

			sb.AppendLine("			{");

			sb.AppendLine("				string tick = string.Empty;");

			sb.AppendLine("				if ((this.wrappedClass.Columns[fieldName].DataType == typeof(string)) || (this.wrappedClass.Columns[fieldName].DataType == typeof(Guid)))");

			sb.AppendLine("					tick = \"'\";");

			sb.AppendLine();

			sb.AppendLine("				rows = this.wrappedClass.Select(fieldName + \" = \" + tick + value.ToString().Replace(\"'\", \"''\") + tick);");

			sb.AppendLine("			}");

			sb.AppendLine();

			sb.AppendLine("			foreach (DataRow dr in rows)");

			sb.AppendLine("				retval.Add(new " + _currentTable.PascalName + "((Domain" + _currentTable.PascalName + ")dr));");

			sb.AppendLine();

			sb.AppendLine("			return retval;");

			sb.AppendLine("		}");

			sb.AppendLine();

			sb.AppendLine("		#endregion");

			sb.AppendLine();

		}



		private void AppendRegionGetDatabaseFieldName()

		{

			sb.AppendLine("		#region GetDatabaseFieldName");

			sb.AppendLine();

			sb.AppendLine("		/// <summary>");

			sb.AppendLine("		/// Returns the actual database name of the specified field.");

			sb.AppendLine("		/// </summary>");

			sb.AppendLine("		internal static string GetDatabaseFieldName(" + _currentTable.PascalName + ".FieldNameConstants field)");

			sb.AppendLine("		{");

			sb.AppendLine("			return GetDatabaseFieldName(field.ToString());");

			sb.AppendLine("		}");

			sb.AppendLine();

			sb.AppendLine("		/// <summary>");

			sb.AppendLine("		/// Returns the actual database name of the specified field.");

			sb.AppendLine("		/// </summary>");

			sb.AppendLine("		internal " + (_currentTable.ParentTable == null ? "" : "new ") + "static string GetDatabaseFieldName(string field)");

			sb.AppendLine("		{");

			sb.AppendLine("			switch (field)");

			sb.AppendLine("			{");

			foreach (var column in _currentTable.GeneratedColumns)

			{				

				if (column.Generated)

					sb.AppendLine("				case \"" + column.PascalName + "\": return \"" + column.Name + "\";");

			}



			if (_currentTable.AllowCreateAudit)

			{

				sb.AppendLine("				case \"" + _model.Database.CreatedByPascalName + "\": return \"" + _model.Database.CreatedByColumnName + "\";");

				sb.AppendLine("				case \"" + _model.Database.CreatedDatePascalName + "\": return \"" + _model.Database.CreatedDateColumnName + "\";");

			}



			if (_currentTable.AllowModifiedAudit)

			{

				sb.AppendLine("				case \"" + _model.Database.ModifiedByPascalName + "\": return \"" + _model.Database.ModifiedByColumnName + "\";");

				sb.AppendLine("				case \"" + _model.Database.ModifiedDatePascalName + "\": return \"" + _model.Database.ModifiedDateColumnName + "\";");

			}



			if (_currentTable.AllowTimestamp)

			{

				sb.AppendLine("				case \"" + _model.Database.TimestampPascalName + "\": return \"" + _model.Database.TimestampColumnName + "\";");

			}



			sb.AppendLine("			}");

			sb.AppendLine("			return string.Empty;");

			sb.AppendLine("		}");

			sb.AppendLine();

			sb.AppendLine("		#endregion");

			sb.AppendLine();

		}



		private void AppendSearchClass()

		{

			if (_model.Database.AllowZeroTouch) return;

			if (!_model.SupportLegacySearchObject) return;



			var validColumns = GetValidSearchColumns();

			if (validColumns.Count() != 0)

			{

				sb.AppendLine("	#region " + _currentTable.PascalName + "Search");

				sb.AppendLine();

				sb.AppendLine("	/// <summary>");

				sb.AppendLine("	/// The search object for the " + _currentTable.PascalName + "Collection.");

				sb.AppendLine("	/// </summary>");

				sb.AppendLine("	[Serializable]");

				sb.AppendLine("	public partial class " + _currentTable.PascalName + "Search : IBusinessObjectSearch");

				sb.AppendLine("	{");

				sb.AppendLine();

				sb.AppendLine("		private int _maxRowCount = 0;");

				//foreach (var column in validColumns.OrderBy(x => x.Name))

				//{

				//  sb.AppendLine("		private " + column.GetCodeType(true, true) + " _" + column.CamelName + ";");

				//}

				sb.AppendLine("		private SearchType _searchType;");

				sb.AppendLine();

				sb.AppendLine("		/// <summary>");

				sb.AppendLine("		/// Determines the maximum number of rows that are returned. Use 0 for no limit.");

				sb.AppendLine("		/// </summary>");

				sb.AppendLine("		public int MaxRowCount");

				sb.AppendLine("		{");

				sb.AppendLine("			get { return _maxRowCount; }");

				sb.AppendLine("			set { _maxRowCount = value; }");

				sb.AppendLine("		}");

				sb.AppendLine();

				sb.AppendLine("		/// <summary>");

				sb.AppendLine("		/// Determines the maximum number of rows that are returned. Use 0 for no limit.");

				sb.AppendLine("		/// </summary>");

				sb.AppendLine("		int IBusinessObjectSearch.MaxRowCount");

				sb.AppendLine("		{");

				sb.AppendLine("			get { return this.MaxRowCount; }");

				sb.AppendLine("			set { this.MaxRowCount = value; }");

				sb.AppendLine("		}");

				sb.AppendLine();

				sb.AppendLine("		/// <summary>");

				sb.AppendLine("		/// Determines the type of search to be performed.");

				sb.AppendLine("		/// </summary>");

				sb.AppendLine("		public SearchType SearchType");

				sb.AppendLine("		{");

				sb.AppendLine("			get { return _searchType; }");

				sb.AppendLine("		}");

				sb.AppendLine();

				sb.AppendLine("		/// <summary>");

				sb.AppendLine("		/// A search object for the '" + _currentTable.PascalName + "' collection.");

				sb.AppendLine("		/// </summary>");

				sb.AppendLine("		public " + _currentTable.PascalName + "Search(SearchType searchType) ");

				sb.AppendLine("		{");

				sb.AppendLine("			_searchType = searchType;");

				sb.AppendLine("		}");

				sb.AppendLine();

				sb.AppendLine("		void IBusinessObjectSearch.SetValue(Enum field, object value)");

				sb.AppendLine("		{");

				sb.AppendLine("			this.SetValue((" + _currentTable.PascalName + ".FieldNameConstants)field, value);");

				sb.AppendLine("		}");

				sb.AppendLine();

				sb.AppendLine("		/// <summary>");

				sb.AppendLine("		/// Set the specified value on this object.");

				sb.AppendLine("		/// </summary>");

				sb.AppendLine("		public void SetValue(" + _currentTable.PascalName + ".FieldNameConstants field, object value)");

				sb.AppendLine("		{");

				foreach (var column in validColumns.OrderBy(x => x.Name))

				{

					sb.AppendLine("			if (field == " + _currentTable.PascalName + ".FieldNameConstants." + column.PascalName + ") this." + column.PascalName + " = (" + column.GetCodeType(false) + ")value;");

				}

				sb.AppendLine("		}");

				sb.AppendLine();

				foreach (var column in validColumns.OrderBy(x => x.Name))

				{

					sb.AppendLine("		/// <summary>");

					sb.AppendLine("		/// This field determines the value of the '" + column.PascalName + "' field on the '" + _currentTable.PascalName + "' object when this search object is applied.");

					sb.AppendLine("		/// </summary>");

					sb.AppendLine("		public " + column.GetCodeType(true, true) + " " + column.PascalName + " { get; set; }");

					sb.AppendLine();

				}

				sb.AppendLine("	}");

				sb.AppendLine();

				sb.AppendLine("	#endregion ");

				sb.AppendLine();

			}

		}



		private void AppendPagingClass()

		{

			sb.AppendLine("	#region " + _currentTable.PascalName + "Paging");

			sb.AppendLine();

			sb.AppendLine("	/// <summary>");

			sb.AppendLine("	/// The paging object for the " + _currentTable.PascalName + " collection");

			sb.AppendLine("	/// </summary>");

			sb.AppendLine("	[Serializable]");

			sb.AppendLine("	" + this.ClassScope + " partial class " + _currentTable.PascalName + "Paging : Widgetsphere.Core.DataAccess.PagingBase<" + _currentTable.PascalName + "PagingFieldItem, " + this.GetLocalNamespace() + ".Business.Objects." + _currentTable.PascalName + ".FieldNameConstants>");

			sb.AppendLine("	{");

			sb.AppendLine();

			sb.AppendLine("		#region Constructors");

			sb.AppendLine();

			sb.AppendLine("		/// <summary>");

			sb.AppendLine("		/// Creates a paging object");

			sb.AppendLine("		/// </summary>");

			sb.AppendLine("		public " + _currentTable.PascalName + "Paging()");

			sb.AppendLine("			: this(1, 10, null)");

			sb.AppendLine("		{");

			sb.AppendLine("		}");

			sb.AppendLine();

			sb.AppendLine("		/// <summary>");

			sb.AppendLine("		/// Creates a paging object");

			sb.AppendLine("		/// </summary>");

			sb.AppendLine("		/// <param name=\"pageIndex\">The page number to load</param>");

			sb.AppendLine("		/// <param name=\"recordsperPage\">The number of records per page.</param>");

			sb.AppendLine("		public " + _currentTable.PascalName + "Paging(int pageIndex, int recordsperPage)");

			sb.AppendLine("			: this(pageIndex, recordsperPage, null)");

			sb.AppendLine("		{");

			sb.AppendLine("		}");

			sb.AppendLine();

			sb.AppendLine("		/// <summary>");

			sb.AppendLine("		/// Creates a paging object");

			sb.AppendLine("		/// </summary>");

			sb.AppendLine("		/// <param name=\"pageIndex\">The page number to load</param>");

			sb.AppendLine("		/// <param name=\"recordsperPage\">The number of records per page.</param>");

			sb.AppendLine("		/// <param name=\"field\">The field on which to sort.</param>");

			sb.AppendLine("		/// <param name=\"ascending\">Determines the sorted direction.</param>");

			sb.AppendLine("		public " + _currentTable.PascalName + "Paging(int pageIndex, int recordsperPage, " + this.GetLocalNamespace() + ".Business.Objects." + _currentTable.PascalName + ".FieldNameConstants field, bool ascending)");

			sb.AppendLine("			: this(pageIndex, recordsperPage, new " + _currentTable.PascalName + "PagingFieldItem(field, ascending))");

			sb.AppendLine("		{");

			sb.AppendLine("		}");

			sb.AppendLine();

			sb.AppendLine("		/// <summary>");

			sb.AppendLine("		/// Creates a paging object");

			sb.AppendLine("		/// </summary>");

			sb.AppendLine("		/// <param name=\"pageIndex\">The page number to load</param>");

			sb.AppendLine("		/// <param name=\"recordsperPage\">The number of items per page.</param>");

			sb.AppendLine("		/// <param name=\"orderByField\">The field on which to sort.</param>");

			sb.AppendLine("		public " + _currentTable.PascalName + "Paging(int pageIndex, int recordsperPage, " + _currentTable.PascalName + "PagingFieldItem orderByField)");

			sb.AppendLine("			: base(pageIndex, recordsperPage, orderByField)");

			sb.AppendLine("		{");

			sb.AppendLine("		}");

			sb.AppendLine();

			sb.AppendLine("		#endregion");

			sb.AppendLine();

			sb.AppendLine("	}");

			sb.AppendLine();

			sb.AppendLine("	/// <summary>");

			sb.AppendLine("	/// A field sort object for the " + _currentTable.PascalName + "Paging object.");

			sb.AppendLine("	/// </summary>");

			sb.AppendLine("	[Serializable]");

			sb.AppendLine("	" + this.ClassScope + " partial class " + _currentTable.PascalName + "PagingFieldItem : Widgetsphere.Core.DataAccess.PagingFieldItem<" + this.GetLocalNamespace() + ".Business.Objects." + _currentTable.PascalName + ".FieldNameConstants>");

			sb.AppendLine("	{");

			sb.AppendLine("		/// <summary>");

			sb.AppendLine("		/// Create a sorting field object for the " + _currentTable.PascalName + "Paging object.");

			sb.AppendLine("		/// </summary>");

			sb.AppendLine("		/// <param name=\"field\">The field on which to sort.</param>");

			sb.AppendLine("		public " + _currentTable.PascalName + "PagingFieldItem(" + this.GetLocalNamespace() + ".Business.Objects." + _currentTable.PascalName + ".FieldNameConstants field)");

			sb.AppendLine("			: base(field)");

			sb.AppendLine("		{");

			sb.AppendLine("			this.Field = field;");

			sb.AppendLine("		}");

			sb.AppendLine();

			sb.AppendLine("		/// <summary>");

			sb.AppendLine("		/// Create a sorting field object for the " + _currentTable.PascalName + "Paging object.");

			sb.AppendLine("		/// </summary>");

			sb.AppendLine("		/// <param name=\"field\">The field on which to sort.</param>");

			sb.AppendLine("		/// <param name=\"ascending\">Determines the direction of the sort.</param>");

			sb.AppendLine("		public " + _currentTable.PascalName + "PagingFieldItem(" + this.GetLocalNamespace() + ".Business.Objects." + _currentTable.PascalName + ".FieldNameConstants field, bool ascending)");

			sb.AppendLine("			: this(field)");

			sb.AppendLine("		{");

			sb.AppendLine("			this.Ascending = ascending;");

			sb.AppendLine("		}");

			sb.AppendLine();

			sb.AppendLine("	}");

			sb.AppendLine();

			sb.AppendLine("	#endregion");

			sb.AppendLine();

		}



		private IEnumerable<Column> GetValidSearchColumns()

		{

			var allColumns = _currentTable.GetColumnsFullHierarchy().Where(x => x.Generated).ToList();

			var validColumns = new List<Column>();

			foreach (var column in allColumns.OrderBy(x => x.Name))

			{

				if (!(column.DataType == System.Data.SqlDbType.Binary ||

					column.DataType == System.Data.SqlDbType.Image ||

					column.DataType == System.Data.SqlDbType.NText ||

					column.DataType == System.Data.SqlDbType.Text ||

					column.DataType == System.Data.SqlDbType.Timestamp ||

					column.DataType == System.Data.SqlDbType.Udt ||

					column.DataType == System.Data.SqlDbType.VarBinary ||

					column.DataType == System.Data.SqlDbType.Variant ||

					column.DataType == System.Data.SqlDbType.Money))

				{

					validColumns.Add(column);

				}

			}

			return validColumns;

		}



		private void AppendClassEnumerator()

		{

			sb.AppendLine("		#region IEnumerator");

			sb.AppendLine();

			sb.AppendLine("		/// <summary>");

			sb.AppendLine("		/// An strongly-typed enumerator for the '" + _currentTable.PascalName + "' object collection");

			sb.AppendLine("		/// </summary>");

			sb.AppendLine("		public partial class " + _currentTable.PascalName + "Enumerator : System.Collections.IEnumerator ");

			sb.AppendLine("		{");

			sb.AppendLine("			private System.Collections.IEnumerator internalEnumerator;");

			sb.AppendLine("			internal " + _currentTable.PascalName + "Enumerator(IEnumerator icg)");

			sb.AppendLine("			{");

			sb.AppendLine("				internalEnumerator = icg;");

			sb.AppendLine("			}");

			sb.AppendLine();

			sb.AppendLine("			#region IEnumerator Members");

			sb.AppendLine();

			sb.AppendLine("			/// <summary>");

			sb.AppendLine("			/// Reset the enumerator to the first object in this collection");

			sb.AppendLine("			/// </summary>");

			sb.AppendLine("			public void Reset()");

			sb.AppendLine("			{");

			sb.AppendLine("			try");

			sb.AppendLine("			{");

			sb.AppendLine("				internalEnumerator.Reset();");

			sb.AppendLine("			}");

			Globals.AppendBusinessEntryCatch(sb);

			sb.AppendLine("			}");

			sb.AppendLine();

			sb.AppendLine("		/// <summary>");

			sb.AppendLine("		/// Gets the current element in the collection.");

			sb.AppendLine("		/// </summary>");

			sb.AppendLine("		/// <returns>The current element in the collection.</returns>");

			sb.AppendLine("			public object Current");

			sb.AppendLine("			{");

			sb.AppendLine("				get");

			sb.AppendLine("				{");

			sb.AppendLine("					try");

			sb.AppendLine("					{");

			sb.AppendLine("						return new " + _currentTable.PascalName + "((" + this.GetLocalNamespace() + ".Domain.Objects.Domain" + _currentTable.PascalName + ")internalEnumerator.Current);");

			sb.AppendLine("					}");

			Globals.AppendBusinessEntryCatch(sb, true);

			sb.AppendLine("				}");

			sb.AppendLine("			}");

			sb.AppendLine();

			sb.AppendLine("			/// <summary>");

			sb.AppendLine("			/// Advances the enumerator to the next element of the collection.");

			sb.AppendLine("			/// </summary>");

			sb.AppendLine("			public bool MoveNext()");

			sb.AppendLine("			{");

			sb.AppendLine("				try");

			sb.AppendLine("				{");

			sb.AppendLine("					bool movedNext = internalEnumerator.MoveNext();");

			sb.AppendLine("					if (movedNext)");

			sb.AppendLine("					{");

			sb.AppendLine("						" + this.GetLocalNamespace() + ".Domain.Objects.Domain" + _currentTable.PascalName + " currentRow = (" + this.GetLocalNamespace() + ".Domain.Objects.Domain" + _currentTable.PascalName + ")internalEnumerator.Current;");

			sb.AppendLine("						while (currentRow.RowState == System.Data.DataRowState.Deleted || currentRow.RowState == System.Data.DataRowState.Detached)");

			sb.AppendLine("						{");

			sb.AppendLine("							movedNext = internalEnumerator.MoveNext();");

			sb.AppendLine("							if (!movedNext) break;");

			sb.AppendLine("							currentRow = (" + this.GetLocalNamespace() + ".Domain.Objects.Domain" + _currentTable.PascalName + ")internalEnumerator.Current;");

			sb.AppendLine("						}");

			sb.AppendLine("					}");

			sb.AppendLine("					return movedNext;");

			sb.AppendLine("				}");

			Globals.AppendBusinessEntryCatch(sb);

			sb.AppendLine("			}");

			sb.AppendLine();

			sb.AppendLine("			#endregion");

			sb.AppendLine();

			sb.AppendLine("		}");

			sb.AppendLine();

			sb.AppendLine("		#endregion");

			sb.AppendLine();

		}



		#endregion



		#region append member variables



		public void AppendMemberVariables()

		{

			sb.AppendLine("		#region Member Variables");

			sb.AppendLine();



			if (_currentTable.ParentTable == null)

			{

				sb.AppendLine("		internal Domain" + _currentTable.PascalName + "Collection wrappedClass;");

				sb.AppendLine();

				sb.AppendLine("		/// <summary>");

				sb.AppendLine("		/// The parent subdomain object");

				sb.AppendLine("		/// </summary>");

				sb.AppendLine("		protected SubDomain _subDomain = null;");

			}

			else

			{

				sb.AppendLine("		internal new Domain" + _currentTable.PascalName + "Collection wrappedClass;");

			}



			sb.AppendLine();

			sb.AppendLine("		#endregion");

			sb.AppendLine();

		}

		#endregion



		#region append constructors



		public void AppendConstructors()

		{

			sb.AppendLine("		#region Constructor / Initialize");

			sb.AppendLine();

			AppendConstructorDomainClass();

			AppendConstructorModifier();

			AppendConstructorDefault();

			sb.AppendLine("		#endregion");

			sb.AppendLine();

		}



		private void AppendConstructorDomainClass()

		{

			if (_currentTable.ParentTable == null)

			{

				sb.AppendLine("		internal " + _currentTable.PascalName + "Collection(Domain" + _currentTable.PascalName + "Collection classToWrap)");

				sb.AppendLine("		{");

				sb.AppendLine("			_subDomain = classToWrap.SubDomain;");

				sb.AppendLine("			wrappedClass = classToWrap;");

				sb.AppendLine("		}");

			}

			else

			{

				sb.AppendLine("		internal " + _currentTable.PascalName + "Collection(Domain" + _currentTable.PascalName + "Collection classToWrap):base(classToWrap)");

				sb.AppendLine("		{");

				sb.AppendLine("			wrappedClass = classToWrap;");

				sb.AppendLine("			base.wrappedClass = wrappedClass;");

				sb.AppendLine("		}");

			}



			sb.AppendLine();

		}



		private void AppendConstructorModifier()

		{

			sb.AppendLine("		/// <summary>");

			sb.AppendLine("		/// Constructor that enables you to specify a modifier");

			sb.AppendLine("		/// </summary>");

			sb.AppendLine("		/// <param name=\"modifier\">Used in audit operations to track changes</param>");

			sb.AppendLine("		public " + _currentTable.PascalName + "Collection(string modifier)");

			sb.AppendLine("		{");

			sb.AppendLine("			_subDomain = new SubDomain(modifier);");

			sb.AppendLine("			ResetWrappedClass((Domain" + _currentTable.PascalName + "Collection)_subDomain.GetDomainCollection(Collections." + _currentTable.PascalName + "Collection));");

			sb.AppendLine("		}");

			sb.AppendLine();

		}



		private void AppendConstructorDefault()

		{

			sb.AppendLine("		/// <summary>");

			sb.AppendLine("		/// The default constructor");

			sb.AppendLine("		/// </summary>");

			sb.AppendLine("		public " + _currentTable.PascalName + "Collection() ");

			sb.AppendLine("		{");

			sb.AppendLine("			_subDomain = new SubDomain(ConfigurationValues.GetInstance().Modifier);");

			sb.AppendLine("			ResetWrappedClass((Domain" + _currentTable.PascalName + "Collection)_subDomain.GetDomainCollection(Collections." + _currentTable.PascalName + "Collection));");

			sb.AppendLine("		}");

			sb.AppendLine();

		}



		#endregion



		#region append properties



		private string ClassScope

		{

			get

			{

				var classScope = "public";

				if (_currentTable.AssociativeTable) classScope = "internal";

				return classScope;

			}

		}



		private void AppendProperties()

		{

			sb.AppendLine("		#region Property Implementations");

			sb.AppendLine();

			AppendPropertyWrappedClass();

			AppendPropertyModifier();

			AppendPropertySubDomain();

			AppendPropertyCount();

			AppendPropertyContainedType();

			AppendPropertyCollection();

			sb.AppendLine();

			sb.AppendLine("		#endregion");

			sb.AppendLine();

		}



		private void AppendPropertyWrappedClass()

		{

			sb.AppendLine("		/// <summary>");

			sb.AppendLine("		/// Returns the internal object that this object wraps");

			sb.AppendLine("		/// </summary>");

			sb.AppendLine("		[System.ComponentModel.Browsable(false)]");



			if (_currentTable.ParentTable == null)

				sb.AppendLine("		internal virtual object WrappedClass");

			else

				sb.AppendLine("		internal override object WrappedClass");



			sb.AppendLine("		{");

			sb.AppendLine("			get { return wrappedClass ; }");

			sb.AppendLine("			set { wrappedClass = (Domain" + _currentTable.PascalName + "Collection)value ; }");

			sb.AppendLine("		}");

			sb.AppendLine();

			sb.AppendLine("		//WrappingClass Interface");

			sb.AppendLine("		object Widgetsphere.Core.DataAccess.IWrappingClass.WrappedClass");

			sb.AppendLine("		{");

			sb.AppendLine("			get { return this.WrappedClass; }");

			sb.AppendLine("			set { this.WrappedClass = value; }");

			sb.AppendLine("		}");

			sb.AppendLine();

		}



		private void AppendPropertySubDomain()

		{

			if (_currentTable.ParentTable != null)

				return;



			sb.AppendLine("		/// <summary>");

			sb.AppendLine("		/// A reference to the SubDomain that holds this collection");

			sb.AppendLine("		/// </summary>");

			sb.AppendLine("		public SubDomain SubDomain");

			sb.AppendLine("		{");

			sb.AppendLine("			get");

			sb.AppendLine("			{");

			sb.AppendLine("				try");

			sb.AppendLine("				{");

			sb.AppendLine("					return wrappedClass.SubDomain;");

			sb.AppendLine("				}");

			Globals.AppendBusinessEntryCatch(sb, true);

			sb.AppendLine("			}");

			sb.AppendLine("		}");

			sb.AppendLine();

		}



		private void AppendPropertyModifier()

		{

			if (_currentTable.ParentTable != null)

				return;



			sb.AppendLine("		/// <summary>");

			sb.AppendLine("		/// Specifies a modifier string to be used in the audit functionality");

			sb.AppendLine("		/// </summary>");

			sb.AppendLine("		public string Modifier");

			sb.AppendLine("		{");

			sb.AppendLine("			get");

			sb.AppendLine("			{");

			sb.AppendLine("				try");

			sb.AppendLine("				{");

			sb.AppendLine("					return wrappedClass.Modifier;");

			sb.AppendLine("				}");

			Globals.AppendBusinessEntryCatch(sb, true);

			sb.AppendLine("			}");

			sb.AppendLine("			internal set { wrappedClass.Modifier = value; }");

			sb.AppendLine("		}");

			sb.AppendLine();

		}



		private void AppendPropertyCount()

		{

			sb.AppendLine("		/// <summary>");

			sb.AppendLine("		/// Returns the number of items in this collection");

			sb.AppendLine("		/// </summary>");

			sb.AppendLine("		public override int Count");

			sb.AppendLine("		{");

			sb.AppendLine("			get");

			sb.AppendLine("			{");

			sb.AppendLine("				try");

			sb.AppendLine("				{");

			sb.AppendLine("					lock (wrappedClass.SubDomain)");

			sb.AppendLine("					{");

			sb.AppendLine("						DataTable dt = wrappedClass.GetChanges(DataRowState.Deleted);");

			sb.AppendLine("						if (dt == null) return wrappedClass.Count;");

			sb.AppendLine("						else return wrappedClass.Count - dt.Rows.Count;");

			sb.AppendLine("					}");

			sb.AppendLine("				}");

			Globals.AppendBusinessEntryCatch(sb, true);

			sb.AppendLine("			}");

			sb.AppendLine("		}");

			sb.AppendLine();

		}



		private void AppendPropertyContainedType()

		{

			sb.AppendLine("		/// <summary>");

			s…