DevBytes: A Blog by Tony Collett

DevBytes: A Blog by Tony Collett

Sign in Subscribe

MSSQL Broker

Simple one, and this is mainly just for my reference, when restoring a Database in MSSQL, the database will likely keep it's Broker ID. If you're just restoring, then that should be fine, but if you're duplicating a Database, then you will need to

Nullability in C#

Nullability in C#

In the grand scheme of programming languages, C# has a rather special quirk: reference types (classes, interfaces, etc.) can inherently be null. This means a variable that's supposed to hold an object might actually hold nothing at all. It's the programming equivalent of expecting a fancy

Papercut SMTP: Your Simplified Email Testing Solution

Papercut SMTP: Your Simplified Email Testing Solution

Implementing a simplified SMTP Solution for testing your Applications

Choosing the Right Collection for Your Needs

Choosing the Right Collection for Your Needs

We are going to untangle a common source of confusion among C# developers—using Dictionaries, ILookups, and Tuples effectively. These structures are powerful when used correctly, but a misstep in choosing the wrong one for your use case can lead to inefficiencies or convoluted code.

Understanding Dependency Injection in C#

Understanding Dependency Injection in C#

Demystifying Dependency Injection Dependency Injection (DI) is a fancy term for a straightforward concept. At its core, it’s a way of managing the components your code relies on without making your code a tangled mess. Think of it as good organization and planning for your software project. The Dependency

The Benefits of Keeping Inbox Zero and How to Get Started

The Benefits of Keeping Inbox Zero and How to Get Started

What is Inbox Zero? Inbox Zero is a method of email management that aims to keep your inbox empty or nearly empty at all times. This is achieved by processing each email as soon as you receive it, and either deleting it, archiving it, or delegating it to someone else.

Constants in C#

Constants in C#

Simple little topic today, something I’ve been using a lot lately as I’ve been converting existing hard-coded strings and integers to private constants. Constants are immutable values that are known at compile time and cannot be changed for the life of the program. They are declared with

Why migrations in Entity Framework should be historical

Why migrations in Entity Framework should be historical

Entity Framework migrations are a powerful tool for managing schema changes in your database. They allow you to make changes to your database schema in a controlled and safe manner, and to roll back changes if necessary. One of the key benefits of Entity Framework migrations is that they should

Embracing the Google Ecosystem

In the ever-evolving world of technology, making a switch from one tech giant’s ecosystem to another can be a significant decision. For years, Microsoft has been a household name, with products like Windows, Office 365, and OneDrive dominating the business and personal computing landscape. However, as the digital

Choosing the Right Date and Time Type in C#

Choosing the Right Date and Time Type in C#

C# provides a number of different date and time types, each with its own strengths and weaknesses. The most common types are DateTime, DateTimeOffset, DateOnly, and TimeOnly. DateTime is the most general-purpose date and time type. It represents a point in time, typically expressed as a date and time

Using DiffDays in SQL and LINQ Queries

Using DiffDays in SQL and LINQ Queries

The DiffDays function is a useful tool for calculating the number of days between two dates. It can be used in both SQL and LINQ queries to check the dates of properties in tables. To use DiffDays in a SQL query, you can use the following syntax: SELECT * FROM table

Searching all MSSQL Tables for a Specific String

Source: Find a string by searching all tables in SQL Server – Stack Overflow I recently found myself wanting to find all locations my email address was in a test database so I could remove it (to stop the testing spam). After a few attempts, I found this query from the

The New Threads App: A Better Alternative to Twitter

The New Threads App: A Better Alternative to Twitter

In recent months, Elon Musk has been making some major changes to Twitter. He has fired top executives, rolled back content moderation policies, and even made it more difficult for users to report spam and abuse. As a result, myself and many people are looking for a new social media

Leveraging Command and Query Methods in Entity Framework for Effective Data Retrieval and Updates

Leveraging Command and Query Methods in Entity Framework for Effective Data Retrieval and Updates

When it comes to software development, handling data efficiently is a big deal. Especially when dealing with databases and cool stuff like Entity Framework. So, let’s dive into this thing called Command and Query Responsibility Segregation (CQRS) and see how it can make your life easier with Entity Framework.

Reddit's Decline and My Journey to Embrace RSS

G’day, mates! Today, I want to share my thoughts on an internet phenomenon that has taken a bit of a tumble in recent times – Reddit. As an avid Redditor, I’ve witnessed its rise to fame and its subsequent fall from grace. Now, I’m on a quest to