SQL joins allow our relational database management systems to be, well, relational. Joins allow us to re-construct our separated database tables back into the relationships that power our applications.

Often you might be interested in knowing how your LINQ Queries are translated to SQL Database in behind. The best way to profile ASP.NET Core, Entity Framework LINQ queries running on Azure SQL/ On-Premise SQL is to use Azure Data Studio.