'SQL logic error no such table: TEMP.SCHEMATABLES' when adding Sqlite database entity data model

[boni-shah]

After following the steps highlighted in "https://github.com/ErikEJ/SqlCeToolbox/wiki/EF6-workflow-with-SQLite-DDEX-provider", I am getting the below error when trying to add a sqlite database entity data model to my .NET Framework 4.8 project :

An error occurred while connecting to the database. The database might be unavailable. An exception of type "System.Data.Entity.Core.EntityCommandExecutionException" occurred. The error message is: "An error occurred while executing the command definition. See the inner exception for details.
The inner exception caught was of type 'System.Data.SQLite.SQLiteException', with this error message:
'SQL logic error no such table: TEMP.SCHEMATABLES'.'.

Steps to reproduce

1. Clone the project : https://github.com/boni-shah/SqliteEFTest/tree/master
2. Select "Add New Item" on the project.
3. Select "ADO.NET Entity Data Model"
4. Select "EF Designer from Database"
5. Create a new connection to the test.db file present at the root of the project.
6. This should throw the error.
   

Further technical details

Toolbox/Power Tools version: Version 4.8.776.0

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

Database engine: SQlite

Visual Studio version: Visual Studio 2022 (17.8.3)

Related to #936

[ErikEJ]

This is implemented in System.Data.Sqlite, please create an issue in the issue tracker there