I usually stay on the C# development of things, and rarely venture to create SQL statements/code, other than the occasional SELECT / UPDATE / INSERT. However, we have a requirement from our Product Management group to DELETE records permanently from the database. We have proper enforced foreign keys in our DB schema, so one option we have is to create a stored procedure to help deletion, which will walk thru the referencing foreign keys to the record being deleted and then also delete those records ......
Sometime in the past, a friend asked me how to update a control to show status while his code is doing a loop of stuff. Essentially changing the text of a label (or sophisticatedly we can say a text-based progress bar). In my past coding with MFC and WinForms, it's fairly easy enough, you just invalidate and do an update (Invalidate / UpdateWindow in MFC or Invalidate / Update in WinForms). This approach also coincides with how Windows UI operate, where you specify the region that needs to be redrawn ......
Every now and then I have a need to call a generic method, but I can't quite call it generically. Usually that particular situation involves needing to call a generic method, and I have the type for that generic method. There are various reasons/examples of why anyone would get to this point, in my case we have an infrastructure code that can deal with objects generically, but because it is infrastructure code, we can't have it refer to the actual entity classes that are in the higher layer/tier. ......