I have an app that needs to work with a lot of data, and to download it faster, I created a SQLite DataBase in SQLiteStudio, copied the file for a diferente andress, don't changed the file name and inserted data using my ASPNet MVC application. I maked downloaded this bank in the Xamarin forms app via WebApi.
After downloading in the app, when executing queries I get the error message "database disk image is malformed".
When making the same query in the windows or web application, the error does not occur.
I Executed the command to check de integrity, but don't havy any erros.
I don't know what else to do.
Can someone help me?
----------------------------------------------------------------------------
Xamarin App
Error
database disk image is malformed
using sqlite-net-pcl version 1.6.292
on project netstandard2.0
Consulta
var ConnectionInventario = new SQLiteConnection(pathFileBase, storeDateTimeAsTicks: false);
int count = ConnectionInventario.ExecuteScalar<int>(@"select count(*) from Patrimonio");
Some times, "select count(*) from Patrimonio" work fine but, "select count(*) from Patrimonio where StatusRegistroId = 2" show the error
----------------------------------------------------------------------------
Web Aplication
NO ERROS.
using System.Data.SQLite.Core 1.0.112
on TargetFrameworkVersion v4.5.2
var ConnectionInventario = new SQLiteConnection(UsuarioLogado.PathBaseFile);
int TotalPatrimonio = ConnectionInventario.ExecuteScalar<int>(@"select count(*) from Patrimonio");
----------------------------------------------------------------------------