Search code examples
c#entity-frameworksql-server-ce-4

Is it possible to disable auto shrink in SQL Server CE using Entity Framework

Is it possible to adjust SQL Server connection parameters using Entity Framework in order to completely disable auto-shrink behaviour with parameter "autoshrink threshold = 100"?

  • SQL Server CE version: 4.0
  • EntityFramework: 6.1.3
  • EntityFramework.SQLServerCompact: 6.1.3
Solution

  • Yes of course, just add the setting to the connection string