Re: [sqlite] Fwd: System.Data.SQLite support incremental_vacuum

2016-06-09 Thread Joe Mistachkin
Ondra Medek wrote: > > Does .NET version support the "incremental_vacuum" feature or am I > doing something wrong? I am sure no other connection to the db exists > at the time the SQL command/query is issued. > Yes; however, the database "auto_vacuum" mode must be set to "incremental" first,

[sqlite] Fwd: System.Data.SQLite support incremental_vacuum

2016-06-09 Thread Ondra Medek
Hi, I am trying tu run "pragma incremental_vacuum" in .NET System.Data.SQLite 1.0.101.0 and it does nothing. I have auto_vacuum = 2. I can run "pragma incremental_vacuum" well from SQLiteStudio (sqlite_version 3.8.10). Does .NET version support the "incremental_vacuum" feature or am I doing

[sqlite] SQLite & .NET Entity Framework Model based on SQL Server

2016-06-09 Thread Simon Dunne
Hi All, I have an issue with my first use of SQLite. In summary, I have an Entity Framework model based on a SQL Server database (Database-First implementation) and I want to use those models in an application, but with SQLite as the back end. Our data is stored in SQL Server. We're