How do I add sqlite in the visual studio 2022 data source wizard?

Question

0.00/5 (No votes)

See more:

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 22-Mar-22 8:43am

Blue Ocean

Updated 30-May-22 4:52am

Add a Solution

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.

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Maciej Los · Answer 1 · 2022-03-22T09:28:00

Solution 1

Please, read the documentation: Add new connections - Visual Studio (Windows) | Microsoft Docs[^]

Posted 22-Mar-22 9:28am

Maciej Los

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.

Mike Hankey · Answer 2 · 2022-03-22T12:14:00

Solution 2

Check out this article, looks like what you're looking for. Using SQLite in a C# Application | CodeGuru[^]

Posted 22-Mar-22 12:14pm

Mike Hankey

Comments

Blue Ocean 23-Mar-22 13:43pm

Mike see my note below to Maciej.

Mike Hankey · Answer 3 · 2022-03-23T08:50:00

Solution 3

Is this https://support.exagoinc.com/hc/en-us/articles/115005848908-Using-SQLite-Data-Sources[^] what you're looking for?

Posted 23-Mar-22 8:50am

Mike Hankey

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.

sachin4dotnet · Answer 4 · 2022-05-30T04:52:00

Solution 4

Hey there,

You can use SQLite and SQL Server Compact Toolbox - Visual Studio Marketplace[^]

Follow this guide - EF6 workflow with SQLite DDEX provider · ErikEJ/SqlCeToolbox Wiki · GitHub[^]

Posted 30-May-22 4:52am

sachin4dotnet