I got a question from a customer about the AutoClose property being true on their CMS database that is created whenever they create a new EPiServer project in Visual Studio. A quick Google search reveals why they brought the topic up:
So why would EPiServer default to setting this property to true? The answer: LocalDB.
EPiServer does not actually set AutoClose to true. It is just how a new database is created in LocalDB. That is what seems to work best for a new, local web project in general, not just EPiServer projects.
You should definitely turn AutoClose off as soon as:
- You decide to move your database off of SQL Express/LocalDB
- Multiple people have to use your database (more details here)