![\"\"](\"http:\/\/www.yazilimmutfagi.com\/wp-content\/uploads\/2020\/04\/Untitled1-3.png\")
<\/figure>\n\n\n\n- int[] Sayilar1 = new int[] { 1, 2, 3, 4, 5}<\/li>
- int[] Sayilar2 = new int[] { 1, 3, 7, 7, }<\/li>
- string[] Renkler= new string[] {“Beyaz”,”Mor”}<\/li><\/ul>\n\n\n\n
1 – Where Kullan\u0131m\u0131<\/strong> <\/h3>\n\n\n\n
Where<\/strong> kullan\u0131m\u0131 , t\u0131pk\u0131 SQL de oldu\u011fu gibi liste ya da tablolarda filtreleme yapmak i\u00e7in kullan\u0131l\u0131r. Temel olarak “e\u015fit<\/strong>“, “e\u015fit de\u011fil<\/strong>“, “b\u00fcy\u00fck<\/strong>“, “k\u00fc\u00e7\u00fck<\/strong>” gibi ifadeler kullan\u0131labildi\u011fi gibi \u00f6zel ifadelerin de kullan\u0131m\u0131 vard\u0131r. \u00d6zel ifadeler i\u00e7in \u00f6rnekler verilecektir.<\/p>\n\n\n\n
Temel kullan\u0131m\u0131na ait basit \u00f6rnek:<\/p>\n\n\n\n
IEnumerable<City> CityList = City.Where(x => x.CounytyId == 1);<\/code><\/pre>\n\n\n\nSonu\u00e7 : Hannover ve M\u00fcnih\u2019in bulundu\u011fu City listesini d\u00f6nd\u00fcr\u00fcr.<\/p>\n\n\n\n
IEnumerable SayiListesi = Sayilar1.Where(x => x >= 3);<\/code><\/pre>\n\n\n\nSonu\u00e7 : {3, 4, 5} listesini d\u00f6nd\u00fcr\u00fcr.<\/p>\n\n\n\n
\u00d6rnekte g\u00f6r\u00fcld\u00fc\u011f\u00fc \u00fczere, Filtreleme yap\u0131lmak istenen tablo ya da liste ismi yaz\u0131larak, yan\u0131na \u201cwhere<\/strong>\u201d ifadesi eklenip, parantez i\u00e7inde de istenilen filtreleme i\u015flemi yap\u0131l\u0131r. Burada dikkate edilecek ilk ifade \u201c=><\/strong>\u201d ifadesidir. Linq da lambda ifadeleri yazabilmek i\u00e7in, bu i\u015faret kombinasyonu kullan\u0131l\u0131r. \u0130kinci olarak da \u201c==<\/strong>\u201d ifadesi kullan\u0131m\u0131d\u0131r. Lamda kullan\u0131m\u0131nda \u201c=<\/strong>\u201d ifadesi atama yapmak i\u00e7in kullan\u0131l\u0131r.<\/p>\n\n\n\n
<\/p>\n\n\n\n
2 – OrderBy \/ OrderByDescending \/ ThenBy Kullan\u0131m\u0131<\/strong> <\/h3>\n\n\n\n
Sorgular\u0131m\u0131z\u0131 artan \u015fekilde s\u0131ralamak i\u00e7in \u201cOrderBy<\/strong>\u201d, azalan \u015fekilde s\u0131ralamak i\u00e7in ise \u201cOrderByDescending<\/strong>\u201d ifadelerini kullan\u0131r\u0131z. Ayn\u0131 sorgu i\u00e7inde birden fazla s\u0131ralama i\u015flemi yapmak i\u00e7in ise, \u201cThenBy<\/strong>\u201d ve \u201cThenByDescending<\/strong>\u201d ifadelerini kullan\u0131r\u0131z.<\/p>\n\n\n\n
\u00d6rnek Olarak:<\/p>\n\n\n\n
IEnumerable<City> CityList = City.Where(x => x.CounytyId == 3)\n.OrderBy(x=>x.CityName).ThenBy(x=>x.CounytyId);<\/code><\/pre>\n\n\n\nSonu\u00e7 : {6, \u201dAnkara\u201d, 3} , {3, \u201dBolu\u201d, 3} , {4, \u201dDenizli\u201d ,3}<\/p>\n\n\n\n
<\/p>\n\n\n\n
3 – Select Kullan\u0131m\u0131<\/strong> <\/h3>\n\n\n\n
Liste i\u00e7erisinden sadece belirledi\u011fimiz de\u011ferlerin listesini d\u00f6nd\u00fcrmek i\u00e7in kullan\u0131l\u0131r. <\/p>\n\n\n\n
<\/p>\n\n\n\n
\u00d6rnek Olarak:<\/p>\n\n\n\n
IEnumerable<String> x = City.Where(x => x.CounytyId == 1)\n.Select(p => p.CityName);<\/code><\/pre>\n\n\n\nSonu\u00e7 :{\u201dHannover\u201d , \u201d M\u00fcnih\u201d}<\/p>\n\n\n\n
var Cities =prod City.Where(x => x.CounytyId == 1)\n.Select(x => new { x.Id, x.CityName}).ToList();<\/code><\/pre>\n\n\n\nSonu\u00e7 : {1, \u201dHannover\u201d} , {5, \u201dM\u00fcnih\u201d} <\/p>\n\n\n\n
<\/p>\n\n\n\n
4 – SelectMany Kullan\u0131m\u0131<\/strong><\/h3>\n\n\n\n
Birden fazla tablo ya da veri kayna\u011f\u0131n\u0131 birle\u015ftirip tek bir liste i\u00e7inde g\u00f6stermek i\u00e7in bu ifade kullan\u0131l\u0131r. Sql de bulunan Cross Join<\/strong> i\u015flemine benzer. <\/p>\n\n\n\n
\u00d6rnek Olarak:<\/p>\n\n\n\n
var Cities= Country.SelectMany(x=> Sayilar2,\n(x,y) => new{Sayi = x, Renk = y});<\/code><\/pre>\n\n\n\nSonu\u00e7 : {1,”Beyaz”} , {3,”Beyaz”} , {7,”Beyaz”} , {7,”Beyaz”} , {1,”Mor”} , {3,” Mor “} , {7,” Mor “} , {7,” Mor “} <\/p>\n\n\n
\n<\/p>\n\n\n
5 –<\/strong> Join Kullan\u0131m\u0131<\/strong><\/h3>\n\n\n\n
Birden fazla tablo ya da veri kayna\u011f\u0131n\u0131 belirli bir anahtar de\u011fere g\u00f6re birle\u015ftirip tek bir liste i\u00e7inde g\u00f6stermek i\u00e7in bu ifade kullan\u0131l\u0131r. SQL de bulunan inner join<\/strong> i\u015flemine benzer.<\/p>\n\n\n\n
\u00d6rnek Olarak:<\/p>\n\n\n\n
var SayiListesi= Sayilar1.Join(Sayilar2, x => x, y => y,\n (x,y) => x);<\/code><\/pre>\n\n\n\nSonu\u00e7 : {1, 3} <\/p>\n\n\n
\n<\/p>\n\n\n
6 – GroupJoin Kullan\u0131m\u0131<\/strong><\/h3>\n\n\n\n
Birden fazla tablo ya da veri kayna\u011f\u0131n\u0131, belirli bir anahtar de\u011fere g\u00f6re gruplayarak birle\u015ftirip tek bir liste i\u00e7inde g\u00f6stermek i\u00e7in bu ifade kullan\u0131l\u0131r. Sql de bulunan left outer join <\/strong>i\u015flemine benzer.<\/p>\n\n\n\n
\u00d6rnek Olarak:<\/p>\n\n\n\n
var CitiesOfCountries= Country.GroupJoin(City, x => x.Id, y => y.CountryId,\n (x,y)=> new{Country = x.CountryName, City = y.CityName});<\/code><\/pre>\n\n\n\nSonu\u00e7 : {“Almanya”,\u201dHannover\u201d} , {“Tokyo”,”Japonya”} , { “T\u00fcrkiye” ,”Bolu”} , { “T\u00fcrkiye” ,”Denizli”} , { “Almanya” ,\u201dM\u00fcnih\u201d} , { “T\u00fcrkiye” ,”Ankara”} <\/p>\n\n\n
\n<\/p>\n\n\n
7 – GroupBy Kullan\u0131m\u0131<\/strong><\/h3>\n\n\n\n
Liste i\u00e7indeki elemanlar\u0131, belirlenen anahtar de\u011fere veya ifadeye g\u00f6re gruplar.<\/p>\n\n\n\n
\u00d6rnek Olarak:<\/p>\n\n\n\n
var SayiListesi= Sayilar1.GroupBy(x => (x % 2 == 0));<\/code><\/pre>\n\n\n\nSonu\u00e7 : {true , {2, 4} } , { flase , {1, 3, 5} }<\/p>\n\n\n
\n<\/p>\n\n\n
8 – Contains Kullan\u0131m\u0131<\/strong> <\/h3>\n\n\n\n
Liste i\u00e7erisinde belirtilen eleman\u0131n olup olmad\u0131\u011f\u0131 bilgisini true\/false olarak d\u00f6ner. Farkl\u0131 bir kullan\u0131m olarak, “where<\/strong>” ifadesi i\u00e7inde de kullan\u0131l\u0131r.<\/p>\n\n\n\n
\u00d6rnek Olarak: <\/p>\n\n\n\n
IEnumerable SayiListesi = Sayilar1.Contains(3);<\/code><\/pre>\n\n\n\nSonu\u00e7 : true<\/p>\n\n\n\n
var Cities= City.Where(x => Sayilar2.Contains(x.Id))\n.Select(x=>x.CityName);<\/code><\/pre>\n\n\n\nSonu\u00e7 : {“Hannover” , “Bolu”} <\/p>\n\n\n
\n<\/p>\n\n\n
9 – All \/Any Kullan\u0131m\u0131<\/strong> <\/h3>\n\n\n\n
“All<\/strong>” ifadesi, liste i\u00e7erisindeki t\u00fcm elemanlar i\u00e7in, belirtilen ko\u015fulun sa\u011flan\u0131p sa\u011flanmad\u0131\u011f\u0131 bilgisini true\/false olarak d\u00f6ner. “Any<\/strong>” ifadesi ise, listedeki herhangi bir de\u011ferin, ko\u015fulu sa\u011flay\u0131p sa\u011flamad\u0131\u011f\u0131 bilgisini true\/false olarak d\u00f6ner.<\/p>\n\n\n\n
\u00d6rnek Olarak: <\/p>\n\n\n\n
IEnumerable SayiListesi = Sayilar1.All(x => x % 2 == 0);<\/code><\/pre>\n\n\n\nSonu\u00e7 : false<\/p>\n\n\n\n
var City= City.Any(n => n.StartsWith(\"B\"));<\/code><\/pre>\n\n\n\nSonu\u00e7 : true<\/p>\n\n\n\n
10 –<\/strong> Take \/<\/strong> TakeWhile<\/strong> Kullan\u0131m\u0131<\/strong> <\/h3>\n\n\n\n
“Take<\/strong>” komutu, liste i\u00e7inden ba\u015ftan istedi\u011fimiz kadar eleman\u0131 d\u00f6nd\u00fcrmeyi, “TakeWhile<\/strong>” ise, belirtilen filtreleme i\u015flemine kadar olan elemanlar\u0131 d\u00f6nd\u00fcrmeyi sa\u011flar.<\/p>\n\n\n\n
\u00d6rnek Olarak: <\/p>\n\n\n\n
IEnumerable SayiListesi = Sayilar1.Take(3);<\/code><\/pre>\n\n\n\nSonu\u00e7 : {1, 2, 3} <\/p>\n\n\n\n
IEnumerable SayiListesi = Sayilar1.TakeWhile(x => x<3);<\/code><\/pre>\n\n\n\nSonu\u00e7 : {1, 2} <\/p>\n\n\n
<\/p>\n\n\n
11 – Skip \/ SkipWhile<\/strong> Kullan\u0131m\u0131<\/strong> <\/h3>\n\n\n\n
“Skip<\/strong>” komutu, liste i\u00e7inden belirtti\u011fimiz say\u0131daki eleman\u0131 atlay\u0131p, kalan listeyi d\u00f6nd\u00fcrmeyi, “SkipWhile<\/strong>” ise, belirtilen filtreleme i\u015flemi kadar eleman\u0131 atlay\u0131p, kalan listeyi d\u00f6nd\u00fcrmeyi sa\u011flar.<\/p>\n\n\n\n
\u00d6rnek Olarak: <\/p>\n\n\n\n
IEnumerable SayiListesi = Sayilar1.Take(3);<\/code><\/pre>\n\n\n\nSonu\u00e7 : {4, 5} <\/p>\n\n\n\n
IEnumerable SayiListesi = Sayilar1.TakeWhile(x => x<3);<\/code><\/pre>\n\n\n\nSonu\u00e7 : {3, 4, 5} <\/p>\n\n\n\n