schwarriors-code-toolbox

█▀ █▀▀ █░█ █░█░█ ▄▀█ █▀█ █▀█ █ █▀█ █▀█ ▀ █▀
▄█ █▄▄ █▀█ ▀▄▀▄▀ █▀█ █▀▄ █▀▄ █ █▄█ █▀▄ ░ ▄█

█▀▀ █▀█ █▀▄ █▀▀
█▄▄ █▄█ █▄▀ ██▄

▀█▀ █▀█ █▀█ █░░ █▄▄ █▀█ ▀▄▀
░█░ █▄█ █▄█ █▄▄ █▄█ █▄█ █░█

Welcome

This is a library of reusable solutions for software development.

Overview

The library is mostly code snippets in a variety of languages.

Over the last 25 years working as a software developer and a DBA, I found myself returning to the patterns and solutions in this toolbox again and again.

The sample code files that comprise the library can be found in the lib folder.

Experimental code explorations can be found in the lab folder.

Reference documents are found in the ref folder. These are resources created and maintained by other parties.

There are also utility scripts used for mantaining the library. See the util folder folder.

Development Roadmap

1. Experiment with the GitHub repo search functionality. Will it recognize and index meta-information and tags inside of the code commentary? Does it work for all the major file types in the toolbox?
2. Develop a utility that will create a code comment flowerbox at the top of each file. For C# an VB code files, the flowerbox could be in the .NET XML documentation format.Populate the flowerbox with keywords that currently bloat the lib file names. Add additional tags indicating the target computer language and platform (for example: Language: C#. Platform: LinqPad).
3. Rename all the of lib files. Now freed of needing the file name to be an index of all relevant patterns and technologies, use shorter and simpler names that focus on describing the software feature that the code could be used to develop.
4. Find others who have created similiar projects. Discover how to grow this library from personal use into something that can benifit lots of developers around the world.
5. Consult with someone who has studied library science and computer science. What organizational systems would allow the toolbox to become much bigger without becoming bloated, unwieldy and outdated ?

File Tagging

Add the following tags, in comment (as defined for file type) to top of file

• meta-language: C#, VB.Net, JavaScript
• meta-platform: LinqPad, Angular, WinForms
• meta-pattern (optional tag): factory, mvc
• meta-keyworks: using, dispose, garbage collection

Code to add to the library

• SQL Server CRUD Proc Generator
• SQL Server Class from Table Generator
• SQL Server full maintenance job specification
• SQL Profiler setup for ORM analysis
• SQL Server Recursive CTE
• SQL Server Grouping Sets
• Programatic management of SQL Agent jobs
• SSRS SQL Server Reporting Service Rollup report
• SSRS Grouping with Page Nuhmbers on print view
• SSIS SQL Server Integration Service custom log message - script example
• SSIS custom error handling script example
• SSIS interact with external program example
• Entity Framework how to output SQL from Visual Studio - console
• .Net Core reading settings
• .Net Core logging
• C# Sample Extension Method
• C# invoking synchronous tasks from asynchronous methods
• C# invoking asynchronous tasks from synchronous methods
• C# Date and number format samples
• C# Data type cheat sheet
• C# Keyword cheat sheet
• VB.Net lamba expression syntax
• How to host SSRS Report in ASP.NET MVC via an embedded - ASP.NET WebForm with a report control
• ASP.NET MVC client-side field validation
• ASP.NET MVC server side model validation
• ASP.NET Script Packaging
• ASP.NET MVC Examples of ways to use partial views
• ASP.NET MVC Example grid with paging, filtering and multi-select
• Angular Example grid with paging, filtering and multi-select
• Angular RxJS examples
• ASP.NET MVC Razor select and combo examples
• ASP.NET Web Service configure to use JSON instead of XML
• ASP.NET Web Service authentication authorization and membership. Both stateful and restful forms.
• ASP.NET Web Service RESTful controller example
• Interacting with external Web Service as a client in .NET using RestSharp.
• DHTML Pop-up / Pop-over samples
• DHTML IFrame samples
• DHTML Sample Page Layouts
• Sample Regular Expressions: remove line breaks, find email addresses, strip html tags
• Angular site theming
• Angular theme viewer
• Angular modals
• Powershell register Windows Services
• Consolidate windows / restore lost windows WinForm code