Resolving LINQ Query Issues with Composite Keys and Joining Multiple Tables in .NET Core Applications