The following error occurred while using the ABP to connect to SQLite:
System.Data.Entity.Core.EntityException: "The underlying provider failed on Open."
Inner exception
Argumentexception:isolationlevel
Look for a long time to solve, record.
1. Add a SQLite package to the Web and EF projects
2. Modify the Web. config file in a website project
Add Invariantname= "System.Data.SQLite", type with Invariantname= "System.Data.SQLite.EF6"
Database connection format <add name= "Default" providername= "System.Data.SQLite.EF6" connectionstring= "Data source=| datadirectory| xxx.db; Pooling=true "/>
3. Modify the transaction isolation level in the EF project
Error before modification:
Modify the following:
Mainly the following code:
Configuration.UnitOfWork.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
Using SQLite in the ABP