<\/div>\n

Linq To Sql, sadece sorgunun \u015fart\u0131na g\u00f6re sonu\u00e7 tablolar\u0131 d\u00f6nd\u00fcrmekten ibaret bir teknoloji de\u011fildir.Kay\u0131t ekleyebilir, g\u00fcncelleyebilir ve silebiliriz.Ve bu yapt\u0131\u011f\u0131m\u0131z i\u015flemler tabikide veritaban\u0131na yans\u0131yacakt\u0131r.
\n\u00d6ncelikle Update<\/span><\/strong> i\u015fleminin LINQ ile nas\u0131l yap\u0131ld\u0131\u011f\u0131n\u0131 inceleyelim.
\nKategorigisi Beverages olan \u00fcr\u00fcnleri \u00e7ekelim.Ve bu \u00fcr\u00fcnlerin birim fiyat\u0131n\u0131 %10 artt\u0131ral\u0131m.Yani \u00fcr\u00fcnlerimize %10 oran\u0131nda zam yapal\u0131m.<\/p>\n

\r\nNorthwindDataContext NW = new NorthwindDataContext();\r\nvar Sonuc = from urun in NW.Urunlers\r\nwhere urun.Kategoriler.KategoriAdi == "Beverages"\r\nselect urun;\r\n\/\/Kategorisi Beverages olan \u00fcr\u00fcnlerimizi \u00e7ektik.\r\nforeach (var item in Sonuc)\r\n{\r\nitem.BirimFiyati += item.BirimFiyati * 0.1m;\r\n}\r\n\/\/Koleksiyon i\u00e7indeki elemanlar\u0131n BirimFiyati \u00f6zellik de\u011ferine %10 zam yapt\u0131k.\r\n\/\/Ancak bu de\u011fi\u015fikli\u011fi yapmam\u0131z, Database e yans\u0131maz.Bunu database e yans\u0131tmal\u0131y\u0131z.\r\nNW.SubmitChanges();\r\n\/\/SubmitChanges() metodu ile koleksiyon i\u00e7inde yap\u0131lan de\u011fi\u015fiklikler database e yans\u0131t\u0131rl\u0131r.\r\n<\/pre>\n\u015eimdide Insert<\/strong><\/span> i\u015flemine de\u011finelim.
\nM\u00fc\u015fteriler tablosuna bir kay\u0131t ekleyelim.<\/p>\n
\r\n            NorthwindDataContext NW = new NorthwindDataContext();\r\n            Musteriler musteri = new Musteriler\r\n            {\r\n                MusteriAdi = "Gen\u00e7ay",\r\n                MusteriID = "2160",\r\n                Adres = "Ankara",\r\n                Bolge = "Alt\u0131nda\u011f",\r\n                Faks = "123",\r\n                MusteriUnvani = "Yaz\u0131l\u0131m Uzman\u0131",\r\n                PostaKodu = "12333",\r\n                Sehir = "Ankara",\r\n                SirketAdi = "Gen\u00e7Ay",\r\n                Telefon = "123123",\r\n                Ulke = "T\u00fcrkiye"\r\n            };\r\n            \/\/\u00d6ncelikle m\u00fc\u015fterimizi olu\u015fturuyoruz.\r\n            \/\/\u015eimdi bu m\u00fc\u015fteriyi m\u00fc\u015fteri koleksiyonuna ekleyelim.\r\n            NW.Musterilers.InsertOnSubmit(musteri);\r\n            \/\/M\u00fc\u015fterimiz m\u00fc\u015fteriler koleksiyonuna eklendi.\r\n            NW.SubmitChanges();\r\n            \/\/De\u011fi\u015fiklikleri database e yans\u0131tt\u0131k.\r\n<\/pre>\nSon olarak Delete<\/span><\/strong> i\u015flemini g\u00f6relim.<\/p>\n
\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 NorthwindDataContext NW = new NorthwindDataContext();\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Musteriler musteri = NW.Musterilers.Single(Mus => Mus.MusteriID == "2160");\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \/\/ID si 2160 olan m\u00fc\u015fterimizi elde ettik.\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 NW.Musterilers.DeleteOnSubmit(musteri);\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \/\/M\u00fc\u015fteriler koleksiyonundan mu m\u00fc\u015fteriyi sildik.\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 NW.SubmitChanges();\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \/\/Son olarak b\u00fct\u00fcn de\u011fi\u015fiklikleri veritaban\u0131na yans\u0131tt\u0131k.\r\n<\/pre>\nG\u00f6rd\u00fc\u011f\u00fcn\u00fcz gibi Linq To Sql’de veritaban\u0131 i\u015flemleri \u00e7ok basit ve kullan\u0131\u015fl\u0131d\u0131r.Faydalanman\u0131z dile\u011fiyle.
\nSonraki yaz\u0131lar\u0131mda g\u00f6r\u00fc\u015fmek \u00fczere..
\n\u0130yi \u00e7al\u0131\u015fmalar \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"
Linq To Sql, sadece sorgunun \u015fart\u0131na g\u00f6re sonu\u00e7 tablolar\u0131 d\u00f6nd\u00fcrmekten ibaret bir teknoloji de\u011fildir.Kay\u0131t ekleyebilir, g\u00fcncelleyebilir ve silebiliriz.Ve bu yapt\u0131\u011f\u0131m\u0131z i\u015flemler tabikide veritaban\u0131na yans\u0131yacakt\u0131r.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,12,226],"tags":[87,79,751,229,86],"class_list":["post-666","post","type-post","status-publish","format-standard","hentry","category-asp-net","category-c-sharp-c","category-linq","tag-delete","tag-insert","tag-linq","tag-linq-to-sql","tag-update"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/666","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/comments?post=666"}],"version-history":[{"count":0,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/666\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/media?parent=666"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/categories?post=666"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/tags?post=666"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}