{"id":13725,"date":"2020-02-26T23:12:58","date_gmt":"2020-02-26T23:12:58","guid":{"rendered":"https:\/\/www.gencayyildiz.com\/blog\/?p=13725"},"modified":"2020-02-26T23:12:58","modified_gmt":"2020-02-26T23:12:58","slug":"entity-framework-core-execution-timeout-expired-the-timeout-period-elapsed-prior-to-completion-of-the-operation-or-the-server-is-not-responding-hatasi-ve-cozumu","status":"publish","type":"post","link":"https:\/\/www.gencayyildiz.com\/blog\/entity-framework-core-execution-timeout-expired-the-timeout-period-elapsed-prior-to-completion-of-the-operation-or-the-server-is-not-responding-hatasi-ve-cozumu\/","title":{"rendered":"Entity Framework Core &#8211; &#8216;Execution Timeout Expired.  The Timeout Period Elapsed Prior To Completion Of The Operation Or The Server Is Not Responding&#8217; Hatas\u0131 ve \u00c7\u00f6z\u00fcm\u00fc"},"content":{"rendered":"<div id=\"fb-root\"><\/div>\n<p>Merhaba,<\/p>\n<p>Entity Framework Core ORM arac\u0131 ile g\u00f6nderilen a\u011f\u0131r sorgularda i\u015flem s\u00fcresinin uzun olmas\u0131 olas\u0131 olaca\u011f\u0131ndan dolay\u0131 iste\u011fin zaman a\u015f\u0131m\u0131na u\u011frad\u0131\u011f\u0131na ve sunucunun yan\u0131t vermedi\u011fine dair a\u015fa\u011f\u0131daki hatayla kar\u015f\u0131la\u015fabilirsiniz;<\/p>\n<blockquote><p>\n<strong style=\"color:red;\">SqlException: Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.<\/strong>\n<\/p><\/blockquote>\n<blockquote><p>\n<strong style=\"color:red;\">The wait operation timed out.<\/strong>\n<\/p><\/blockquote>\n<p>Hatan\u0131n g\u00f6rsel halinide ele al\u0131rsak e\u011fer;<br \/>\n<a href=\"https:\/\/www.gencayyildiz.com\/blog\/wp-content\/uploads\/2020\/02\/Entity-Framework-Core-Execution-Timeout-Expired.-The-Timeout-Period-Elapsed-Prior-To-Completion-Of-The-Operation-Or-The-Server-Is-Not-Responding-Hatas\u0131-ve-\u00c7\u00f6z\u00fcm\u00fc.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.gencayyildiz.com\/blog\/wp-content\/uploads\/2020\/02\/Entity-Framework-Core-Execution-Timeout-Expired.-The-Timeout-Period-Elapsed-Prior-To-Completion-Of-The-Operation-Or-The-Server-Is-Not-Responding-Hatas\u0131-ve-\u00c7\u00f6z\u00fcm\u00fc.png\" alt=\"Entity Framework Core - &#039;Execution Timeout Expired. The Timeout Period Elapsed Prior To Completion Of The Operation Or The Server Is Not Responding&#039; Hatas\u0131 ve \u00c7\u00f6z\u00fcm\u00fc\" width=\"413\" height=\"157\" class=\"aligncenter size-full wp-image-13728\" srcset=\"https:\/\/www.gencayyildiz.com\/blog\/wp-content\/uploads\/2020\/02\/Entity-Framework-Core-Execution-Timeout-Expired.-The-Timeout-Period-Elapsed-Prior-To-Completion-Of-The-Operation-Or-The-Server-Is-Not-Responding-Hatas\u0131-ve-\u00c7\u00f6z\u00fcm\u00fc.png 413w, https:\/\/www.gencayyildiz.com\/blog\/wp-content\/uploads\/2020\/02\/Entity-Framework-Core-Execution-Timeout-Expired.-The-Timeout-Period-Elapsed-Prior-To-Completion-Of-The-Operation-Or-The-Server-Is-Not-Responding-Hatas\u0131-ve-\u00c7\u00f6z\u00fcm\u00fc-300x114.png 300w\" sizes=\"auto, (max-width: 413px) 100vw, 413px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.gencayyildiz.com\/blog\/wp-content\/uploads\/2020\/02\/Entity-Framework-Core-Execution-Timeout-Expired.-The-Timeout-Period-Elapsed-Prior-To-Completion-Of-The-Operation-Or-The-Server-Is-Not-Responding-Hatas\u0131-ve-\u00c7\u00f6z\u00fcm\u00fc-1.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.gencayyildiz.com\/blog\/wp-content\/uploads\/2020\/02\/Entity-Framework-Core-Execution-Timeout-Expired.-The-Timeout-Period-Elapsed-Prior-To-Completion-Of-The-Operation-Or-The-Server-Is-Not-Responding-Hatas\u0131-ve-\u00c7\u00f6z\u00fcm\u00fc-1.png\" alt=\"Entity Framework Core - &#039;Execution Timeout Expired. The Timeout Period Elapsed Prior To Completion Of The Operation Or The Server Is Not Responding&#039; Hatas\u0131 ve \u00c7\u00f6z\u00fcm\u00fc\" width=\"414\" height=\"144\" class=\"aligncenter size-full wp-image-13729\" srcset=\"https:\/\/www.gencayyildiz.com\/blog\/wp-content\/uploads\/2020\/02\/Entity-Framework-Core-Execution-Timeout-Expired.-The-Timeout-Period-Elapsed-Prior-To-Completion-Of-The-Operation-Or-The-Server-Is-Not-Responding-Hatas\u0131-ve-\u00c7\u00f6z\u00fcm\u00fc-1.png 414w, https:\/\/www.gencayyildiz.com\/blog\/wp-content\/uploads\/2020\/02\/Entity-Framework-Core-Execution-Timeout-Expired.-The-Timeout-Period-Elapsed-Prior-To-Completion-Of-The-Operation-Or-The-Server-Is-Not-Responding-Hatas\u0131-ve-\u00c7\u00f6z\u00fcm\u00fc-1-300x104.png 300w\" sizes=\"auto, (max-width: 414px) 100vw, 414px\" \/><\/a><\/p>\n<h3>Hatan\u0131n Nedeni Nedir?<\/h3>\n<p>Hatan\u0131n nedeni verdi\u011fi mesajda a\u015fikar oldu\u011fu gibi a\u011f\u0131r ve maliyetli sorgunun s\u00fcreci zaman a\u015f\u0131m\u0131na u\u011fratmas\u0131ndan kaynaklanmaktad\u0131r.<\/p>\n<h3>Hatan\u0131n \u00c7\u00f6z\u00fcm\u00fc<\/h3>\n<p>Bu hatay\u0131 \u00e7\u00f6zebilmek i\u00e7in yapman\u0131z gereken zaman a\u015f\u0131m\u0131 s\u00fcrecini artt\u0131rmakt\u0131r. Bunun i\u00e7in a\u015fa\u011f\u0131daki gibi context s\u0131n\u0131f\u0131ndan veritaban\u0131 nesnesine eri\u015ferek <em>SetCommandTimeout<\/em> metodu arac\u0131l\u0131\u011f\u0131yla Time Out s\u00fcresi ilgili sorguya e\u015flik edebilecek bir makul de\u011ferde uzat\u0131labilir.<\/p>\n<pre class=\"brush: jscript; title: ; notranslate\" title=\"\">\r\n    public class ArticleContext : DbContext\r\n    {\r\n        public ArticleContext(DbContextOptions options) : base(options)\r\n        {\r\n            this.Database.SetCommandTimeout(999999);\r\n        }\r\n\r\n        public DbSet&lt;Article&gt; Articles { get; set; }\r\n        public DbSet&lt;Image&gt; Images { get; set; }\r\n        public DbSet&lt;HTMLTag&gt; HtmlTags { get; set; }\r\n    }\r\n<\/pre>\n<p>Benzer mant\u0131kla ayn\u0131 i\u015flemi, context nesnesini uygulamaya &#8220;AddDbContext&#8221; metodu ile dahil ederken a\u015fa\u011f\u0131daki gibide &#8220;CommandTimeout&#8221; metodu \u00fczerinden de ger\u00e7ekle\u015ftirebilirsiniz;<\/p>\n<pre class=\"brush: jscript; title: ; notranslate\" title=\"\">\r\napp.AddDbContext&lt;ArticleContext&gt;(option =&gt;\r\n option.UseSqlServer(&quot;Server=.;Database=ArticleDB;Trusted_Connection=True;&quot;,\r\n o =&gt; o.CommandTimeout(9999999)));\r\n<\/pre>\n<p>\u0130lgilenenlerin faydalanmas\u0131 dile\u011fiyle&#8230;<br \/>\nSonraki yaz\u0131lar\u0131mda g\u00f6r\u00fc\u015fmek \u00fczere&#8230;<br \/>\n\u0130yi \u00e7al\u0131\u015fmalar&#8230;<\/p>\n<!-- AddThis Advanced Settings generic via filter on the_content --><!-- AddThis Share Buttons generic via filter on the_content -->","protected":false},"excerpt":{"rendered":"<p>Merhaba, Entity Framework Core ORM arac\u0131 ile g\u00f6nderilen a\u011f\u0131r sorgularda i\u015flem s\u00fcresinin uzun olmas\u0131 olas\u0131 olaca\u011f\u0131ndan dolay\u0131 iste\u011fin zaman a\u015f\u0131m\u0131na u\u011frad\u0131\u011f\u0131na ve sunucunun yan\u0131t vermedi\u011fine dair a\u015fa\u011f\u0131daki hatayla kar\u015f\u0131la\u015fabilirsiniz; SqlException: Execution Timeout Expired. The&#46;&#46;&#46;<!-- AddThis Advanced Settings generic via filter on get_the_excerpt --><!-- AddThis Share Buttons generic via filter on get_the_excerpt --><\/p>\n","protected":false},"author":1,"featured_media":3014,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[258],"tags":[2850,3219,3220,260,1083,3218],"class_list":["post-13725","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-hata-cozumleri","tag-entity-framework-core","tag-entity-framework-core-hatasi","tag-entity-framework-hatasi","tag-hata","tag-hata-ve-cozumu","tag-setcommandtimeout"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/13725","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=13725"}],"version-history":[{"count":15,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/13725\/revisions"}],"predecessor-version":[{"id":13742,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/13725\/revisions\/13742"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/media\/3014"}],"wp:attachment":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/media?parent=13725"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/categories?post=13725"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/tags?post=13725"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}