Click here to Skip to main content
15,390,185 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
How do I add SQLite to the list of data sources in Visual Studio 2022? I have found solutions for many years ago but nothing recent. Can someone help me?

Thanks in advance!

What I have tried:

Days searching the internet. Is it so obvious that there aren't any articles or questions about it?
Posted
Updated 30-May-22 4:52am
Comments
Dave Kreskowiak 23-Mar-22 18:46pm
   
Better question. Why do you want to use the Data designers in Visual Studio? They're the training wheels for database code which you could write yourself without the designers hiding everything from you.
Blue Ocean 23-Mar-22 19:48pm
   
Because it seems to make working with the reporting side of things a little less difficult, but seeing as there doesn't seem to be a solution, I will likely work through the coding.

   
Comments
Blue Ocean 22-Mar-22 16:00pm
   
Maciej this article doesn't give any instructions on sqlite, what am I missing?
Maciej Los 22-Mar-22 17:13pm
   
Well... you need to install SQLite NuGet package to be able to connect to SQLite database. See: Overview - Microsoft.Data.Sqlite | Microsoft Docs[^]
Blue Ocean 23-Mar-22 10:21am
   
Maciej, I think I am asking this question wrong. I understand how to use SQLite in my C# project code (connection strings, commands, data adapters, data readers, command builder, etc) What I am trying to do is figure out how to include the SQLite in the list that is in the Visual Studio 2022 Data Source Configuration Wizard. In Visual Studio\Add New Data Source...\ the Data Source Configuration Wizard opens and asks for
SOURCE TYPE: Database
...then it asks for
SOURCE MODEL: Dataset
...then it asks for
DATA CONNECTION: I select NEW CONNECTION and the CHOOSE DATA SOURCE form opens with a list of sources:
Microsoft Access Database File
Microsoft ODBC Data Source
Microsoft SQL Server
Microsoft SQL Server Database File
<other>

Here is where I need to have SQLite to select from. How do I add SQLite in this list?
RedDk 30-May-22 19:26pm
   
Short answer, and what I see as the end of the discussion ... SQLite is not a Microsoft product.
Check out this article, looks like what you're looking for. Using SQLite in a C# Application | CodeGuru[^]
   
Comments
Blue Ocean 23-Mar-22 13:43pm
   
Mike see my note below to Maciej.
   
Comments
Blue Ocean 23-Mar-22 15:12pm
   
Mike thanks for the link, but I am looking specifically for how to add SQLite to the data source list in Visual Studio 2022, Data Source Configuration Wizard.
Mike Hankey 23-Mar-22 15:29pm
   
Let me give you a little piece of advice...if you down vote everyone that attempts to help you you will get no help. I took 20min. out of my busy day to try to help. Just a heads up!
Blue Ocean 23-Mar-22 15:38pm
   
I didn't realize that was a negative thing, my apologies.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900