FirstOrDefault vs SingleOrDefault in EF Core: Which One Should You Use?

When working with Entity Framework Core, we often need to retrieve a single record from the database. For example: Fetch a customer by email. Get the latest order. Retrieve a user by their unique ID.