How to show SQLite in VisualStudio 2022 data connection wizard

LIVIO CHIABOTTO 0 Reputation points
2023-12-23T16:09:29.9933333+00:00

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.

Developer technologies | Visual Studio | Other
Developer technologies | Visual Studio | Other

A family of Microsoft suites of integrated development tools for building applications for Windows, the web, mobile devices and many other platforms. Miscellaneous topics that do not fit into specific categories.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tianyu Sun-MSFT 34,836 Reputation points Microsoft External Staff
    2023-12-25T06:43:32.34+00:00

    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.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.