Adaface Sample Entity Framework Questions

In an Entity Framework Core project, you're working on an e-commerce application where products can be 'soft deleted'. A soft deleted product is not physically removed from the database, but is flagged as deleted and should not appear in normal query results. Assume that your Product model includes an IsDeleted boolean property.
            
            Your task is to implement a global query filter to exclude soft deleted products from all queries throughout the application.
            
            Which of the following is the correct way to implement this requirement in your DbContext derived class, ProductContext?

In an Entity Framework Core project, you have two related entities, Product and Category. Each Product entity has a navigation property Category that represents the Category entity associated with the product.
            
            You have the following code that retrieves a product:

The Product and Category entities are defined as follows:

You call the GetProduct method and then access the Category.Name property of the returned Product entity. What will happen?

A: The Category.Name property will have the name of the category associated with the product.
            B: The Category.Name property will be null
            C: An NullReferenceException error will be thrown when accessing the Category.Name property.
            D: The Category.Name property will have the default value for a string

In an Entity Framework Core project, you are tasked with managing transactional operations within a ProductService. Assume the database context, DbContext, is injected into ProductService. You need to ensure that an operation updating the stock quantity of a product is atomic. If any error occurs during this operation, the changes must not be saved to maintain data integrity.
            
            Given the following code snippet for the UpdateStock method, which is the correct way to achieve this?