Referencing a foreign key in a DBSet [Answered]

private static Product PromptForItem()
    {
        // Instance Variable
        var indexNumber = 0;

        // Connects to the database
        using var database = new DatabaseModel();

        // Gets a collection of categories from "Categories" table
        var availableCategory = database.Categories.Select(x => x.CategoryName);
        Console.WriteLine("The available categories are: \n");

        // Displays available categories to choose from
        foreach (var categories in availableCategory)
        {
            indexNumber += 1;
            Console.WriteLine($"{indexNumber}: {categories}\n");
        }

        // Gets user input and parses it to a category
        Console.Write("Category Number: ");
        var categoryNumber = Convert.ToInt32(Console.ReadLine());
        var chosenCategory =
            database.Categories.Find(categoryNumber); // Which contains the primary key for the reference key

        // Gets a collection of products from "ProductProperties" table
        var availableProductRecords = database.ProductCatalogues.Where(x => x.Category == chosenCategory);
        var availableProducts = availableProductRecords.Select(x => x.ENname).ToList();

        // Displays available products to choose from the specified category
        for (var i = 0; i < availableProducts.Count; i++) Console.WriteLine($"{i}: {availableProducts[i]}");

        // Prompt user for a product
        var productNumber = Convert.ToInt32(Console.ReadLine());
        var chosenProductString = availableProducts[productNumber];

        // Gets the product the user has chosen
        var chosenProduct = availableProductRecords.Single(x => x.ENname == chosenProductString);
        return chosenProduct;
    }

private static Product PromptForItem()
    {
        // Instance Variable
        var indexNumber = 0;

        // Connects to the database
        using var database = new DatabaseModel();

        // Gets a collection of categories from "Categories" table
        var availableCategory = database.Categories.Select(x => x.CategoryName);
        Console.WriteLine("The available categories are: \n");

        // Displays available categories to choose from
        foreach (var categories in availableCategory)
        {
            indexNumber += 1;
            Console.WriteLine($"{indexNumber}: {categories}\n");
        }

        // Gets user input and parses it to a category
        Console.Write("Category Number: ");
        var categoryNumber = Convert.ToInt32(Console.ReadLine());
        var chosenCategory =
            database.Categories.Find(categoryNumber); // Which contains the primary key for the reference key

        // Gets a collection of products from "ProductProperties" table
        var availableProductRecords = database.ProductCatalogues.Where(x => x.Category == chosenCategory);
        var availableProducts = availableProductRecords.Select(x => x.ENname).ToList();

        // Displays available products to choose from the specified category
        for (var i = 0; i < availableProducts.Count; i++) Console.WriteLine($"{i}: {availableProducts[i]}");

        // Prompt user for a product
        var productNumber = Convert.ToInt32(Console.ReadLine());
        var chosenProductString = availableProducts[productNumber];

        // Gets the product the user has chosen
        var chosenProduct = availableProductRecords.Single(x => x.ENname == chosenProductString);
        return chosenProduct;
    }

using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using Microsoft.EntityFrameworkCore;

namespace CoffeeShop_POS_Project_with_EF_Core.Domain;

[Table("Product Catalogue")]
public class Product
{
    // Miscellaneous Information
    public Categories Category; // Each product belongs to a category
    public int ProductId { get; set; }

    // Name of the product
    [MaxLength(100)] [Unicode(false)] public string ENname { get; set; }
    [MaxLength(100)] public string? VNname { get; set; }
    public List<ProductProperties> ProductVariantsList { get; set; } // Each product has 3 of it's own variations
    public bool Recommended { get; set; } // Recommended or not
}

using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using Microsoft.EntityFrameworkCore;

namespace CoffeeShop_POS_Project_with_EF_Core.Domain;

[Table("Product Catalogue")]
public class Product
{
    // Miscellaneous Information
    public Categories Category; // Each product belongs to a category
    public int ProductId { get; set; }

    // Name of the product
    [MaxLength(100)] [Unicode(false)] public string ENname { get; set; }
    [MaxLength(100)] public string? VNname { get; set; }
    public List<ProductProperties> ProductVariantsList { get; set; } // Each product has 3 of it's own variations
    public bool Recommended { get; set; } // Recommended or not
}

public Categories Category { get; set; }

public Categories Category { get; set; }

public Categories Category { get; set; }
public int CategoryId { get; set; }

public Categories Category { get; set; }
public int CategoryId { get; set; }

public Categories Category { get; set; }
public int CategoriesId { get; set; }

public Categories Category { get; set; }
public int CategoriesId { get; set; }