Inheritance: BaseDbScriptTemplate
    public override void Generate()
		{
			//If this is a zero-touch install then there are no stored procedures
			if (_model.Database.AllowZeroTouch) return;

			foreach (Table table in _model.Database.Tables)
			{
        if(table.Generated)
        {
					if (table.PrimaryKeyColumns.Count < table.GeneratedColumns.Count)
					{
						foreach (TableComponent component in table.ComponentList)
						{
							SQLUpdateComponentTemplate template = new SQLUpdateComponentTemplate(_model, component);
							string fullFileName = template.FileName;
							ProjectItemGeneratedEventArgs eventArgs = new ProjectItemGeneratedEventArgs(fullFileName, template.FileContent, ProjectName, PARENT_ITEM_NAME, ProjectItemType.Folder, this, true);
							eventArgs.Properties.Add("BuildAction", 3);
							OnProjectItemGenerated(this, eventArgs);
						}
					}
        }
			}
			ProjectItemGenerationCompleteEventArgs gcEventArgs = new ProjectItemGenerationCompleteEventArgs(this);
			OnGenerationComplete(this, gcEventArgs);
    }
Exemplo n.º 2
0
        public override void Generate()
        {
            //If this is a zero-touch install then there are no stored procedures
            if (_model.Database.AllowZeroTouch)
            {
                return;
            }

            foreach (Table table in _model.Database.Tables)
            {
                if (table.Generated)
                {
                    if (table.PrimaryKeyColumns.Count < table.GeneratedColumns.Count)
                    {
                        foreach (TableComponent component in table.ComponentList)
                        {
                            SQLUpdateComponentTemplate template = new SQLUpdateComponentTemplate(_model, component);
                            string fullFileName = template.FileName;
                            ProjectItemGeneratedEventArgs eventArgs = new ProjectItemGeneratedEventArgs(fullFileName, template.FileContent, ProjectName, PARENT_ITEM_NAME, ProjectItemType.Folder, this, true);
                            eventArgs.Properties.Add("BuildAction", 3);
                            OnProjectItemGenerated(this, eventArgs);
                        }
                    }
                }
            }
            ProjectItemGenerationCompleteEventArgs gcEventArgs = new ProjectItemGenerationCompleteEventArgs(this);

            OnGenerationComplete(this, gcEventArgs);
        }