using System; using System.Collections; using System.Collections.Generic; using System.Text; using System.Linq; using System.Reflection; class Person { int _id; int _idRole; string _lastName; string _firstName; public int ID { get { return _id; } set { _id = value; } } public int IDRole { get { return _idRole; } set { _idRole = value; } } public string LastName { get { return _lastName; } set { _lastName = value; } } public string FirstName { get { return _firstName; } set { _firstName = value; } } } class Role { int _id; string role; public int ID { get { return _id; } set { _id = value; } } public string Role { get { return role; } set { role = value; } } } class Program { static void Main(string[] args) { List<Person> people = new List<Person> { new Person { ID = 1, IDRole = 1, LastName = "A", FirstName = "B"}, new Person { ID = 2, IDRole = 2, LastName = "G", FirstName = "T"}, new Person { ID = 3, IDRole = 2, LastName = "G", FirstName = "M"}, new Person { ID = 4, IDRole = 3, LastName = "C", FirstName = "G"} }; List<Role> roles = new List<Role> { new Role { ID = 1, Role = "Manager" }, new Role { ID = 2, Role = "Developer" } }; var query = people .Where(p => p.ID == 1) .SelectMany(p => roles .Where(r => r.ID == p.ID) .Select(r => new { p.FirstName, p.LastName, r.Role })); } }
Author: coder
Min with string property value
using System; using System.Linq; using System.Collections; using System.Collections.Generic; public class Employee { public int birthYear; public string firstName; public string lastName; public static Employee[] GetEmployees() { Employee[] actors = new Employee[] { new Employee { birthYear = 1964, firstName = "K", lastName = "R" }, new Employee { birthYear = 1968, firstName = "O", lastName = "W" }, new Employee { birthYear = 1960, firstName = "J", lastName = "S" }, new Employee { birthYear = 1964, firstName = "S", lastName = "B" }, }; return (actors); } } public class MainClass { public static void Main() { string firstAlphabetically = Employee.GetEmployees().Min(a => a.lastName); Console.WriteLine(firstAlphabetically); } }
use Min to get the lowest number in an integer array.
using System; using System.Collections.Generic; using System.Linq; using System.Text; public class MainClass { public static void Main() { int[] numbers = { 5, 4, 1, 3, 9, 8, 6, 7, 2, 0 }; int minNum = numbers.Min(); Console.WriteLine("The minimum number is {0}.", minNum); } }
uses Min to get the length of the shortest word in a string array.
using System; using System.Collections.Generic; using System.Linq; using System.Text; public class MainClass { public static void Main() { string[] words = { "cherry", "apple", "blueberry" }; int shortestWord = words.Min(w => w.Length); Console.WriteLine("The shortest word is {0} characters long.", shortestWord); } }
Min with object property
using System; using System.Linq; using System.Collections; using System.Collections.Generic; public class Employee { public int birthYear; public string firstName; public string lastName; public static Employee[] GetEmployees() { Employee[] actors = new Employee[] { new Employee { birthYear = 1964, firstName = "Keanu", lastName = "Reeves" }, new Employee { birthYear = 1968, firstName = "Owen", lastName = "Wilson" }, new Employee { birthYear = 1960, firstName = "James", lastName = "Spader" }, new Employee { birthYear = 1964, firstName = "Sandra", lastName = "Bullock" }, }; return (actors); } } public class MainClass { public static void Main() { int oldestEmployeeAge = Employee.GetEmployees().Min(a => a.birthYear); Console.WriteLine(oldestEmployeeAge); } }
Min with string value
using System; using System.Linq; using System.Collections; using System.Collections.Generic; public class MainClass { public static void Main() { string[] presidents = {"G", "H", "a", "H", "over", "Jack"}; string minName = presidents.Min(); Console.WriteLine(minName); } }
Max on object list
using System; using System.Linq; using System.Collections; using System.Collections.Generic; public class Employee { public int birthYear; public string firstName; public string lastName; public static Employee[] GetEmployees() { Employee[] actors = new Employee[] { new Employee { birthYear = 1964, firstName = "K", lastName = "R" }, new Employee { birthYear = 1968, firstName = "O", lastName = "W" }, new Employee { birthYear = 1960, firstName = "J", lastName = "S" }, new Employee { birthYear = 1964, firstName = "S", lastName = "B" }, }; return (actors); } } public class MainClass { public static void Main() { int youngestEmployeeAge = Employee.GetEmployees().Max(a => a.birthYear); Console.WriteLine(youngestEmployeeAge); } }