Base solution for your next web application
Open Closed

SQLite with Entity framework #1911


User avatar
0
itechcrazy1 created

Hello,

i am trying to use SQLite database with AB Framework using entity framework 6.But it's keep giving me following error,

HResult=-2146233087 Message=The underlying provider failed on Open. Source=EntityFramework StackTrace: at System.Data.Entity.Core.EntityClient.EntityConnection.Open() at System.Data.Entity.DbContextTransaction.EnsureOpenConnection() at System.Data.Entity.DbContextTransaction..ctor(EntityConnection connection) at System.Data.Entity.Database.BeginTransaction() at SQLite.CodeFirst.SqliteInitializerBase1.InitializeDatabase(TContext context) at SQLite.CodeFirst.SqliteCreateDatabaseIfNotExists1.InitializeDatabase(TContext context) at System.Data.Entity.Internal.InternalContext.<>c__DisplayClassf1.<CreateInitializationAction>b__e() at System.Data.Entity.Internal.InternalContext.PerformInitializationAction(Action action) InnerException: HResult=-2147024809 Message=isolationLevel Source=System.Data.SQLite StackTrace: at System.Data.SQLite.SQLiteConnection.BeginDbTransaction(IsolationLevel isolationLevel) at System.Data.SQLite.SQLiteConnection.BeginTransaction(IsolationLevel isolationLevel) at System.Data.SQLite.SQLiteEnlistment..ctor(SQLiteConnection cnn, Transaction scope, IsolationLevel defaultIsolationLevel, Boolean throwOnUnavailable, Boolean throwOnUnsupported) at System.Data.SQLite.SQLiteConnection.EnlistTransaction(Transaction transaction) at System.Data.SQLite.SQLiteConnection.Open() at System.Data.Entity.Infrastructure.Interception.DbConnectionDispatcher.<Open>b__36(DbConnection t, DbConnectionInterceptionContext c) at System.Data.Entity.Infrastructure.Interception.InternalDispatcher1.Dispatch[TTarget,TInterceptionContext](TTarget target, Action2 operation, TInterceptionContext interceptionContext, Action3 executing, Action`3 executed) at System.Data.Entity.Infrastructure.Interception.DbConnectionDispatcher.Open(DbConnection connection, DbInterceptionContext interceptionContext) at System.Data.Entity.Core.EntityClient.EntityConnection.

It's working fine with Asp.net mvc starter template and EF 6.

Is there anyone having similar issue ?

John.


3 Answer(s)
  • User Avatar
    0
    dojo created

    I have the same error :/

  • User Avatar
    0
    dojo created

    I have the same error , did you found a solution ?

  • User Avatar
    0
    hikalkan created
    Support Team

    Can you create an issue of Github, so we test it. Thanks.