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

visual-studio sqlite projects-and-solutions visual-studio-2017
ProfK picture ProfK · Mar 15, 2017 · Viewed 9.3k times · Source

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.

Answer

Quintus Marais picture Quintus Marais · Jun 19, 2017

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.

Related questions

missing SQLite data provider in VS 2013

I'm using VS 2013 to develop Win 8.1 app. I chose to deal with SQLite but I coudn't find the data provider when I was trying to add a new connection to manage my database. Any help is appreciated

Read More
How do I include libraries to a project in Visual Studio?

I am a beginner on C++ and trying to learn about including libraries, and I haven't found documentation about it. What are the ways of including libraries to a C++ project (Visual Studio). How do I implement them and which …

Read More
System.Data.SQLite from NuGet, interop dll not copied to output directory

I installed System.Data.SQLite Core (x86/x64) from NuGet. It built without warnings but threw System.DllNotFoundException regarding SQLite.Interop.dll. I rigged my projects to copy the SQLite.Interop.dll from under the NuGet package's directory to the …

Read More