var query = context.Products .AddAlias("p") .Select(p => new { ProductName = p.Name, CategoryName = p.Category.Name });
var query = from p in context.Products.AddAlias("p") join c in context.Categories.AddAlias("c") on p.CategoryId equals c.Id select new { ProductName = p.Name, CategoryName = c.Name };This example uses the AddAlias method to create aliases for both the Products and Categories tables in the database. The query then performs an inner join between the two tables based on their respective foreign keys, and selects the product name and category name for each matching record. The exact package library for the AddAlias method may vary depending on the specific ORM (Object-Relational Mapping) framework being used. In the above examples, the context object suggests that the queries are being executed using the Entity Framework, which is a popular ORM framework for .NET applications.