ADO.Net Entity framework, Fatal error encountered during data read

Question

I am getting the following error while using MySql with Entity framework. I have set the default connection timeout to 300000 on the connection string of EntityConnectionStringBuilder. How to resolve this in Entity framework?

    Unhandled Exception: System.Data.EntityCommandExecutionException: An    
    error occurred while reading from the store provider's data reader. See the  
    inner exception for details. ---> MySql.Data.MySqlClient.MySqlException: Fatal 
    error encountered during data read. ---> MySql.Data.MySqlClient.MySqlException: 
    Reading from the stream has failed. ---> System.IO.EndOfStreamException: Attempted 
    to read past the end of the stream.

Update: How can we set net_read_timeout for ado.net entity framework?

Chazt3n · Accepted Answer · 2012-10-17 19:26:14Z

3

Like this

data.Database.ExecuteSqlCommand("set net_write_timeout=99999; set net_read_timeout=99999");

answered Oct 17, 2012 at 19:26

Chazt3n

1,6613 gold badges17 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Chazt3n Over a year ago

I'm happy this was helpful to you.

YoryeNathan Over a year ago

+1 This is magic. It feels like a super hackish magic, but it seems like the only solution for now. (In my case, it was throwing that error on a simple select query of an empty table, so yeah...)

BLoB · Accepted Answer · 2012-08-22 14:43:08Z

0

what does the inner exception say?

Unhandled Exception: System.Data.EntityCommandExecutionException does not point to a timeout error, it could be something as simple as an int that needs to be nullable that is used in your EF query.

Could you give the query to?

Cheers

answered Aug 22, 2012 at 14:43

BLoB

9,7879 gold badges58 silver badges77 bronze badges

2 Comments

remo Over a year ago

That's a bug in mysql from what i looked up bugs.mysql.com/bug.php?id=57365 , its due to a timeout

BLoB Over a year ago

Seems that this is a bug in the mysql connector to do with write timeouts... see stackoverflow.com/questions/6281304/…

Collectives™ on Stack Overflow

ADO.Net Entity framework, Fatal error encountered during data read

2 Answers 2

2 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related