I am a great fan of SQLite because it is such a light weight and easy to develop against SQL database. Because of it minimalistic nature you don’t get by default a lot of management tools. However when it is integrated into Visual Studio it is easy to use.
Now that I have started using Ruby In Steel it is great to have SQLite database viewing and editing integrated into Visual Studio.
It is many thanks to the ADO.NET 2.0 Provider for SQLite that is available from System.Data.SQLite that this is possible. After downloading SQLite-1.0.54.0-setup.exe and running the installer it elegantly let you select which versions of Visual Studio to integrate it into :-
Designer Installation
So now when you go into Visual Studio and add a new Data Connection to Server Explorer you can choose SQLite as below :-
Add Data Source
So finally you get to view and manage your SQLite database from within Visual Studio :-
Database Viewing
