Writing large BLOBs throws InvalidOperationException

denkhe · Post by **denkhe** » Mon 03 Jan 2011 15:37

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.

denkhe · Post by **denkhe** » Tue 04 Jan 2011 08:01

Update:

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

AndreyR · Post by **AndreyR** » Mon 10 Jan 2011 09:50

Thank you for sharing the solution.