public static string GetBody(Table table, ModelRoot model)
			{
				try
				{
					List<Column> allColumns = new List<Column>();
					foreach (Column dc in table.GetColumnsFullHierarchy())
					{
						if (!(dc.DataType == System.Data.SqlDbType.Binary ||
							dc.DataType == System.Data.SqlDbType.Image ||
							dc.DataType == System.Data.SqlDbType.NText ||
							dc.DataType == System.Data.SqlDbType.Text ||
							dc.DataType == System.Data.SqlDbType.Timestamp ||
							dc.DataType == System.Data.SqlDbType.Udt ||
							dc.DataType == System.Data.SqlDbType.VarBinary ||
							dc.DataType == System.Data.SqlDbType.Variant ||
						dc.DataType == System.Data.SqlDbType.Money))
						{
							allColumns.Add(dc);
						}
					}

					if (allColumns.Count != 0)
					{
						return BuildStoredProcedure(table, model, allColumns);
					}

					return "";

				}
				catch (Exception ex)
				{
					throw new Exception(table.DatabaseName + ": Failed on generation of paging select statement", ex);
				}
			}

		public static string GetSQLCreateTable(ModelRoot model, Table table)
		{
			StringBuilder sb = new StringBuilder();
			string tableName = Globals.GetTableDatabaseName(model, table);
			sb.AppendLine("if not exists(select * from sysobjects where name = '" + tableName + "' and xtype = 'U')");
			sb.AppendLine("CREATE TABLE [dbo].[" + tableName + "] (");

			bool firstLoop = true;
			foreach (Reference columnRef in table.Columns)
			{
				Column column = (Column)columnRef.Object;
				if (!firstLoop) sb.AppendLine(",");
				else firstLoop = false;
				sb.Append(AppendColumnDefinition(column, true, true));
			}
			AppendModifiedAudit(model, table, sb);
			AppendCreateAudit(model, table, sb);
			AppendTimestamp(model, table, sb);
			sb.AppendLine();
			sb.AppendLine(") ON [PRIMARY]");
			sb.AppendLine();

			return sb.ToString();

		}

		public SQLSelectBusinessObjectByForeignKeyTemplate(ModelRoot model, Relation currentRelation, Table realTable)
		{
			_model = model;
			_currentRelation = currentRelation;
			_childTable = (Table)_currentRelation.ChildTableRef.Object;
			if (realTable.IsInheritedFrom(_childTable)) _childTable = realTable;
			_parentTable = (Table)_currentRelation.ParentTableRef.Object;
		}

 public static string SetExistingConnection(ModelRoot root)
 {
     string connectionString = string.Empty;
     while (string.IsNullOrEmpty(connectionString))
     {
         connectionString = ChooseDatabase();
     }
     using (Transaction tx = root.Store.TransactionManager.BeginTransaction("SetConnectionString", false))
     {
         root.ConnectionString = connectionString;
         tx.Commit();
     }
     return connectionString;
 }

		private static void AppendFullTemplate(StringBuilder sb, Table table, ModelRoot model)
		{
			try
			{
				sb.AppendLine("if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[" + GetStoredProcedureName(table, model) + "]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)");
				sb.AppendLine("	drop procedure [dbo].[" + GetStoredProcedureName(table, model) + "]");
				sb.AppendLine("GO");
				sb.AppendLine();
				sb.AppendLine("SET QUOTED_IDENTIFIER ON");
				sb.AppendLine("GO");
				sb.AppendLine("SET ANSI_NULLS ON");
				sb.AppendLine("GO");
				sb.AppendLine();
				sb.AppendLine("CREATE PROCEDURE [dbo].[" + GetStoredProcedureName(table, model) + "]");
				sb.AppendLine("(");
				sb.AppendLine(BuildParameterList(table, model));
				sb.AppendLine(")");
				sb.AppendLine("AS");
				sb.AppendLine("SET NOCOUNT OFF;");
				sb.AppendLine();
				sb.Append(SQLGeneratedBodyHelper.SQLInsertBusinessObjectBody(table, model));
				sb.AppendLine("GO");
				sb.AppendLine();
				sb.AppendLine("SET QUOTED_IDENTIFIER OFF");
				sb.AppendLine("GO");
				sb.AppendLine("SET ANSI_NULLS ON");
				sb.AppendLine("GO");
				sb.AppendLine();
				if (model.Database.GrantExecUser != string.Empty)
				{
					sb.AppendFormat("GRANT  EXECUTE  ON [dbo].[{0}]  TO [{1}]", GetStoredProcedureName(table, model), model.Database.GrantExecUser).AppendLine();
					sb.AppendLine("GO");
					sb.AppendLine();
				}

			}
			catch (Exception ex)
			{
				throw;
			}

		}

		public static string GetSQLCreateAuditTable(ModelRoot model, Table table)
		{
			StringBuilder sb = new StringBuilder();
			string tableName = "__AUDIT__" + Globals.GetTableDatabaseName(model, table);
			sb.AppendLine("if not exists(select * from sysobjects where name = '" + tableName + "' and xtype = 'U')");
			sb.AppendLine("CREATE TABLE [dbo].[" + tableName + "] (");
			sb.AppendLine("[__rowid] [INT] NOT NULL IDENTITY,");
			sb.AppendLine("[__action] [INT] NOT NULL,");
			sb.AppendLine("[__insertdate] [DATETIME] CONSTRAINT [DF__" + table.DatabaseName + "__AUDIT] DEFAULT " + (model.UseUTCTime ? "GetUTCDate()" : "GetDate()") + " NOT NULL,");
			
			ColumnCollection columnList = table.GetColumns();
			foreach (Column column in columnList)
			{				
				sb.Append(AppendColumnDefinition(column, false, false, false));
				if (columnList.IndexOf(column) < columnList.Count - 1) sb.Append(",");
				sb.AppendLine();
			}			
			sb.AppendLine(") ON [PRIMARY]");
			sb.AppendLine();
			return sb.ToString();

		}

 public static string GetOrCreateConnectionString(ModelRoot root, string diagramName)
 {
     string connectionString = root.ConnectionString;
     while(string.IsNullOrEmpty(connectionString))
     {
         var dbName = string.Join("", diagramName.Split(' ')) + "Db";
         var getOrCreateConnectionDlg = new GetOrCreateConnectionForm(dbName);
         if (getOrCreateConnectionDlg.ShowDialog() == System.Windows.Forms.DialogResult.OK)
         {
             switch (getOrCreateConnectionDlg.ConfigurationType)
             {
                 case ConnectionConfigurationType.CreateLocal:
                     try
                     {
                         connectionString = CreateLocalConnection(dbName);
                     }
                     catch (Exception e)
                     {
                         System.Windows.Forms.MessageBox.Show(e.Message + "\nPlease choose a connection.");
                         connectionString = ChooseDatabase();
                     }
                     break;
                 case ConnectionConfigurationType.ChooseDatabase:
                     connectionString = ChooseDatabase();
                     break;
                 case ConnectionConfigurationType.UseCustomConnection:
                     connectionString = getOrCreateConnectionDlg.ConnectionString;
                     break;
             }
         }
     }
     using (Transaction tx = root.Store.TransactionManager.BeginTransaction("SetConnectionString", false))
     {
         root.ConnectionString = connectionString;
         tx.Commit();
     }
     return connectionString;
 }

 protected bool Equals(ModelRoot other)
 {
     return IntProp == other.IntProp
                     && DateTime.Equals(other.DateTime)
                     && ModelEnum == other.ModelEnum
                     && string.Equals(StrProp, other.StrProp)
                     && Equals(SubModel, other.SubModel);
 }

    public DefinedStoredProcedureSelectCommandExtenderTemplate(ModelRoot model, CustomStoredProcedure currentStoredProcedure)
    {
      _model = model;
      _currentStoredProcedure = currentStoredProcedure;
		}

		public DomainComponentCollectionExtenderTemplate(ModelRoot model, TableComponent currentComponent)
    {
      _model = model;
      _currentComponent = currentComponent;
		}

 public SQLSelectStoredProcedureTemplate(ModelRoot model, CustomStoredProcedure currentStoredProcedure)
 {
   _model = model;
   _currentStoredProcedure = currentStoredProcedure;
 }

		public SQLSelectBusinessObjectTemplate(ModelRoot model, Table currentTable)
    {
      _model = model;
			_currentTable = currentTable;
		}

		public DomainObjectGeneratedTemplate(ModelRoot model, Table currentTable)
		{
			_model = model;
			_currentTable = currentTable;
		}

		public ObjectServiceExtenderTemplate(ModelRoot model, Table table)
		{
			_model = model;
			_currentTable = table;
		}

		public DataServiceJSPageHelperTemplate(ModelRoot model)
    {
      _model = model;      
		}

		public static string GetParentStoredProcedureName(Table table, ModelRoot model)
		{
			if (table.ParentTable == null) return "";
			else return "gen_" + Globals.GetPascalName(model, table.ParentTable) + "Insert";
		}

		public SQLInsertBusinessObjectTemplate(ModelRoot model, Table currentTable)
		{
			_model = model;
			table = currentTable;
		}

		public BusinessSQLHelperExtenderTemplate(ModelRoot model)
    {
      _model = model;      
		}

		public SQLSelectComponentByPrimaryKeyTemplate(ModelRoot model, TableComponent currentComponent)
		{
			_model = model;
			_currentComponent = currentComponent;
		}

		public ObjectListPagesExtenderTemplate(ModelRoot model, Table currentTable)
    {
      _model = model;
      _currentTable = currentTable;
		}