<\/div>\n

Merhaba,<\/p>\n

Uygulamalar\u0131m\u0131zda veritaban\u0131 diyaloglar\u0131n\u0131 h\u0131zl\u0131 bir \u015fekilde ger\u00e7ekle\u015ftirebilmek i\u00e7in kulland\u0131\u011f\u0131m\u0131z ORM yap\u0131lanmalar\u0131 bazen istemsiz durumlarla kar\u015f\u0131la\u015fabilmektedirler. Tabi ki de bir yaz\u0131l\u0131m\u0131n \u00e7al\u0131\u015fma s\u00fcresince istemsiz durumlarla kar\u015f\u0131la\u015fmas\u0131 olduk\u00e7a ola\u011fan bir durumdur lakin burada m\u00fchim olan kulland\u0131\u011f\u0131m\u0131z ORM yap\u0131lanmas\u0131n\u0131n bu durumlarla kar\u015f\u0131la\u015f\u0131ld\u0131\u011f\u0131nda nas\u0131l bir aksiyon ald\u0131\u011f\u0131d\u0131r. Bu i\u00e7eri\u011fimizde, ORM yap\u0131lanmalar\u0131ndan Entity Framework Core taraf\u0131ndan generate edilen veritaban\u0131 komutlar\u0131n\u0131n, beklenmedik hatalar ile kar\u015f\u0131la\u015fmas\u0131 durumunda benimsedi\u011fi yenilik\u00e7i bir yakla\u015f\u0131m olan Connection Resiliency<\/em> stratejisini ele al\u0131yor olaca\u011f\u0131z.<\/p>\n

Connection Resiliency, EF Core taraf\u0131ndan \u00fcretilen veritaban\u0131 komutlar\u0131n\u0131n ba\u015far\u0131s\u0131z olmas\u0131 durumunda tekrar otomatik olarak denenmesini sa\u011flayan bir stratejidir. EF Core, bu olas\u0131 hatalar durumuna kar\u015f\u0131l\u0131k Retry Pattern’i baz almakta ve otomatik olarak hata veren i\u015flemi yeni bir transaction ile tekrar devreye sokmaktad\u0131r. B\u00f6ylece bu \u00f6zellik sayesinde hatalar\u0131 tespit edebilmekte m\u00fcmk\u00fcn olmaktad\u0131r.<\/p>\n

Connection Resiliency’i kullanabilmek i\u00e7in yap\u0131lmas\u0131 gereken sadece EF Core konfig\u00fcrasyonlar\u0131nda retry policy’i aktif etmektir. Bunun i\u00e7in ‘OnConfiguring’ metodu kullan\u0131labilir.<\/p>\n

\r\n        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)\r\n        {\r\n            optionsBuilder.UseSqlServer("Server=.;Database=CompanyDB2;Trusted_Connection=True;",\r\n                options => options.EnableRetryOnFailure());\r\n            base.OnConfiguring(optionsBuilder);\r\n        }\r\n<\/pre>\nYahut Asp.NET Core uygulamalar\u0131nda context’i register etti\u011fimiz ‘Startup.cs’ dosyas\u0131 da tercih edilebilir.<\/p>\n
\r\n        public void ConfigureServices(IServiceCollection services)\r\n        {\r\n            services.AddDbContext<CompanyContext>(x =>\r\n                x.UseSqlServer("Server=.;Database=CompanyDB2;Trusted_Connection=True;",\r\n                options => options.EnableRetryOnFailure()));\r\n        }\r\n<\/pre>\nG\u00f6r\u00fcld\u00fc\u011f\u00fc \u00fczere ‘EnableRetryOnFailure’ fonksiyonu ile ba\u015far\u0131s\u0131zl\u0131k durumunda yeniden deneme etkinle\u015ftirilmektedir. \u0130lgili fonksiyonun overload’lar\u0131na g\u00f6z atarsak e\u011fer;
\n<\/a>yeniden deneme say\u0131s\u0131n\u0131(maxRetryCount), yeniden denemeler aras\u0131ndaki maksimum gecikme s\u00fcresini(maxRetryDelay) ve sadece ge\u00e7ici oldu\u011fu d\u00fc\u015f\u00fcn\u00fclen SQL hata numaralar\u0131n\u0131(errorNumbersToAdd) ayarlayabildi\u011fimizi g\u00f6rmekteyiz.<\/p>\n
\u0130lgilenenlerin faydalanmas\u0131 dile\u011fiyle…
\nSonraki yaz\u0131lar\u0131mda g\u00f6r\u00fc\u015fmek \u00fczere…
\n\u0130yi \u00e7al\u0131\u015fmalar…<\/p>\n","protected":false},"excerpt":{"rendered":"
Merhaba, Uygulamalar\u0131m\u0131zda veritaban\u0131 diyaloglar\u0131n\u0131 h\u0131zl\u0131 bir \u015fekilde ger\u00e7ekle\u015ftirebilmek i\u00e7in kulland\u0131\u011f\u0131m\u0131z ORM yap\u0131lanmalar\u0131 bazen istemsiz durumlarla kar\u015f\u0131la\u015fabilmektedirler. Tabi ki de bir yaz\u0131l\u0131m\u0131n \u00e7al\u0131\u015fma s\u00fcresince istemsiz durumlarla kar\u015f\u0131la\u015fmas\u0131 olduk\u00e7a ola\u011fan bir durumdur lakin burada m\u00fchim olan...<\/p>\n","protected":false},"author":1,"featured_media":11538,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2914],"tags":[4004,2850,4005],"class_list":["post-19898","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-entity-framework-core","tag-connection-resiliency","tag-entity-framework-core","tag-entity-framework-core-connection-resiliency"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/19898","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=19898"}],"version-history":[{"count":15,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/19898\/revisions"}],"predecessor-version":[{"id":19914,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/19898\/revisions\/19914"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/media\/11538"}],"wp:attachment":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/media?parent=19898"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/categories?post=19898"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/tags?post=19898"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}