Truncate does not work on SQLite

[csname1910]

Truncate does not work on SQLite because dbo is added.

This SQL-Command is generated:
DELETE FROM [dbo].[Customers];VACUUM;

SqliteException: SQLite Error 1: 'no such table: dbo.Customers'.

The right command should be:
DELETE FROM [Customers];VACUUM;

[doesbaddel]

Same issue here.

Problem is in TableInfo.cs Line 92, where the default value 'dbo' is set:
Schema = entityType.GetSchema() ?? "dbo";

[borisdj]

Fix:

bool isSqlServer = context.Database.ProviderName.EndsWith(DbServer.SqlServer.ToString());
string defaultSchema = isSqlServer ? "dbo" : null;
Schema = entityType.GetSchema() ?? defaultSchema;

Will publish this fix in the next version.

[borisdj]

Fixed

[Insire]

This seems to be broken again.

dbcontext.Truncate<MyTableModel>();

generates the following sql with ef core 6.0.10

DELETE FROM [dbo].[MyTable];VACUUM;

which throws

Exception thrown: 'Microsoft.Data.Sqlite.SqliteException' in Microsoft.EntityFrameworkCore.Relational.dll
SQLite Error 1: 'no such table: dbo.MyTable'.

Looking at the previous solution (dropping the schema), the cause seems to be

    /// <inheritdoc/>
    public void Truncate(DbContext context, TableInfo tableInfo)
    {
        string sql = SqlQueryBuilder.DeleteTable(tableInfo.FullTableName);
        context.Database.ExecuteSqlRaw(sql);
    }

where FullTableName is defined as public string FullTableName => $"{SchemaFormated}[{TableName}]";

[LeDahu22]

@borisdj It seems the schema is still added with the latest version on SQLite (8.0.2), causing the truncate to fail

[borisdj]

Will take a look.