using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace MonPremierProjetLinq2
{
	class Program
	{
		static void Main(string[] args)
		{
			var query = from process in System.Diagnostics.Process.GetProcesses()
						orderby process.ProcessName ascending
						select process;

			foreach (var currentItem in query.ToList())
			{
				Console.WriteLine(currentItem.ProcessName);
			}

			Console.Read();
		}
	}
}

public static IEnumerable<T> Cast<T>(this IEnumerable source);

System.Collections.ArrayList myArrayList = new System.Collections.ArrayList();

// Ajout d'instances de type Process dans notre ArrayList
// ...

var query = from process in myArrayList.Cast<System.Diagnostics.Process>()
			select process;

public static IEnumerable TResult OfType<TResult>(this IEnumerable source);

System.Collections.ArrayList myArrayList = new System.Collections.ArrayList();
myArrayList.Add(System.Drawing.Color.Red);
myArrayList.Add(new System.Drawing.Point(0, 0));
myArrayList.Add(System.Drawing.Color.Green);
myArrayList.Add(new System.Drawing.Point(10, 20));
myArrayList.Add(System.Drawing.Color.Blue);
myArrayList.Add(new System.Drawing.Point(20, 30));

var query = from color in myArrayList.OfTypeSystem.Drawing.Color()
			select color;

foreach (var currentResult in query)
	Console.WriteLine(currentResult.Name);

class Program
{
	static void Main(string[] args)
	{
		List<string> aMembres= new List<string>()
				   {
					   "Jérôme", 
					   "Louis-Guillaume", 
					   "Vincent", 
					   "Benjamin"
				   };

		var query = from membre in aMembres
					orderby membre ascending
					select membre;

		foreach (string currentMembre in query)
		{
			Console.WriteLine(currentMembre);
		}

		Console.Read();
	}
}

class Program
{
	static void Main(string[] args)
	{
		List<string> aMembres= new List<string>()
				   {
					   "Jérôme", 
					   "Louis-Guillaume", 
					   "Vincent", 
					   "Benjamin"
				   };

		var query = from membre in aMembres
					orderby membre ascending
					select membre;

		Console.WriteLine("Résultat query Avant");
		Console.WriteLine("********************");
		foreach (string currentMembre in query)
		{
			Console.WriteLine(currentMembre);
		}

		aMembres.Add("Thomas");

		Console.WriteLine("\nRésultat query Après");
		Console.WriteLine("********************");
		foreach (string currentMembre in query)
		{
			Console.WriteLine(currentMembre);
		}

		Console.Read();
	}
}

class Program
{
	static void Main(string[] args)
	{
		List[string] aMembres= new List[string]()
				   {
					   "Jérôme", 
					   "Louis-Guillaume", 
					   "Vincent", 
					   "Benjamin"
				   };

		var query = from membre in aMembres
					orderby membre ascending
					select membre;

		Console.WriteLine("Résultat query Avant");
		Console.WriteLine("********************");
		foreach (string currentMembre in query)
		{
			Console.WriteLine(currentMembre);
		}

		// Mise à  jour des membres
		aMembres[0] = aMembres[0] + " Lambert";
		aMembres[1] = aMembres[1] + " Morand";
		aMembres[2] = aMembres[2] + " Lainé";
		aMembres[3] = aMembres[3] + " Broux";

		Console.WriteLine("\nRésultat query Après");
		Console.WriteLine("********************");
		foreach (string currentMembre in query)
		{
			Console.WriteLine(currentMembre);
		}

		Console.Read();
	}
}

var query = System.Diagnostics.Process.GetProcesses()
			.Where(p => p.ProcessName.ToLower().StartsWith("a"))
			.OrderBy(p => p.ProcessName)
			.Select(p => p.ProcessName);

var query = System.Diagnostics.Process.GetProcesses()
			.Where(p => p.ProcessName.StartsWith("A"))
			.OrderBy(p => p.ProcessName)
			.Select(p => p);

var query = from process in System.Diagnostics.Process.GetProcesses()
			where process.ProcessName.StartsWith("A")
			orderby process.ProcessName ascending
			select process;

var query = System.Diagnostics.Process.GetProcesses().Where(p => p.ProcessName.ToLower().StartsWith("a")).Select(p => p);

var query = from process in System.Diagnostics.Process.GetProcesses()
			where process.ProcessName.ToLower().StartsWith("a")
			select process;

static void Main(string[] args)
{
	var membres = GetMembres();

	var query = from membre in membres
				group membre by new { membre.Sexe, membre.Age }
					into grouping
					select new
					{
						Sexe = grouping.Key.Sexe,
						Age = grouping.Key.Age,
						Membres = grouping
					};

	foreach (var currentResult in query)
	{
		Console.WriteLine("Membres dont sexe est '{0}' et âge = '{1}'", currentResult.Sexe, currentResult.Age);
		foreach (var currentMembre in currentResult.Membres)
		{
			Console.WriteLine(currentMembre.Nom);
		}
		Console.WriteLine();
	}

	Console.Read();
}

var query = from membre in membres
			 where membre.Sexe == 'N'
			 select membre;

static void Main(string[] args)
{
	var MembreHommes = GetMembres('H');
	var MembreFemmes = GetMembres('F');
}

static List<Membreégt; GetMembres(char sexe)
{
	var membres = GetMembres();

	var query = from membre in membres
				where membre.Sexe == sexe
				select membre;

	return query.ToList();
}