VisualStudio.Data.Sqlite

A Data Designer Extensibility (DDEX) provider for Microsoft.Data.Sqlite.

The latest preview release is available on the Visual Studio Marketplace.

CI builds are available on the Open VSIX Gallery. Install this extension to get automatic updates.

What it's for

This extension enables other Visual Studio extensions (like the EF Core Power Tools) that use the DDEX APIs to do things like the following.

• Create connection strings
• Create design-time connections
• Read database schemas

It also enables connecting to SQLite databases in Server Explorer to see their schema and data. This read-only view can be useful when debugging your app.

What it's not for

There are plenty of great tools out there to help you design SQLite databases and queries. This is not one of them. The following features are specifically outside the scope of this project.

• Creating databases
• Modifying databases (both schemas and data)
• Designing databases
• Designing queries
  • Reviewing query plans
• Comparing schemas
• Importing and exporting data
• Migrating databases
• Generating code

If you're looking for a great tool that does all of that inside Visual Studio, I recommend the SQLite Toolbox.

Screenshots