Parameter ignored in EF 5.0 Connection Timeout

Asked

Viewed 102 times

0

My application is showing an error of TimeOut when I perform operations that require more processing time.

I’m using the EntityFramework 5.0 and set up the Connection Timeout=480 to do tests, but it seems to me that he is ignoring the parameter that sets the connection timeout.

Below is my connection string:

<connectionStrings>
    <add name="TesteContext" 
         connectionString="metadata=res://*/Models.TesteModel.csdl|res://*/Models.TesteModel.ssdl|res://*/Models.TesteModel.msl;
         provider=System.Data.SqlClient;
         provider connection string=&quot;
         data source=192.0.15.1;
         initial catalog=DBTeste_PRD;
         persist security info=True;
         user id=xyz;
         password=XXXXXX;
         Connection Timeout=480;
         MultipleActiveResultSets=True;
         App=EntityFramework&quot;" 
         providerName="System.Data.EntityClient" />
  </connectionStrings>

inserir a descrição da imagem aqui

  • If you could put the error image in your question?

  • Sorry I forgot what is the amount of change and put the code too, bad I forgot to report these points!

  • @Virgilionovic has over 100 operations within the method. It is within a "For" structure. It performs a series of records and gives the timeout. I didn’t understand what the need to post the code here, and it is not showing error in the operations, but in the execution time limit.

  • the code is of paramount importance, because it’s why the Timeout is taking place that you asked, how can I imagine what the code is doing if I don’t know how it was written, and if there is a better way to write better? What if there’s something going unnoticed? Is it all about a code that is not bringing the expected result and troubling an ORM transaction? , if you can post, you may have a solution or a new path. If you have 100 operations in one method, it is already reason to turn on the alert blink of any code ...

  • cont ... for example has an extension for Entity Framework for batch recording: Bulkinsert That might solve that part for you who knows! But, it gets hard without seeing the code. You have even an answer about this here https://answall.com/questions/92884/erro-ao-insertir-dados-no-banco-ef-6/148374#148374 or this https://answall.com/questions/131541/imports%C3%A7%C3%A3o-e-reading-file/131565#131565

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.