search

ErikEJ / SqlCeToolbox

SQLite & SQL Server Compact Toolbox extension for Visual Studio, SSMS (and stand alone)
Other
847 stars 174 forks source link

Cant add a dataset on VS2022 and Win11 #986

Closed juanmanuelsanche closed 4 months ago

juanmanuelsanche commented 4 months ago

I have tried the steps on the wiki and there is no GAC no matter what I do. Also when I try to add the dataset everything checks out I even get a connection successful Screenshot 2024-07-05 183947

but the dataset properties goes blank again Screenshot 2024-07-05 184031

Im also attaching machine.config file machine.zip

Thanks in advance !

Steps to reproduce

Just try to add a dataset for reports in VS2022

Further technical details

Toolbox/Power Tools version: 4.8.776

Database engine: (SQlite)

Visual Studio or SSMS version: 2022

ErikEJ commented 4 months ago

You are using Microsoft.Data.Sqlite, that does not work. You need System.Data.Sqlite, and I am not sure it works with the DataSource designer.

juanmanuelsanche commented 4 months ago

can you point me in the right direction to do it correctly? Im completely loss here and I appreciate the help

ErikEJ commented 4 months ago

You need to point to Sysystem.Data.Sqlite in the Choose your Datasource dialog.

juanmanuelsanche commented 4 months ago

image

Sadly it wont show the option...

ErikEJ commented 4 months ago

What you are asking for is not supported, as per the wiki:

"The System.Data.SQLite DDEX provider does not support Visual Studio 2017, 2019 and 2022. This post describes how to work with SQLite and Entity Framework 6 in Visual Studio 2017/2019/2022, using the "SQLite Toolbox" DDEX provider for EF6. Notice that this provider only supports the EF 6 Tools, and not other Data Source scenarios, for example Typed DataSets. This requires Visual Studio 2017 15.8 or later."