public override void Generate() { try { if (this.UseSingleFile) { //Process all views var sb = new StringBuilder(); sb.AppendLine("--DO NOT MODIFY THIS FILE. IT IS ALWAYS OVERWRITTEN ON GENERATION."); sb.AppendLine(); var grantSB = new StringBuilder(); foreach (var storedProcedure in _model.Database.CustomStoredProcedures.Where(x => x.Generated).OrderBy(x => x.Name)) { var template = new SQLSelectStoredProcedureTemplate(_model, storedProcedure, true, grantSB); sb.Append(template.FileContent); } //Add Grants sb.Append(grantSB.ToString()); var eventArgs = new ProjectItemGeneratedEventArgs("StoredProcedures.sql", sb.ToString(), ProjectName, this.ParentItemPath, ProjectItemType.Folder, this, true); eventArgs.Properties.Add("BuildAction", 3); OnProjectItemGenerated(this, eventArgs); } else { foreach (var storedProcedure in _model.Database.CustomStoredProcedures.Where(x => x.Generated).OrderBy(x => x.Name)) { var grantSB = new StringBuilder(); var template = new SQLSelectStoredProcedureTemplate(_model, storedProcedure, false, grantSB); //Add grants var sb = new StringBuilder(); sb.Append(template.FileContent); sb.Append(grantSB.ToString()); var fullFileName = template.FileName; var eventArgs = new ProjectItemGeneratedEventArgs(fullFileName, template.FileContent, ProjectName, this.ParentItemPath, ProjectItemType.Folder, this, true); eventArgs.Properties.Add("BuildAction", 3); OnProjectItemGenerated(this, eventArgs); } } var gcEventArgs = new ProjectItemGenerationCompleteEventArgs(this); OnGenerationComplete(this, gcEventArgs); } catch (Exception ex) { throw; } }
public override void Generate() { try { if (this.UseSingleFile) { //Process all views var sb = new StringBuilder(); sb.AppendLine("--DO NOT MODIFY THIS FILE. IT IS ALWAYS OVERWRITTEN ON GENERATION."); sb.AppendLine(); var grantSB = new StringBuilder(); foreach (var storedProcedure in _model.Database.CustomStoredProcedures.Where(x => x.Generated).OrderBy(x => x.Name)) { var template = new SQLSelectStoredProcedureTemplate(_model, storedProcedure, true, grantSB); sb.Append(template.FileContent); } //Add Grants sb.Append(grantSB.ToString()); var eventArgs = new ProjectItemGeneratedEventArgs("StoredProcedures.sql", sb.ToString(), ProjectName, this.ParentItemPath, ProjectItemType.Folder, this, true); eventArgs.Properties.Add("BuildAction", 3); OnProjectItemGenerated(this, eventArgs); } else { foreach (var storedProcedure in _model.Database.CustomStoredProcedures.Where(x => x.Generated).OrderBy(x => x.Name)) { var grantSB = new StringBuilder(); var template = new SQLSelectStoredProcedureTemplate(_model, storedProcedure, false, grantSB); //Add grants var sb = new StringBuilder(); sb.Append(template.FileContent); sb.Append(grantSB.ToString()); var fullFileName = template.FileName; var eventArgs = new ProjectItemGeneratedEventArgs(fullFileName, template.FileContent, ProjectName, this.ParentItemPath, ProjectItemType.Folder, this, true); eventArgs.Properties.Add("BuildAction", 3); OnProjectItemGenerated(this, eventArgs); } } var gcEventArgs = new ProjectItemGenerationCompleteEventArgs(this); OnGenerationComplete(this, gcEventArgs); } catch (Exception ex) { throw; } }