A Day At Data Juggler headquarters- Fixing Bugs in DataTier.Net
Channel: Data Juggler
Date: 24/12/2020

This video is just me working on DataTier.Net.

The first 3 minutes is an animated clip made with IClone. I created the 3 characters using Reallusion Character Creator Headshot Plug-In.

It wasn't really a bug found in DataTier.Net, it was the fact I feel stupid that for 15 years I wrote using statements to the top of the Stored Procedure.cs files that are created when you build with DataTier.Net.

Things you might learn:

1. How to build a Windows Forms (desktop) application.
2. How to open text files, read all text in, and write out the file again after it is modified
3. How to work with interfaces
4. How to work with String Builder
5. How to get files recursively by extension
6. How to make videos and still not earn subscribers (prove me wrong).


The program we are working on is called DataTier.Net, an all stored procedure alternative to Entity Framework.

https://github.com/DataJuggler/DataTier.Net

I also demonstrate two Nuget packages, both for .Net 5:
DataJuggler.Win.Controls
DataJuggler.UltimateHelper

I also show a Visual Studio package called Regionizer you might find useful if you want to follow along:

Regionizer - The installer is located in the VSIX folder of this project:
https://github.com/DataJuggler/Regionizer

The app we build is very simple. 

1. Build a simple Windows Forms .Net 5 project, add Nuget packages and then add the controls for the LabelBrowserControl and LabelTextBoxControls which are part of DataJuggler.Win.Controls.

2. Select a folder and get all .cs files in that folder. I run into a problem at this part as I haven't used my FileHelper in a while and I forgot how some of this works. I pause the video and fixed it, but other than that the rest is me showing how I solve problems.

In parts of this video I am sure I get tired and mumble and it isn't very entertaining, but as the title says, welcome to a day in my life.