<\/div>\n

Merhaba,<\/p>\n

Projelerimizde kulland\u0131\u011f\u0131m\u0131z ve bizlere Entity Data Modeller \u00fczerinde h\u0131zl\u0131 bir \u015fekilde sorgulama imkan\u0131 sa\u011flayan LINQ sorgular\u0131 \u00fczerinde ba\u015fl\u0131kta da g\u00f6rd\u00fc\u011f\u00fcn\u00fcz gibi a\u015fa\u011f\u0131daki olas\u0131 hatay\u0131 alabilirsiniz.<\/p>\n

System.NotSupportedException: ‘LINQ to Entities does not recognize the method ‘Int32 ToInt32(System.Object)’ method, and this method cannot be translated into a store expression.’<\/strong><\/em><\/span><\/p>\n<\/blockquote>\n

Hatam\u0131z\u0131n g\u00f6rsel hali ise a\u015fa\u011f\u0131daki gibidir;
\n $\"'LINQ$ <\/a>
\nEvet… Kar\u015f\u0131la\u015f\u0131lmas\u0131 muhtemel hatam\u0131z budur. Peki bu hatay\u0131 neden almaktay\u0131z?<\/em><\/strong>
\n\u00d6ncelikle \u015funu belirtmeliyim ki, LINQ teknolojisini kullan\u0131rken sorgu mant\u0131\u011f\u0131n\u0131 g\u00f6z \u00f6n\u00fcne almazsak bu hatayla kar\u015f\u0131la\u015fmam\u0131z olduk\u00e7a y\u00fcksek ihtimaldir. Nihayetinde ben bir \u00e7al\u0131\u015fma esnas\u0131nda bu mant\u0131\u011f\u0131 g\u00f6z ard\u0131 etti\u011fim i\u00e7in bu hataya haddinden fazla ma\u011fruz kal\u0131p uygulama tasar\u0131m\u0131n\u0131 farkl\u0131 bir \u015fekilde in\u015fa etmek durumunda kalm\u0131\u015f bulunmaktay\u0131m.<\/p>\n

“Peki ne hoca bu mant\u0131k?<\/em>” diye sab\u0131rs\u0131zca sordu\u011funuzu duyar gibiyim. Hadi gelin a\u00e7\u0131klayal\u0131m.<\/p>\n

LINQ sorgular\u0131nda yazm\u0131\u015f oldu\u011fumuz kal\u0131p veritaban\u0131nda \u00e7al\u0131\u015ft\u0131r\u0131lacak sorguyu haz\u0131rlamaktad\u0131rlar. Eee haliyle ilgili kal\u0131b\u0131 yazmak demek; sorguyu olu\u015fturup, veritaban\u0131nda \u00e7al\u0131\u015ft\u0131r\u0131p ard\u0131ndan sonucu getirir manas\u0131na gelmemektedir.<\/p>\n

\u015eimdi a\u015fa\u011f\u0131daki kod blo\u011funu ele alal\u0131m.<\/p>\n

\r\n            Northwind2Entities db = new Northwind2Entities();\r\n\r\n            var Personeller = from Personel in db.Personeller\r\n                              select Personel;\r\n<\/pre>\nBu kod blo\u011fundaki kal\u0131p, ilgili sorguyu veritaban\u0131na g\u00f6nderip gelen veri k\u00fcmesini var tipinden Personeller referans\u0131na atamamaktad\u0131r<\/del> ! ! ! \u00c7\u00fcnk\u00fc bu kal\u0131p sadece sorguyu haz\u0131rlamaktad\u0131r. Yap\u0131lan LINQ sorgusunun veritaban\u0131nda execute edilmesi i\u00e7in herhangi bir yap\u0131 taraf\u0131ndan \u00e7a\u011f\u0131r\u0131lmas\u0131 gerekmektedir. \u00d6rne\u011fin bu yap\u0131 foreach d\u00f6ng\u00fcs\u00fc olabilir;<\/p>\n\n\n\n\n\u00c7a\u011fr\u0131lmadan \u00d6nce\n<\/td>\n \n\u00c7a\u011fr\u0131ld\u0131ktan Sonra\n<\/td>\n<\/tr>\n
\n<\/a>\n<\/td>\n \n<\/a>\n<\/td>\n<\/tr>\n<\/table>\nDikkat ederseniz LINQ sorgumuz foreach taraf\u0131ndan \u00e7a\u011fr\u0131ld\u0131\u011f\u0131 zaman sorgu haline getirilip veritaban\u0131nda execute edilmi\u015ftir. <\/p>\n
foreach d\u00f6ng\u00fcs\u00fcnden ziyade LINQ sorgusu neticesinde .ToList() metodu \u00e7a\u011fr\u0131l\u0131rsa e\u011fer tekrardan ilgili ifade veritaban\u0131nda execute edilecektir.<\/p>\n
Bizler LINQ sorgular\u0131n\u0131n iterasyonel ya da fonksiyonel \u00e7a\u011fr\u0131m sonucu \u00e7al\u0131\u015ft\u0131r\u0131lmalar\u0131na Ertelenmi\u015f \u00c7al\u0131\u015fma(Deferred Execution)<\/em> demekteyiz.<\/p>\n
\u0130\u015fte… LINQ sorgular\u0131n\u0131 olu\u015ftururken g\u00f6z \u00f6n\u00fcne almam\u0131z gereken yap\u0131sal mant\u0131k bu Deferred Execution olay\u0131d\u0131r.<\/p>\nKonumuz olan “LINQ to Entities does not recognize the method ‘Int32 ToInt32(System.Object)’ method, and this method cannot be translated into a store expression.<\/em>” hatas\u0131 ise bu bahsetti\u011fim LINQ sorgu mekanizmas\u0131na ra\u011fmen a\u015fa\u011f\u0131daki gibi bir kullan\u0131m sergilemekten kaynaklanmaktad\u0131r.<\/a><\/p>\n
G\u00f6r\u00fcld\u00fc\u011f\u00fc \u00fczere .ToList() metodu \u00e7a\u011fr\u0131lana kadar ilgili LINQ sorgusu b\u00fcnyesinde bir Convert i\u015flemi yap\u0131lmaya \u00e7al\u0131\u015f\u0131lm\u0131\u015ft\u0131r. Eee haliyle compiler elde bir sorgu olmad\u0131\u011f\u0131 i\u00e7in Convert.ToInt32 metodunun T-SQL kar\u015f\u0131l\u0131\u011f\u0131n\u0131 bulamayaca\u011f\u0131ndan dolay\u0131 bu hatay\u0131 vermektedir. Bu hata a\u015fa\u011f\u0131daki gibi bir manevrayla rahatl\u0131kla a\u015f\u0131labilmektedir.<\/p>\n
\r\n        public ActionResult Index(int? id)\r\n        {\r\n            Northwind2Entities db = new Northwind2Entities();\r\n\r\n            if (id != null)\r\n            {\r\n                int ID = Convert.ToInt32(id);\r\n                var GelenPersonel = (from Personel in db.Personeller\r\n                                    where Personel.PersonelID == ID\r\n                                     select Personel).ToList();\r\n            }\r\n            return View();\r\n        }\r\n<\/pre>\nYani LINQ sorgusunun i\u00e7erisinde bir Convert i\u015flemi yapmaktansa bu i\u015flemi sorgu d\u0131\u015f\u0131nda ger\u00e7ekle\u015ftirip, ard\u0131ndan elde edilen de\u011feri direkt olarak sorguya eklememiz bu hatadan kurtulman\u0131z\u0131 sa\u011flayacakt\u0131r.<\/p>\nBenzer \u015fekilde a\u015fa\u011f\u0131daki Extension metot yap\u0131lar\u0131 ile sorgulama i\u00e7inde ge\u00e7erli olacakt\u0131r.
\n<\/a>
\nYapmam\u0131z gereken bir \u00f6nceki \u00f6rnekte verilen \u00e7\u00f6z\u00fcm\u00fc uygulamak, yani sorgu i\u00e7erisindeki Convert i\u015flemini d\u0131\u015far\u0131da halletmek yeterli olacakt\u0131r.<\/p>\n
\r\n        public ActionResult Index(int? id)\r\n        {\r\n            Northwind2Entities db = new Northwind2Entities();\r\n            int ID = Convert.ToInt32(id);\r\n            if (id != null)\r\n                db.Personeller.FirstOrDefault(y => y.PersonelID == ID);\r\n            return View();\r\n        }\r\n<\/pre>\nSonraki yaz\u0131lar\u0131mda g\u00f6r\u00fc\u015fmek \u00fczere…
\n\u0130yi \u00e7al\u0131\u015fmalar…<\/p>\n","protected":false},"excerpt":{"rendered":"
Merhaba, Projelerimizde kulland\u0131\u011f\u0131m\u0131z ve bizlere Entity Data Modeller \u00fczerinde h\u0131zl\u0131 bir \u015fekilde sorgulama imkan\u0131 sa\u011flayan LINQ sorgular\u0131 \u00fczerinde ba\u015fl\u0131kta da g\u00f6rd\u00fc\u011f\u00fcn\u00fcz gibi a\u015fa\u011f\u0131daki olas\u0131 hatay\u0131 alabilirsiniz. System.NotSupportedException: ‘LINQ to Entities does not recognize the...<\/p>\n","protected":false},"author":1,"featured_media":3223,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12,226],"tags":[1849,1847,1848,260,484,1083],"class_list":["post-6540","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-c-sharp-c","category-linq","tag-deferred-execution","tag-entity-data-model","tag-ertelenmis-calisma","tag-hata","tag-hata-cozumu","tag-hata-ve-cozumu"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/6540","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=6540"}],"version-history":[{"count":0,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/6540\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/media\/3223"}],"wp:attachment":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/media?parent=6540"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/categories?post=6540"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/tags?post=6540"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}