search

ErikEJ / SqlCeToolbox

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

probleme to use with vs2022 #945

Closed ikeas68 closed 2 years ago

ikeas68 commented 2 years ago

i follow procedure to install for 2022 (and test too with vs 2017) i can install data provider for sqlite informations : `

`

modification for machine.config <add name="SQLite Data Provider" invariant="System.Data.SQLite.EF6" description=".NET Framework Data Provider for SQLite" type="System.Data.SQLite.EF6.SQLiteProviderFactory, System.Data.SQLite, Version=1.0.116.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" />

version in gac of system.data.sqlite // C:\WINDOWS\Microsoft.NET\assembly\GAC_64\System.Data.SQLite\v4.0_1.0.116.0__db937bc2d44ff139\System.Data.SQLite.dll // System.Data.SQLite, Version=1.0.116.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139 // Global type: <Module> // Architecture: x64 // This assembly contains unmanaged code. // Runtime: v4.0.30319 // This assembly is signed with a strong name key. // Hash algorithm: SHA1 // Public key: 002400000480000094000000060200000024000052534131000400000100010005a288de5687c4e1b621ddff5d844727418956997f475eb829429e411aff3e93f97b70de698b972640925bdd44280df0a25a843266973704137cbb0e7441c1fe7cae4e2440ae91ab8cde3933febcb1ac48dd33b40e13c421d8215c18a4349a436dd499e3c385cc683015f886f6c10bd90115eb2bd61b67750839e3a19941dc9c

i don't know if i must change package on nuget install for using sqlite ... have you somes idees

ErikEJ commented 2 years ago

No ideas other than what is in the guide. What is not working?

ikeas68 commented 2 years ago

hello

first i i have install sqlite-netFx46-setup-bundle-x64-2015-1.0.116.0 116 version

i have add change in machine.config for <add name="SQLite Data Provider" invariant="System.Data.SQLite.EF6" description=".NET Framework Data Provider for SQLite" type="System.Data.SQLite.EF6.SQLiteProviderFactory, System.Data.SQLite.EF6, Version=1.0.116.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" />

but i have in sqlite/sql server tool box in about Version 4.8.761.0

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 SQLite ADO.NET provider loaded - 1.0.116.0

SQLite EF6 DbProvider in GAC - NoSystem.Data.SQLite DDEX provider - No SQLite Simple DDEX provider - Yes

with no provider in gac

if in the toolbox i can add connexion to sqlite [image: image.png] when i use data Ado.net entity data model >new connexion [image: image.png] [image: image.png] but when i want to valid with ok button [image: image.png] mean "unable to search or load .net framework data provider"

[image: width=] https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail Sans virus.www.avast.com https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail <#m_2597164689516057835_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

Le ven. 26 août 2022 à 07:05, Erik Ejlskov Jensen @.***> a écrit :

No ideas other than what is in the guide. What is not working?

— Reply to this email directly, view it on GitHub https://github.com/ErikEJ/SqlCeToolbox/issues/945#issuecomment-1228057607, or unsubscribe https://github.com/notifications/unsubscribe-auth/AEOQMAJLOUSUTBLO43DTNXTV3BGAXANCNFSM57VBTWVQ . You are receiving this because you authored the thread.Message ID: @.***>

[image: width=] https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail Sans virus.www.avast.com https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

ErikEJ commented 2 years ago

Which machine.config file are you changing?

ikeas68 commented 2 years ago

the file stored in C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config

[image: width=] https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail Sans virus.www.avast.com https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

Le ven. 26 août 2022 à 13:45, Erik Ejlskov Jensen @.***> a écrit :

Which machine.config file are you changing?

— Reply to this email directly, view it on GitHub https://github.com/ErikEJ/SqlCeToolbox/issues/945#issuecomment-1228392125, or unsubscribe https://github.com/notifications/unsubscribe-auth/AEOQMAO4NAU4GF2WQGMHBQ3V3CU5PANCNFSM57VBTWVQ . You are receiving this because you authored the thread.Message ID: @.***>

ErikEJ commented 2 years ago

That is the wrong folder! See this note in the wiki:

VS 2022 Copy the entry to the 64 bit machince.config located in C:\WINDOWS\Microsoft.NET\Framework64\v4.0.30319\Config

ikeas68 commented 2 years ago

what i find surprising that is i have no loader in toolbox info SQLite EF6 DbProvider in GAC - No System.Data.SQLite DDEX provider - No

even i check the gac with ilspy i have [image: image.png]

[image: width=] https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail Sans virus.www.avast.com https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

Le ven. 26 août 2022 à 13:54, Letreste Bruno @.***> a écrit :

sorry the file i have change i the good location in framework64 and i have inside

[image: width=] Sans virus.www.avast.com <#m_-8199432073426995935_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> Le ven. 26 août 2022 à 13:51, Erik Ejlskov Jensen < ***@***.***> a écrit : > That is the wrong folder! See this note in the wiki: > > *VS 2022* Copy the entry to the 64 bit machince.config located in > C:\WINDOWS\Microsoft.NET\Framework64\v4.0.30319\Config > > — > Reply to this email directly, view it on GitHub > , > or unsubscribe > > . > You are receiving this because you authored the thread.Message ID: > ***@***.***> >
ErikEJ commented 2 years ago

I cannot see your screenshots shared via email.

ikeas68 commented 2 years ago

what i find surprising that is i have no loader in toolbox info SQLite EF6 DbProvider in GAC - No System.Data.SQLite DDEX provider - No

even i check the gac with ilspy i have see screenshoot

[image: width=] https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail Sans virus.www.avast.com https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

Le ven. 26 août 2022 à 14:12, Erik Ejlskov Jensen @.***> a écrit :

I cannot see your screenshots shared via email.

— Reply to this email directly, view it on GitHub https://github.com/ErikEJ/SqlCeToolbox/issues/945#issuecomment-1228413894, or unsubscribe https://github.com/notifications/unsubscribe-auth/AEOQMAM6NXM2WXMGQ2XJ7M3V3CYEJANCNFSM57VBTWVQ . You are receiving this because you authored the thread.Message ID: @.***>

ErikEJ commented 2 years ago

Still cannot see screenshot, you need to go to GitHub.com and comment there iso via email.

But did you update the correct machine.config file?

ikeas68 commented 2 years ago

yes for the machine.config before i have modify the correct file not in framework but in framework64

[image: width=] https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail Sans virus.www.avast.com https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

Le ven. 26 août 2022 à 14:26, Letreste Bruno @.***> a écrit :

and error i have when i use ado.net entity data model

[image: width=] https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail Sans virus.www.avast.com https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail <#m_2858209400469621092_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

Le ven. 26 août 2022 à 14:23, Letreste Bruno @.***> a écrit :

what i find surprising that is i have no loader in toolbox info SQLite EF6 DbProvider in GAC - No System.Data.SQLite DDEX provider - No

even i check the gac with ilspy i have see screenshoot

[image: width=] https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail Sans virus.www.avast.com https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail <#m_2858209400469621092_m_2124520103914357077_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

Le ven. 26 août 2022 à 14:12, Erik Ejlskov Jensen < @.***> a écrit :

I cannot see your screenshots shared via email.

— Reply to this email directly, view it on GitHub https://github.com/ErikEJ/SqlCeToolbox/issues/945#issuecomment-1228413894, or unsubscribe https://github.com/notifications/unsubscribe-auth/AEOQMAM6NXM2WXMGQ2XJ7M3V3CYEJANCNFSM57VBTWVQ . You are receiving this because you authored the thread.Message ID: @.***>

ErikEJ commented 2 years ago

Without actually looking at your machine I think I cannot help you further.

ikeas68 commented 2 years ago

have you some idee why the toolbox cannot show SQLite EF6 DbProvider in GAC - No System.Data.SQLite DDEX provider - No in gac ?

[image: width=] https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail Sans virus.www.avast.com https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

Le ven. 26 août 2022 à 14:30, Erik Ejlskov Jensen @.***> a écrit :

Without actually looking at your machine I think I cannot help you further.

— Reply to this email directly, view it on GitHub https://github.com/ErikEJ/SqlCeToolbox/issues/945#issuecomment-1228429255, or unsubscribe https://github.com/notifications/unsubscribe-auth/AEOQMANFKOUNPSQ26O54WUTV3C2FLANCNFSM57VBTWVQ . You are receiving this because you authored the thread.Message ID: @.***>

ErikEJ commented 2 years ago

Because if a bad or missing entry in machine config or missing GAC registration

ikeas68 commented 2 years ago

it 's maybe a probleme whit 116 package of sqlite ?

[image: width=] https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail Sans virus.www.avast.com https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

Le ven. 26 août 2022 à 14:40, Erik Ejlskov Jensen @.***> a écrit :

Because if a bad or missing entry in machine config or missing GAC registration

— Reply to this email directly, view it on GitHub https://github.com/ErikEJ/SqlCeToolbox/issues/945#issuecomment-1228438725, or unsubscribe https://github.com/notifications/unsubscribe-auth/AEOQMAMO3ETNPR6HT7MODODV3C3KZANCNFSM57VBTWVQ . You are receiving this because you authored the thread.Message ID: @.***>

ikeas68 commented 2 years ago

for info i have check provider with the test software located in C:\Program Files (x86)\SQLite.NET\bin and it seen correct see picture

[image: width=] https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail Sans virus.www.avast.com https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

Le ven. 26 août 2022 à 14:44, Letreste Bruno @.***> a écrit :

it 's maybe a probleme whit 116 package of sqlite ?

[image: width=] https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail Sans virus.www.avast.com https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail <#m_-8264661731888759067_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

Le ven. 26 août 2022 à 14:40, Erik Ejlskov Jensen < @.***> a écrit :

Because if a bad or missing entry in machine config or missing GAC registration

— Reply to this email directly, view it on GitHub https://github.com/ErikEJ/SqlCeToolbox/issues/945#issuecomment-1228438725, or unsubscribe https://github.com/notifications/unsubscribe-auth/AEOQMAMO3ETNPR6HT7MODODV3C3KZANCNFSM57VBTWVQ . You are receiving this because you authored the thread.Message ID: @.***>

ErikEJ commented 2 years ago

What picture??

ikeas68 commented 2 years ago

this one i have try with vs 2017 : correct vs 2022 : not correct i create a new project with vs 20199 for testing

[image: width=] https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail Sans virus.www.avast.com https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

Le ven. 26 août 2022 à 15:11, Erik Ejlskov Jensen @.***> a écrit :

What picture??

— Reply to this email directly, view it on GitHub https://github.com/ErikEJ/SqlCeToolbox/issues/945#issuecomment-1228469546, or unsubscribe https://github.com/notifications/unsubscribe-auth/AEOQMAPGB7VAI46DISHAEO3V3C66VANCNFSM57VBTWVQ . You are receiving this because you authored the thread.Message ID: @.***>

ErikEJ commented 2 years ago

I see no picture...

ikeas68 commented 2 years ago

ok i have check with : vs2017 framework 4.6 > OK vs2019 framework 4.6 > OK vs2019 framework 4.8 > OK vs2022 framework 4.8 > NOT OK the difference between version ok an not ok are in tool box about for ok i have (vs2017/vs2019)

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

and for not ok (vs2022) i have

SQLite Engine in use - 3.38.5 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

[image: width=] https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail Sans virus.www.avast.com https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

Le ven. 26 août 2022 à 15:31, Erik Ejlskov Jensen @.***> a écrit :

I see no picture...

— Reply to this email directly, view it on GitHub https://github.com/ErikEJ/SqlCeToolbox/issues/945#issuecomment-1228493307, or unsubscribe https://github.com/notifications/unsubscribe-auth/AEOQMAJZMSJZIUXXEQVKMPDV3DBMTANCNFSM57VBTWVQ . You are receiving this because you authored the thread.Message ID: @.***>

ErikEJ commented 2 years ago

I will investigate...

ikeas68 commented 2 years ago

ok thanks

Le ven. 26 août 2022 à 15:56, Erik Ejlskov Jensen @.***> a écrit :

I will investigate...

— Reply to this email directly, view it on GitHub https://github.com/ErikEJ/SqlCeToolbox/issues/945#issuecomment-1228522812, or unsubscribe https://github.com/notifications/unsubscribe-auth/AEOQMALS3MLS2X55TWAPRSLV3DEJZANCNFSM57VBTWVQ . You are receiving this because you authored the thread.Message ID: @.***>

ErikEJ commented 2 years ago

After adding an entry for version 116 (wiki updated) to the machine.config file located in C:\WINDOWS\Microsoft.NET\Framework64\v4.0.30319\config I have this in Vs 2022:

Version 4.8.761.0 - more than 1.100.000 downloads

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

ikeas68 commented 2 years ago

sorry but where i can find wiki ?.

Le lun. 29 août 2022 à 07:44, Erik Ejlskov Jensen @.***> a écrit :

After adding an entry for version 116 (wiki updated) to the machine.config file located in C:\WINDOWS\Microsoft.NET\Framework64\v4.0.30319\config I have this in Vs 2022:

Version 4.8.761.0 - more than 1.100.000 downloads

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

— Reply to this email directly, view it on GitHub https://github.com/ErikEJ/SqlCeToolbox/issues/945#issuecomment-1229804182, or unsubscribe https://github.com/notifications/unsubscribe-auth/AEOQMAJYA4U26KTITFKVWDDV3RE2PANCNFSM57VBTWVQ . You are receiving this because you authored the thread.Message ID: @.***>

ErikEJ commented 2 years ago

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

ikeas68 commented 2 years ago

sorry the file i have change i the good location in framework64 and i have inside

[image: width=] Sans virus.www.avast.com <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> Le ven. 26 août 2022 à 13:51, Erik Ejlskov Jensen ***@***.***> a écrit : > That is the wrong folder! See this note in the wiki: > > *VS 2022* Copy the entry to the 64 bit machince.config located in > C:\WINDOWS\Microsoft.NET\Framework64\v4.0.30319\Config > > — > Reply to this email directly, view it on GitHub > , > or unsubscribe > > . > You are receiving this because you authored the thread.Message ID: > ***@***.***> >
ikeas68 commented 2 years ago

and error i have when i use ado.net entity data model

[image: width=] https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail Sans virus.www.avast.com https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

Le ven. 26 août 2022 à 14:23, Letreste Bruno @.***> a écrit :

what i find surprising that is i have no loader in toolbox info SQLite EF6 DbProvider in GAC - No System.Data.SQLite DDEX provider - No

even i check the gac with ilspy i have see screenshoot

[image: width=] https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail Sans virus.www.avast.com https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail <#m_2124520103914357077_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

Le ven. 26 août 2022 à 14:12, Erik Ejlskov Jensen < @.***> a écrit :

I cannot see your screenshots shared via email.

— Reply to this email directly, view it on GitHub https://github.com/ErikEJ/SqlCeToolbox/issues/945#issuecomment-1228413894, or unsubscribe https://github.com/notifications/unsubscribe-auth/AEOQMAM6NXM2WXMGQ2XJ7M3V3CYEJANCNFSM57VBTWVQ . You are receiving this because you authored the thread.Message ID: @.***>