Find Tables with Keyword Names
I was working with an SQL Server schema and discovered that one of my tables was named with a keyword; SELECT u.*, a.* FROM [Bpm].User u INNER JOIN [Bpm].Account a ON u.Id = a.UserId WHERE u.Username = 'foo@exammple.com' Msg 156, Level 15, State 1, Line 2 Incorrect syntax near the keyword ‘User’. Turns out ‘User’ is a keyword and I needed to enclose it in square brackets: FROM [Bpm].[User] .... It’s probably best just to...
Quantum Computation Primer Part 1
Introduction The major cloud providers: Microsoft, Amazon, Google, IBM, and Oracle are racing to bring quantum computing as a service to their offerings. In addition, companies, universities, and even nation states are investing heavily. Why all the buzz? Quantum computers offer the potential to bring parallelism to calculations on a scale that cannot be matched by classical computers. They may enable us to model the quantum world, bringing breakthroughs in material science, medicine, you name...
Option Templates in UWP
Introduction Adding Options Sample Overview Exploring the .NET Standard Library Rendering Options in UWP Conclusion Introduction Just about every app needs a settings screen. A lot of developers choose to simply build-out static UI; hard-wiring buttons and text fields to a setting backing store. If one does this, however, eventually, as the number of settings grows, technical debt increases; making refactoring your settings screen into categories, or changing how the settings are stored or displayed,...
Asynchronous Commanding with Codon FX
Introduction Have you ever created a view-model for your app that contains an ICommand that needs to perform some asynchronous activity? Such as calling a web API or saving data to a file? If you have, you’ll know that the synchronous ICommand interface doesn’t lend itself easily to asynchronous operations. You end up having to build a mini-state-machine to disable and re-enable the command target when the command completes. Wouldn’t it be nice if commands...
Combining the UWP Community Toolkit with Codon FX
Introduction Creating a Custom Dialog Service Leveraging the UWP Community Toolkit Conclusion Introduction Codon FX is a cross-platform framework for building maintainable applications. I use it for all of my .NET based applications. Codon is built on .NET Standard and uses platform specific assemblies to support various platforms including UWP. Codon has no references to third-party libraries, keeping it light-weight and free from version conflicts. There is, however, nothing preventing you from enriching Codon with...