search

ErikEJ / SqlCeToolbox

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

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

Closed boni-shah closed 5 months ago

boni-shah commented 5 months ago

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. image

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 commented 5 months ago

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