GAC Not Recognizing VS2022 and Crashed the Entire VS2022

[crmdevelop901]

Hello Erik, I have recently downloaded SQLite for my Senior Project but I am having a tough time getting it to work properly. I had downloaded the GAC after I downloaded the toolbox but then I looked at the info and it has No beside what the example you showed. To make matters worse when I put the code in the machine.config file my Visual Studios 2022 and 2019 did not boot up due to network issues. Is there anything I am doing wrong, where should I place the code at? I am using the updated version.

[ErikEJ]

It is very unclear what you are referring to. Please provide precise repro steps, otherwise I am not able to provide help.

[crmdevelop901]

Version 4.8.761.0 - more than 1,100,000 downloads

SQL Server Compact 4.0 in GAC - Yes - 4.0.8876.1 SQL Server Compact 4.0 DbProvider - Yes SQL Server Compact 4.0 Simple DDEX provider - Yes

SQL Server Compact 3.5 in GAC - No SQL Server Compact 3.5 DbProvider - No Sync Framework 2.1 SqlCe 3.5 provider - No

SQLite Engine in use - 3.38.5.1 SQLite ADO.NET provider loaded - 1.0.116.0 SQLite EF6 DbProvider in GAC - No System.Data.SQLite DDEX provider - No SQLite Simple DDEX provider - Yes

This is what I have so far. I am going through page after page regarding this issue with the community 2022 version of Visual Studios.

[crmdevelop901]

This is regarding the EF6 workflow with SQLite DDEX provider working on Visual Studios Community Version 2022.

[ErikEJ]

Your fragments of information are not helpful, sorry.

[crmdevelop901]

This is the code that you have document for VS2022 and I had copied it to both frameworks, when I boot up the installer I see this:

And these error messages:

This is where the code that you documented is placed in the machine.config file.

[crmdevelop901]

Making Visual Studio not boot up at all.

[ErikEJ]

You need to complete the installer.

What happens if you revert the machine.config changes?

[crmdevelop901]

It works just as normal and boots back up as normal.

[crmdevelop901]

I had follow the instructions but for some reason it does not work on Visual Studio 2022, however I will check on the 2019 version and see there is a yes in there.

[ErikEJ]

Feel free to share actual files ido screenshots.

First you must complete the 64 bit Installer.

[crmdevelop901]

One of your tools that I was trying to install, does not work anymore once I downloaded. It is SQL Server Compact/SQLite Toolbox for SSMS and the Entity Framework 6 Power Tools Community Edition.

[crmdevelop901]

Can you give me step-by-step instructions that is easy for me to understand, I have Autism so it could be confusing for me.

[ErikEJ]

The instructions are in the wiki. I can also offer you support if you sponsor me for a year.

[crmdevelop901]

I am a student at a university on my senior year and I don't know. I want all that publicity. I need to talk it over with my college. By the way, can you link me the instructions?

[ErikEJ]

https://github.com/ErikEJ/SqlCeToolbox/wiki/EF6-workflow-with-SQLite-DDEX-provider

[crmdevelop901]

Thank you. I looking at the wiki and something tweak my eye. Here is the photo:

I do not have a version of Visual Studio 2015 when I download the global assembly cache, so the last checkbox there:

was not there when I installed it.

[crmdevelop901]

Not to mention that I have a up-to-date laptop.

[crmdevelop901]

It is working but I have come to a little snag, should I installed the 3.5 version? here is the results.

The one circled in red is the only thing left that I am having trouble on Visual Studio. Is there any way to fix that issue?

[ErikEJ]

If you only work with SQLite you do not need SQL Compact 3.5

[crmdevelop901]

OK. Thank you so everything is working properly on my end.

[ErikEJ]

That is great to hear!