Writing and testing custom OrderBy extension methods
Write and test an extension method to handle custom ordering on an IOrderedQueryable, based on a pre-defined ordering rule using enum values.
-
-
Populate column with values from another table in SQL
Add data to a new table column based on data from another table with MSSQL Server.
-
Asynchronously stream multiple sources into an AWS S3 bucket
Retrieve data from multiple locations and stream it into memory for upload to an AWS S3 bucket.
-
'func' is not recognized as an internal or external command
Fix for when Azure functions throw an error at runtime.
-
Large IFormFile file returns 400 Bad Request
The .NET framework default limits file uploads to 128mb. For anything larger than this, you need to increase the value in configuration.
-
Using dictionaries in .NET
Check for keys in a dictionary, and retrieve specific values.
-
Using tuples in C#
Define a method signature and return value for a tuple containing two or more values, and implement the values in calling code.
-
Extract schema or data from SQL Server database
With an existing database, you may occasionally need to extract sections of the table schema, or full data sets - both of which can be done using SQL Server Management Studio.
-
Validate month and day using express-validator
Validate an optional date field which requires on the month and day values using express-validator rules.
-
Detach sidebar on scroll using intersection observer
Fix a sidebar to the viewport when scrolling. When the header moves out of the viewport, fix the sidebar to the top of the viewport, then revert when the header comes back to view
-
Assert DateTime.Now/UtcNow equality with xUnit
When using DateTime.Now or DateTime.UtcNow comparisons in tests, you'll likely encounter failures caused by these values differing by a few milliseconds due to the code being processed at different times. Use this overload to include a permitted margin of error.
-
Vite: process is not defined
When your usual method of accessing environment variables doesn't work because you're using Vite.
-
Display MediaPicker images in Umbraco view
Easily load images defined in MediaPicker property editors into your MVC views.
-
Configure PostgreSQL for remote connections
Configure a PostgreSQL server for remote connections on your Windows server.
-
DNS Records for a Typical Website
Typical DNS records you might have configured on your domain registrar for a typical website. Including NS, SOA, A, CNAME, MX and TXT records.
-
MoqException: All invocations on the mock must have a corresponding setup
Troubleshoot this common Moq error message encountered when writing tests using MockBehavior.Strict.
-
Find what ports are being used
If you've ever tried running a web app locally and it's failed to start because the specified port was in use, this will help you identify the application using it, and get around it.
-
Handle CORS between client and server apps
Handle CORS between client and server apps using appropriate HTTP headers.
-
Generate a list of directory contents in PowerShell
If you've got a directory full of documents, music etc. which needs to be quickly summarised into a list of file names. Functions recursively to display items in a directory tree format.
-
NuGet Package upgrade issues
Resolve build issues which may occur from NuGet packages when upgrading project framework.
-
Remove tracked files from source control
Remove files from source control and ignore future changes so that they stop being tracked.
-
File name too long
Handling files in Windows or Git where the path and file name exceed the maximum default length.