What is a Sqlite database doing in my project's .vs folder?

Question

I have now noticed this in VS 2017 in a Core console app, and a standard .NET Framework MVC app. It is named <solution-name>.sqlite, and has the following tables:

FileScannerCache
FileSystemData
FileSystemEntity
FileSystemReference
ProviderEntity
Setting
SymbolDefinition

It seems to contain MSBuild related data, but when I query some tables, like

select * from FileScannerCache

I get the error System.FormatException: String was not recognised as a valid DateTime. I'm using the Sqlite/SQL Server Compact Toolbox to examine and query this db.

I can't find any such file - it's probably from a plugin you installed. — H H, Mar 15 '17 at 12:05
Feel free to post an issue for the SQLite Toolbox issue here: https://github.com/ErikEJ/SqlCeToolbox/issues/new - wonder if this is related: https://github.com/ErikEJ/SqlCeToolbox/issues/70 — ErikEJ, Mar 16 '17 at 05:48
@HenkHolterman, in fac, I have just installed the Sqlite/CE Toolbox. — ProfK, Mar 16 '17 at 14:56

score 20 · Answer 1 · answered Jun 19 '17 at 13:34

This file seems to be related to the "Lightweight Solution Load" (LSL) functionality in VS2017. If you disable LSL in your solution, delete the file from the directory and open your solution you will see that it is not recreated. However, enable LSL for the solution again and open your solution, you will see the file created again. I presume it is being used as a form of cacheing information to enable the LSL functionality.

As an aside, all info in the .vs folder is supposed to be safe to exclude from source control.

score 7 · Answer 2 · answered May 20 '18 at 18:07

If you ended up here because you are getting

 Git failed with a fatal error.
 error: open(".vs/Onion/v15/Server/sqlite3/db.lock"): Permission denied
 fatal: Unable to process path .vs/Onion/v15/Server/sqlite3/db.lock

Then Team Explorer > Settings > Repository Settings > Add /.gitignore. It should now have .vs

# Visual Studio 2015 cache/options directory
.vs/

Fixes issue.

What is a Sqlite database doing in my project's .vs folder?

2 Answers2