In working one-on-one with many who are new to SQL, I see a lot of confusion on how to get started. In this post, I’ll give you a repeatable set of steps you can use to start writing basic SELECT queries.
You are browsing archives for
Author: Jo Barrett
Walkthrough: Building a SQL SELECT Query
A full walkthrough on building a SQL SELECT query using live data.
Concise Code with Top-Level Statements in C#
Top-level statements can look confusing to long-time .NET users, but it’s just a matter of hiding the plumbing code.
The contract has changed: Default Interface methods in C# 8.0
As long as I’ve been teaching object-oriented programming, I’ve drummed this phrase (or something like it) into my students’ heads, to get across how interfaces are different than classes: For classes: A subclass inherits from its superclass dynamically: As new members are added to the superclass, they are automatically available for the subclass (Based on […]
Entity Framework Custom Model Validation Attributes
In my training classes, students often can easily understand the benefits of validation attributes in their MVC Core application’s Model classes, as far as their use on individual model properties (Examples in this article are using MVC Core 3.1.1 on Visual Studio 2019) What you buy yourself here is client-side validation, as long as you […]