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="
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""
providerName="System.Data.EntityClient" />
</connectionStrings>
If you could put the error image in your question?
– novic
Sorry I forgot what is the amount of change and put the code too, bad I forgot to report these points!
– novic
@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.
– Gleison França
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 ...
– novic
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
– novic