Page 1 of 1

Writing large BLOBs throws InvalidOperationException

Posted: Mon 03 Jan 2011 15:37
by denkhe
I am having trouble writing large blobs to a MySQL-Database using the .net entity-framework.
Blobs 1MB a InvalidOperationException with text "Connection must be opened." occurs.

I am using:

1. Visual Studio 2010
2. .Net 3.5
3. Devart ADO.NET Entity Framework (latest)
4. MySSQl (latest)

Help is appreciated.

Posted: Tue 04 Jan 2011 08:01
by denkhe
Update:

Increasing the value of the MySQL-Parameter max_allow_packet actually did the job.

Posted: Mon 10 Jan 2011 09:50
by AndreyR
Thank you for sharing the solution.