How to show SQLite in VisualStudio 2022 data connection wizard

Question

I'm deploying a small program using SQLite database in VisualStudio 2022. I am able to insert, update and delete records using a SQLite connection but when i try to use the wizard for create a dataset the SQLite provider is not present in the list of providers. I have to use the wizard for Datarepeaters and Reports. Any suggestion Is highly appreciated.

Answer 1

Hello @LIVIO CHIABOTTO ,

Welcome to Microsoft Q&A forum.

Looks like the setup packages, which contain the Design-Time Components for Visual Studio are no longer officially supported. Installing SQLite Data Provider and directly using it in VS 2022 may be not possible.

You may try to install and use some extensions, for example SQLite and SQL Server Compact Toolbox.

Best Regards,

Tianyu

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.