public override void Generate()
 {
     try
     {
         foreach (CustomStoredProcedure storedProcedure in _model.Database.CustomStoredProcedures.OrderBy(x => x.Name))
         {
             if (storedProcedure.Generated)
             {
                 DefinedStoredProcedureSelectCommandGeneratedTemplate template = new DefinedStoredProcedureSelectCommandGeneratedTemplate(_model, storedProcedure);
                 string fullParentName = RELATIVE_OUTPUT_LOCATION + template.ParentItemName;
                 ProjectItemGeneratedEventArgs eventArgs = new ProjectItemGeneratedEventArgs(template.FileName, template.FileContent, ProjectName, fullParentName, this, true);
                 OnProjectItemGenerated(this, eventArgs);
             }
         }
         ProjectItemGenerationCompleteEventArgs gcEventArgs = new ProjectItemGenerationCompleteEventArgs(this);
         OnGenerationComplete(this, gcEventArgs);
     }
     catch (Exception ex)
     {
         throw;
     }
 }
 public override void Generate()
 {
   try
   {
     foreach (CustomStoredProcedure storedProcedure in _model.Database.CustomStoredProcedures.OrderBy(x => x.Name))
     {
       if(storedProcedure.Generated)
       {
         DefinedStoredProcedureSelectCommandGeneratedTemplate template = new DefinedStoredProcedureSelectCommandGeneratedTemplate(_model, storedProcedure);
         string fullParentName = RELATIVE_OUTPUT_LOCATION + template.ParentItemName;
         ProjectItemGeneratedEventArgs eventArgs = new ProjectItemGeneratedEventArgs(template.FileName, template.FileContent, ProjectName, fullParentName, this, true);
         OnProjectItemGenerated(this, eventArgs);
       }
     }
     ProjectItemGenerationCompleteEventArgs gcEventArgs = new ProjectItemGenerationCompleteEventArgs(this);
     OnGenerationComplete(this, gcEventArgs);
   }
   catch(Exception ex)
   {
     throw;
   }
 }