There is also a video version of this tutorial.
Let’s understand it with example.
int[] nums1 = [1, 2, 3, 4];
int[] nums2 = [3, 4, 5, 6];
IEnumerable<int>? product = nums1.Zip(nums2, (n1, n2) => n1 * n2);
Console.WriteLine(string.Join(", ", product)); // 3, 8, 15, 24
Let’s break it down:
IEnumerable<int>? product = nums1.Zip(nums2, (n1, n2) => n1 * n2);
It takes nums1[i] and nums2[i], evaluates it (nums1[0]*nums2[0]) and returns it. Here i is the index of the array. For example.
Show all departments with total number of employees. Do not skip the departments which have 0 employees. As shown below:
DepartmentIdNameTotalEmployees1Engineering22Marketing13HR0
I have applied various queries and checked their equivalent sql.
This query does not meet my requirement. It would be a good choice if I don’t need departments without any employees.
[Read More]
NOTE: You can find the source code here.
// Department
public class Department
{
public int DepartmentId { get; set; }
public string Name { get; set; } = string.Empty;
public ICollection<Employee> Employees { get; set; } = [];
}
// Employee
public class Employee
{
public int EmployeeId { get; set; }
public string Name { get; set; } = string.Empty;
public int DepartmentId { get; set; }
public Department Department { get; set; } = null!;
public ICollection<EmployeeSkill> EmployeeSkills { get; set; } = [];
}
// Skills
public class Skill
{
public int SkillId { get; set; }
public string Name { get; set; } = string.Empty;
public ICollection<EmployeeSkill> EmployeeSkills { get; set; } = [];
}
// EmployeeSkills (Junction table)
public class EmployeeSkill
{
public int EmployeeId { get; set; }
public int SkillId { get; set; }
public Employee Employee { get; set; } = null!;
public Skill Skill { get; set; } = null!;
}
In simpler terms:
[Read More]