I spend a fair amount of time searching the net for this. All because i couldn’t notice the Native Error: 25101 in the exception.
SQL Server Compact has exceeded the buffer size. The default size can be increased on initialization by modifying the ssce: max buffer size property.
max buffer size
The largest amount of memory, in kilobytes, that SQL Server Mobile can use before it starts flushing changes to disk. If not specified, the default value is 640.
You can try increasing your buffer size.
“Persist Security Info = False; Data Source = ‘SalesData.sdf’;” +
“Password = ‘
‘; File Mode = ‘shared read’; ” +
“Max Database Size = 256; Max Buffer Size = 1024″;