zzzprojects / entityframework-effort Goto Github PK

System.Data.Entity.Infrastructure.CommitFailedException : An error was reported while committing a database transaction but it could not be determined whether the transaction succeeded or failed on the database server. See the inner exception and http://go.microsoft.com/fwlink/?LinkId=313468 for more information.
  ----> System.Transactions.TransactionAbortedException : The transaction has aborted.
  ----> System.TimeoutException : Transaction Timeout

System.Data.Entity.Core.EntityCommandExecutionException
An error occurred while executing the command definition. See the inner exception for details.
   at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
   at System.Data.Entity.Core.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext context, ObjectParameterCollection parameterValues)
   at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess)
   at System.Data.Entity.Core.Objects.ObjectQuery`1.<>c__DisplayClass7.<GetResults>b__5()
   at System.Data.Entity.Core.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
   at System.Data.Entity.Core.Objects.ObjectQuery`1.<System.Collections.Generic.IEnumerable<T>.GetEnumerator>b__0()
   at System.Data.Entity.Internal.LazyEnumerator`1.MoveNext()
   at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source)
   at Tests.UnitTests.Group01Tests.EffortEF6.TestEffortUsage.CreateDbContextViaEffort() in C:\Users\Jon\documents\visual studio 2015\Projects\OilAndGasWeb\Tests\UnitTests\Group01Tests\EffortEF6\TestEffortUsage.cs:line 22

Effort.Exceptions.EffortException
Database has not been initialized.

If using CodeFirst try to add the following line:
context.Database.CreateIfNotExists()
   at Effort.Internal.DbManagement.DbContainer.get_Internal()
   at Effort.Internal.DbManagement.DbContainer.GetTable(String name)
   at Effort.Internal.DbCommandTreeTransformation.TransformVisitor.Visit(DbScanExpression expression)
   at Effort.Internal.DbCommandTreeTransformation.TransformVisitor.Visit(DbGroupByExpression expression)
   at Effort.Internal.DbCommandTreeTransformation.TransformVisitor.Visit(DbProjectExpression expression)
   at Effort.Internal.CommandActions.QueryCommandAction.ExecuteDataReader(ActionContext context)
   at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed)
   at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.Reader(DbCommand command, DbCommandInterceptionContext interceptionContext)
   at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)

v = context.Stuff
                    .Include("Things")
                    .Include("Things.Children")
                    .Include("Table1.Nav1")
                    .Include("Table1.Nav2")
                    .Include("Table2.Nav1")
                    .Include("Table2.Nav2")
                    .FirstOrDefault(x => x.ThingId == matchObject.ThingId);

Result StackTrace:  
at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
   at System.Data.Entity.Core.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext context, ObjectParameterCollection parameterValues)
   at System.Data.Entity.Core.Objects.ObjectQuery`1.<>c__DisplayClass7.<GetResults>b__6()
   at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess)
   at System.Data.Entity.Core.Objects.ObjectQuery`1.<>c__DisplayClass7.<GetResults>b__5()
   at System.Data.Entity.Infrastructure.DefaultExecutionStrategy.Execute[TResult](Func`1 operation)
   at System.Data.Entity.Core.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
   at System.Data.Entity.Core.Objects.ObjectQuery`1.<System.Collections.Generic.IEnumerable<T>.GetEnumerator>b__0()
   at System.Data.Entity.Internal.LazyEnumerator`1.MoveNext()
   at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source)
   at System.Data.Entity.Core.Objects.ELinq.ObjectQueryProvider.<GetElementFunction>b__1[TResult](IEnumerable`1 sequence)
   at System.Data.Entity.Core.Objects.ELinq.ObjectQueryProvider.ExecuteSingle[TResult](IEnumerable`1 query, Expression queryRoot)
   at System.Data.Entity.Core.Objects.ELinq.ObjectQueryProvider.System.Linq.IQueryProvider.Execute[TResult](Expression expression)
   at System.Data.Entity.Internal.Linq.DbQueryProvider.Execute[TResult](Expression expression)
   at System.Linq.Queryable.FirstOrDefault[TSource](IQueryable`1 source, Expression`1 predicate)
   at MyProject.Migrations.SeedData.DefaultEditionsBuilder.CreateEditions() in C:\Users\Admin\Source\Repos\project\MyProject.EntityFramework\Migrations\SeedData\DefaultEditionsBuilder.cs:line 24
   at MyProject.Migrations.SeedData.DefaultEditionsBuilder.Build() in C:\Users\Admin\Source\Repos\project\MyProject.EntityFramework\Migrations\SeedData\DefaultEditionsBuilder.cs:line 19
   at MyProject.Migrations.SeedData.InitialDataBuilder.Create() in C:\Users\Admin\Source\Repos\project\MyProject.EntityFramework\Migrations\SeedData\InitialDataBuilder.cs:line 19
   at MyProject.Tests.AppTestBase.<>c.<.ctor>b__0_0(CrmDbContext context) in C:\Users\Admin\Source\Repos\project\Tests\MyProject.Tests\AppTestBase.cs:line 36
   at MyProject.Tests.AppTestBase.UsingDbContext(Action`1 action) in C:\Users\Admin\Source\Repos\project\Tests\MyProject.Tests\AppTestBase.cs:line 70
   at MyProject.Tests.AppTestBase..ctor() in C:\Users\Admin\Source\Repos\project\Tests\MyProject.Tests\AppTestBase.cs:line 34
   at MyProject.Tests.Authorization.Users.UserAppServiceTestBase..ctor() in C:\Users\Admin\Source\Repos\project\Tests\MyProject.Tests\Authorization\Users\UserAppServiceTestBase.cs:line 9
   at MyProject.Tests.Authorization.Users.UserAppService_GetUsers_Tests..ctor()
----- Inner Stack Trace -----
   at EFCache.QueryRegistrar.ContainsQuery(MetadataWorkspace workspace, String sql)
   at EFCache.CachingCommand.get_IsQueryAlwaysCached()
   at EFCache.CachingCommand.get_IsCacheable()
   at EFCache.CachingCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.<Reader>b__c(DbCommand t, DbCommandInterceptionContext`1 c)
   at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed)
   at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.Reader(DbCommand command, DbCommandInterceptionContext interceptionContext)
   at System.Data.Entity.Internal.InterceptableDbCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
Result Message: 
System.Data.Entity.Core.EntityCommandExecutionException : An error occurred while executing the command definition. See the inner exception for details.
---- System.ArgumentNullException : Value cannot be null.
Parameter name: sql

using (DbContextTransaction transaction = context.Database.BeginTransaction())
{
    // Store a recipe:
    context.Recipes.Add(recipe);
    context.SaveChanges(); // no commit!

    // Now retrieve it:
    int total = context.Recipes.Count(); // result is zero
}

public async Task TestMethod1()
{
    DbConnection inMemoryConnection =                
        Effort.DbConnectionFactory.CreateTransient();

    using (var dbContext = MyDbContext.CreateDbContext(inMemoryConnection)) 
    {
        // Fails on this line (triggered by Add method):
        dbContext.Users.Add(new User()
        {
            Id = 1                         
        });
        var item = dbContext.User.Find(1);
        Assert.AreEqual(1, item.Id);
    } 
}

Test Name:  TestMethod1
Test FullName:  ****
Test Source:    **** : line 21
Test Outcome:   Failed
Test Duration:  0:00:00,5738216

Result Message: 
Test method ****.TestMethod1 threw exception: 
System.InvalidOperationException: Sequence contains no matching element
Result StackTrace:  
at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source, Func`2 predicate)
   at System.Data.Entity.Utilities.DbProviderManifestExtensions.GetStoreTypeFromName(DbProviderManifest providerManifest, String name)
   at System.Data.Entity.ModelConfiguration.Configuration.Properties.Primitive.PrimitivePropertyConfiguration.ConfigureColumn(EdmProperty column, EntityType table, DbProviderManifest providerManifest)
   at System.Data.Entity.ModelConfiguration.Configuration.Properties.Primitive.PrimitivePropertyConfiguration.Configure(EdmProperty column, EntityType table, DbProviderManifest providerManifest, Boolean allowOverride, Boolean fillFromExistingConfiguration)
   at System.Data.Entity.ModelConfiguration.Configuration.Properties.Primitive.PrimitivePropertyConfiguration.<>c__DisplayClass4.<Configure>b__3(Tuple`2 pm)
   at System.Data.Entity.Utilities.IEnumerableExtensions.Each[T](IEnumerable`1 ts, Action`1 action)
   at System.Data.Entity.ModelConfiguration.Configuration.Properties.Primitive.PrimitivePropertyConfiguration.Configure(IEnumerable`1 propertyMappings, DbProviderManifest providerManifest, Boolean allowOverride, Boolean fillFromExistingConfiguration)
   at System.Data.Entity.ModelConfiguration.Configuration.Types.StructuralTypeConfiguration.ConfigurePropertyMappings(IList`1 propertyMappings, DbProviderManifest providerManifest, Boolean allowOverride)
   at System.Data.Entity.ModelConfiguration.Configuration.Types.EntityTypeConfiguration.ConfigurePropertyMappings(DbDatabaseMapping databaseMapping, EntityType entityType, DbProviderManifest providerManifest, Boolean allowOverride)
   at System.Data.Entity.ModelConfiguration.Configuration.Types.EntityTypeConfiguration.Configure(EntityType entityType, DbDatabaseMapping databaseMapping, DbProviderManifest providerManifest)
   at System.Data.Entity.ModelConfiguration.Configuration.ModelConfiguration.ConfigureEntityTypes(DbDatabaseMapping databaseMapping, ICollection`1 entitySets, DbProviderManifest providerManifest)
   at System.Data.Entity.ModelConfiguration.Configuration.ModelConfiguration.Configure(DbDatabaseMapping databaseMapping, DbProviderManifest providerManifest)
   at System.Data.Entity.DbModelBuilder.Build(DbProviderManifest providerManifest, DbProviderInfo providerInfo)
   at System.Data.Entity.DbModelBuilder.Build(DbConnection providerConnection)
   at System.Data.Entity.Internal.LazyInternalContext.CreateModel(LazyInternalContext internalContext)
   at System.Data.Entity.Internal.RetryLazy`2.GetValue(TInput input)
   at System.Data.Entity.Internal.LazyInternalContext.InitializeContext()
   at System.Data.Entity.Internal.InternalContext.GetEntitySetAndBaseTypeForType(Type entityType)
   at System.Data.Entity.Internal.Linq.InternalSet`1.Initialize()
   at System.Data.Entity.Internal.Linq.InternalSet`1.get_InternalContext()
   at System.Data.Entity.Internal.Linq.InternalSet`1.ActOnSet(Action action, EntityState newState, Object entity, String methodName)
   at System.Data.Entity.Internal.Linq.InternalSet`1.Add(Object entity)
   at System.Data.Entity.DbSet`1.Add(TEntity entity)
   at ****.<TestMethod1>d__1.MoveNext() in ****:line 29
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.GetResult()

public class MyDbContext : DbContext
{    
    public DbSet<User> Users { get; set; }

    private MyDbContext() : base()
    {
        this.Configuration.LazyLoadingEnabled = false;
    }

    private MyDbContext(DbConnection connection) : base(connection, true)
    {
        this.Configuration.LazyLoadingEnabled = false;
    }

    public static MyDbContext CreateDbContext(DbConnection connection = null)
    {
        if (connection == null)
           return new MyDbContext();

        return new MyDbContext(connection);
    }
}

public class User
{

    [Key]
    public long Id { get; set; }

    [Required]
    [MaxLength(PropertyLengths.UserUsernameMax)]
    [MinLength(PropertyLengths.UserUsernameMin)]
    [Index(IsUnique = true)]
    public string Username { get; set; }

    [Required]
    [MaxLength(PropertyLengths.UserEmailMax)]
    [EmailAddress]
    [Index(IsUnique = true)]
    public string Email { get; set; }

    public DateTime RegistrationTime { get; set; }

    [Required]
    [MaxLength(PropertyLengths.UserPasswordBinaryMax)]
    public byte[] Password { get; set; }

    public bool IsSupaUza { get; set; }

    public virtual ICollection<SomeEntity1> SomeEntities1 { get; set; }

    public virtual ICollection<SomeEntity2> SomeEntities2 { get; set; }

    public virtual ICollection<SomeEntity3> SomeEntities3 { get; set; }

    [MaxLength(PropertyLengths.DefaultMax)]
    public string FirstName { get; set; }

    [MaxLength(PropertyLengths.DefaultMax)]
    public string LastName { get; set; }

    [Column(TypeName = "Date")]
    public DateTime DateOfBirth { get; set; }

    [MaxLength(PropertyLengths.BlobUri)]
    public string MyCoolPic { get; set; }     
}

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <configSections>
    <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->
    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
  </configSections>
  <runtime>
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
      <dependentAssembly>
        <assemblyIdentity name="Newtonsoft.Json" publicKeyToken="30ad4fe6b2a6aeed" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-6.0.0.0" newVersion="6.0.0.0" />
      </dependentAssembly>
    </assemblyBinding>
  </runtime>
  <entityFramework>
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework" />
    <providers>
      <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />      
    </providers>
  </entityFramework>  
</configuration>

<?xml version="1.0" encoding="utf-8"?>
<packages>
  <package id="Effort.EF6" version="1.1.4" targetFramework="net45" />
  <package id="EntityFramework" version="6.1.3" targetFramework="net45" />
  <package id="NMemory" version="1.0.1" targetFramework="net45" />
</packages>

  static LibraryContext()
        {
                Database.SetInitializer(new MigrateDatabaseToLatestVersion<LibraryContext, Configuration>());
        }

System.InvalidOperationException was unhandled by user code
  HResult=-2146233079
  Message=No Entity Framework provider found for the ADO.NET provider with invariant name 'Effort.Provider'. Make sure the provider is registered in the 'entityFramework' section of the application config file. See http://go.microsoft.com/fwlink/?LinkId=260882 for more information.
  Source=EntityFramework
  StackTrace:
       at System.Data.Entity.Infrastructure.DependencyResolution.DefaultProviderServicesResolver.GetService(Type type, Object key)
       at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKey key, Func`2 valueFactory)
       at System.Linq.Enumerable.WhereSelectArrayIterator`2.MoveNext()
       at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source, Func`2 predicate)
       at System.Data.Entity.Infrastructure.DependencyResolution.RootDependencyResolver.GetService(Type type, Object key)
       at System.Linq.Enumerable.WhereSelectArrayIterator`2.MoveNext()
       at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source, Func`2 predicate)
       at System.Data.Entity.Infrastructure.DependencyResolution.CompositeResolver`2.GetService(Type type, Object key)
       at System.Data.Entity.Infrastructure.DependencyResolution.DbDependencyResolverExtensions.GetService[T](IDbDependencyResolver resolver, Object key)
       at System.Data.Entity.Infrastructure.DefaultManifestTokenResolver.<>c__DisplayClass1.<ResolveManifestToken>b__0(Tuple`3 k)
       at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKey key, Func`2 valueFactory)
       at System.Data.Entity.Utilities.DbConnectionExtensions.GetProviderInfo(DbConnection connection, DbProviderManifest& providerManifest)
       at System.Data.Entity.DbModelBuilder.Build(DbConnection providerConnection)
       at System.Data.Entity.Internal.LazyInternalContext.CreateModel(LazyInternalContext internalContext)
       at System.Data.Entity.Internal.RetryLazy`2.GetValue(TInput input)
       at System.Data.Entity.Internal.LazyInternalContext.InitializeContext()
       at System.Data.Entity.Internal.InternalContext.GetEntitySetAndBaseTypeForType(Type entityType)
       at System.Data.Entity.Internal.Linq.InternalSet`1.Initialize()
       at System.Data.Entity.Internal.Linq.InternalSet`1.get_InternalContext()
       at System.Data.Entity.Migrations.DbSetMigrationsExtensions.GetKeyProperties[TEntity](Type entityType, InternalSet`1 internalSet)
       at System.Data.Entity.Migrations.DbSetMigrationsExtensions.AddOrUpdate[TEntity](IDbSet`1 set, TEntity[] entities)
       at Cpr.Apps.Sam.Test.Model.Integration.Helpers.EffortEamEntitiesTestData.AddTestData(IEamEntities context) in C:\src\trunk\Cpr.Apps.Sam.Test.Model.Integration\Helpers\EffortEamEntitiesTestData.cs:line 37
       at Cpr.Apps.Sam.Test.Model.Integration.Helpers.IntegrationTest.IntegrationTestSetup() in C:\src\trunk\Cpr.Apps.Sam.Test.Model.Integration\Helpers\IntegrationTest.cs:line 51
  InnerException: 

public Message
{
      [Key]
      public long GId;

      [DatabaseGenerated(DatabaseGeneratedOption.None)]  
      public int Id;
}

_kernel.Rebind<DbConnection>().ToConstant(Effort.DbConnectionFactory.CreateTransient());

public class MyDbContext : IdentityDbContext<MyApplicationUser>
{
    public MyDbContext()
        : base("DefaultConnection", false)
    {
        // This is version I want to start injecting dbconnection into, like below
        // <add name="DefaultConnection" connectionString="data source=localhost;initial catalog=MyDbTable;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework" providerName="System.Data.SqlClient" />
    }

    public MyDbContext(DbConnection connection)
        : base(connection.ConnectionString, false)
    {
        Console.WriteLine(connection.ConnectionString); // instanceid=0c8baee5-5790-4b37-9772-49fe7da75f43
    }
}

System.ArgumentException: Keyword not supported: 'instanceid'.

System.Data.Entity.Infrastructure.CommitFailedException : An error was reported while committing a database transaction but it could not be determined whether the transaction succeeded or failed on the database server. See the inner exception and http://go.microsoft.com/fwlink/?LinkId=313468 for more information.
        ---- System.Transactions.TransactionAbortedException : 已中止事务。
        -------- System.TimeoutException : 事务超时
        Stack Trace:
             在 System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext](TTarget target, Action`2 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed)
             在 System.Data.Entity.Infrastructure.Interception.DbTransactionDispatcher.Commit(DbTransaction transaction, DbInterceptionContext interceptionContext)
             在 System.Data.Entity.Core.EntityClient.EntityTransaction.Commit()
             在 System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess)
             在 System.Data.Entity.Core.Objects.ObjectContext.SaveChangesToStore(SaveOptions options, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction)
             在 System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass2a.<SaveChangesInternal>b__27()
             在 System.Data.Entity.Infrastructure.DefaultExecutionStrategy.Execute[TResult](Func`1 operation)
             在 System.Data.Entity.Core.Objects.ObjectContext.SaveChangesInternal(SaveOptions options, Boolean executeInExistingTransaction)
             在 System.Data.Entity.Core.Objects.ObjectContext.SaveChanges(SaveOptions options)
             在 System.Data.Entity.Internal.InternalContext.SaveChanges()
             在 System.Data.Entity.Internal.LazyInternalContext.SaveChanges()
             在 Abp.EntityFramework.AbpDbContext.SaveChanges()

          ----- Inner Stack Trace -----
             在 System.Transactions.TransactionStateAborted.BeginCommit(InternalTransaction tx, Boolean asyncCommit, AsyncCallback asyncCallback, Object asyncState)
             在 System.Transactions.CommittableTransaction.Commit()
             在 Effort.Provider.EffortTransaction.Commit()
             在 System.Data.Entity.Infrastructure.Interception.DbTransactionDispatcher.<Commit>b__c(DbTransaction t, DbTransactionInterceptionContext c)
             在 System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext](TTarget target, Action`2 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed)
          ----- Inner Stack Trace -----

Test Name:  TestXXX
Test FullName:  Domain.Data.Test.Model.EfXXXUnitTest.TestNumeroReference
Test Source:    EfXXXUnitTest.cs : line 57
Test Outcome:   Failed
Test Duration:  0:00:00.0342313

Result Message: 
Test method Domain.Data.Test.Model.EfXXXUnitTest.TestNumeroReference threw exception: 
System.InvalidOperationException: Sequence contains no matching element
Result StackTrace:  
at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source, Func`2 predicate)
   at System.Data.Entity.Utilities.DbProviderManifestExtensions.GetStoreTypeFromName(DbProviderManifest providerManifest, String name)
   at System.Data.Entity.ModelConfiguration.Configuration.Properties.Primitive.PrimitivePropertyConfiguration.ConfigureColumn(EdmProperty column, EntityType table, DbProviderManifest providerManifest)
   at System.Data.Entity.ModelConfiguration.Configuration.Properties.Primitive.PrimitivePropertyConfiguration.Configure(EdmProperty column, EntityType table, DbProviderManifest providerManifest, Boolean allowOverride, Boolean fillFromExistingConfiguration)
   at System.Data.Entity.ModelConfiguration.Configuration.Properties.Primitive.PrimitivePropertyConfiguration.<>c__DisplayClass4.<Configure>b__3(Tuple`2 pm)
   at System.Data.Entity.Utilities.IEnumerableExtensions.Each[T](IEnumerable`1 ts, Action`1 action)
   at System.Data.Entity.ModelConfiguration.Configuration.Properties.Primitive.PrimitivePropertyConfiguration.Configure(IEnumerable`1 propertyMappings, DbProviderManifest providerManifest, Boolean allowOverride, Boolean fillFromExistingConfiguration)
   at System.Data.Entity.ModelConfiguration.Configuration.Types.StructuralTypeConfiguration.ConfigurePropertyMappings(IList`1 propertyMappings, DbProviderManifest providerManifest, Boolean allowOverride)
   at System.Data.Entity.ModelConfiguration.Configuration.ModelConfiguration.Configure(DbDatabaseMapping databaseMapping, DbProviderManifest providerManifest)
   at System.Data.Entity.DbModelBuilder.Build(DbProviderManifest providerManifest, DbProviderInfo providerInfo)
   at System.Data.Entity.DbModelBuilder.Build(DbConnection providerConnection)
   at System.Data.Entity.Internal.LazyInternalContext.CreateModel(LazyInternalContext internalContext)
   at System.Data.Entity.Internal.RetryLazy`2.GetValue(TInput input)
   at System.Data.Entity.Internal.LazyInternalContext.InitializeContext()
   at System.Data.Entity.Internal.InternalContext.GetEntitySetAndBaseTypeForType(Type entityType)
   at System.Data.Entity.Internal.Linq.InternalSet`1.Initialize()
   at System.Data.Entity.Internal.Linq.InternalSet`1.get_InternalContext()
   at System.Data.Entity.Infrastructure.DbQuery`1.System.Linq.IQueryable.get_Provider()
   at System.Linq.Queryable.Where[TSource](IQueryable`1 source, Expression`1 predicate)
   at Domain.Data.Model.EfXXXRepository.ListForNumeroReference(String NumeroReference) in Domain.Data\Model\EfXXXRepository.cs:line 22
   at Domain.Data.Test.Model.EfXXXUnitTest.TestForNumeroReference() in Domain.Data.Test\Model\EfXXXUnitTest.cs:line 58

System.Data.Entity.Migrations.Infrastructure.MigrationsException : No MigrationSqlGenerator found for provider 'Effort.Provider'. Use the SetSqlGenerator method in the target migrations configuration class to register additional SQL generators.
   at System.Data.Entity.Migrations.DbMigrationsConfiguration.GetSqlGenerator(String providerInvariantName)
   at System.Data.Entity.Migrations.DbMigrator.GenerateStatements(IList`1 operations, String migrationId)
   at System.Data.Entity.Migrations.DbMigrator.ExecuteOperations(String migrationId, VersionedModel targetModel, IEnumerable`1 operations, IEnumerable`1 systemOperations, Boolean downgrading, Boolean auto)
   at System.Data.Entity.Migrations.DbMigrator.ApplyMigration(DbMigration migration, DbMigration lastMigration)
   at System.Data.Entity.Migrations.DbMigrator.Upgrade(IEnumerable`1 pendingMigrations, String targetMigrationId, String lastMigrationId)
   at System.Data.Entity.Migrations.DbMigrator.EnsureDatabaseExists(Action mustSucceedToKeepDatabase)
   at System.Data.Entity.MigrateDatabaseToLatestVersion`2.InitializeDatabase(TContext context)
   at System.Data.Entity.Internal.InternalContext.PerformInitializationAction(Action action)
   at System.Data.Entity.Internal.InternalContext.PerformDatabaseInitialization()
   at System.Data.Entity.Internal.RetryAction`1.PerformAction(TInput input)
   at System.Data.Entity.Internal.LazyInternalContext.InitializeDatabaseAction(Action`1 action)
   at System.Data.Entity.Internal.InternalContext.GetEntitySetAndBaseTypeForType(Type entityType)
   at System.Data.Entity.Internal.Linq.InternalSet`1.Initialize()
   at System.Data.Entity.Internal.Linq.InternalSet`1.get_InternalContext()
   at System.Data.Entity.Internal.Linq.InternalSet`1.ActOnSet(Action action, EntityState newState, Object entity, String methodName)
   at System.Data.Entity.Internal.Linq.InternalSet`1.Add(Object entity)
   at System.Data.Entity.DbSet`1.Add(TEntity entity)

System.Data.Entity.Infrastructure.DbUpdateException : An error occurred while updating the entries. See the inner exception for details.
  ----> System.Data.Entity.Core.UpdateException : An error occurred while updating the entries. See the inner exception for details.
  ----> System.Reflection.TargetInvocationException : Exception has been thrown by the target of an invocation.
  ----> NMemory.Exceptions.MultipleUniqueKeyFoundException : Error code: GenericError
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
   at Cpr.Apps.Sam.Model.Base.AdoNetRepository`1.<Save>d__48.MoveNext() in C:\src\trunk\Cpr.Apps.Sam.Model\Base\AdoNetRepository.cs:line 598
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
   at Cpr.Apps.Sam.Test.Model.Integration.Integration.Repositories.InspectionRepositoryTests.<WillCallCompleteInspectionWithInspectionRepository>d__7.MoveNext() in C:\src\trunk\Cpr.Apps.Sam.Test.Model.Integration\Integration\Repositories\InspectionRepositoryTests.cs:line 74
--- End of stack trace from previous location where exception was thrown ---
   at NUnit.Framework.Internal.ExceptionHelper.Rethrow(Exception exception)
   at NUnit.Framework.Internal.AsyncInvocationRegion.AsyncTaskInvocationRegion.WaitForPendingOperationsToComplete(Object invocationResult)
   at NUnit.Framework.Internal.Commands.TestMethodCommand.RunAsyncTestMethod(TestExecutionContext context)
--UpdateException
   at System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.<UpdateAsync>d__0.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Data.Entity.Core.Objects.ObjectContext.<ExecuteInTransactionAsync>d__3d`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Data.Entity.Core.Objects.ObjectContext.<SaveChangesToStoreAsync>d__39.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Data.Entity.Core.Objects.ObjectContext.<SaveChangesInternalAsync>d__31.MoveNext()
--TargetInvocationException
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   at Effort.Internal.Common.DatabaseReflectionHelper.InsertEntity(ITable table, Object entity, Transaction transaction)
   at Effort.Internal.CommandActions.InsertCommandAction.CreateAndInsertEntity(ITable table, IList`1 memberBindings, Transaction transaction)
   at Effort.Internal.CommandActions.InsertCommandAction.ExecuteNonQuery(ActionContext context)
   at System.Data.Common.DbCommand.ExecuteNonQueryAsync(CancellationToken cancellationToken)
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task task)
   at System.Data.Entity.Core.Mapping.Update.Internal.DynamicUpdateCommand.<ExecuteAsync>d__0.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.<UpdateAsync>d__0.MoveNext()
--MultipleUniqueKeyFoundException
   at NMemory.DataStructures.UniqueHashtable`2.Insert(TKey key, TEntity entity)
   at NMemory.Execution.CommandExecutor.ExecuteInsert[T](T entity, IExecutionContext context)
   at NMemory.Tables.DefaultTable`2.InsertCore(TEntity entity, Transaction transaction)
   at Effort.Internal.DbManagement.Engine.ExtendedTable`2.InsertCore(TEntity entity, Transaction transaction)
   at NMemory.Tables.Table`2.Insert(TEntity entity, Transaction transaction)

---> 2016-09-26 16:18:29 -06:00 [INFO] [GENERAL] Saving changes to the database... / AdoNetRepository.cs:591 (2.26.0.3604) [Save()]
---> 2016-09-26 16:18:29 -06:00 [INFO] [GENERAL] Save successfull. / AdoNetRepository.cs:599 (2.26.0.3604) [Save()]
---> 2016-09-26 16:18:30 -06:00 [INFO] [GENERAL] Saving changes to the database... / AdoNetRepository.cs:591 (2.26.0.3604) [Save()]

System.Data.Entity.Infrastructure.CommitFailedException : An error was reported while committing a database transaction but it could not be determined whether the transaction succeeded or failed on the database server. See the inner exception and http://go.microsoft.com/fwlink/?LinkId=313468 for more information.
---- System.Transactions.TransactionAbortedException : The transaction has aborted.
-------- System.TimeoutException : Transaction Timeout

System.Data.DataException: An exception occurred while initializing the database. See the InnerException for details. ---> 
System.Data.Entity.Infrastructure.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. ---> 
System.Data.Entity.Core.UpdateException: An error occurred while updating the entries. See the inner exception for details. ---> 
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> 
NMemory.Exceptions.NMemoryException: Error code: GenericError ---> 
System.InvalidOperationException: Sequence contains more than one matching element

    at System.Linq.Enumerable.SingleOrDefault(IEnumerable`1 source, Func`2 predicate)
   at NMemory.Tables.TableCollection.FindTable(Type entityType)
   at NMemory.Utilities.TableCollectionExtensions.FindTable(TableCollection tableCollection)
   at NMemory.Execution.CommandExecutor.ExecuteInsert(T entity, IExecutionContext context)
   at NMemory.Tables.DefaultTable`2.InsertCore(TEntity entity, Transaction transaction)
   at Effort.Internal.DbManagement.Engine.ExtendedTable`2.InsertCore(TEntity entity, Transaction transaction)
   at NMemory.Tables.Table`2.Insert(TEntity entity, Transaction transaction)
 --- End of inner exception stack trace ---
    at NMemory.Tables.Table`2.Insert(TEntity entity, Transaction transaction)
   at Effort.Internal.Common.DatabaseReflectionHelper.WrapperMethods.InsertEntity(ITable`1 table, TEntity entity, Transaction transaction)
 --- End of inner exception stack trace ---
    at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   at Effort.Internal.Common.DatabaseReflectionHelper.InsertEntity(ITable table, Object entity, Transaction transaction)
   at Effort.Internal.CommandActions.InsertCommandAction.CreateAndInsertEntity(ITable table, IList`1 memberBindings, Transaction transaction)
   at Effort.Internal.CommandActions.InsertCommandAction.ExecuteNonQuery(ActionContext context)
   at Effort.Provider.EffortEntityCommand.ExecuteNonQuery()
   at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.<NonQuery>b__0(DbCommand t, DbCommandInterceptionContext`1 c)
   at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch(TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed)
   at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.NonQuery(DbCommand command, DbCommandInterceptionContext interceptionContext)
   at System.Data.Entity.Internal.InterceptableDbCommand.ExecuteNonQuery()
   at System.Data.Entity.Core.Mapping.Update.Internal.DynamicUpdateCommand.Execute(Dictionary`2 identifierValues, List`1 generatedValues)
   at System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.Update()
 --- End of inner exception stack trace ---
    at System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.Update()
   at System.Data.Entity.Core.EntityClient.Internal.EntityAdapter.<Update>b__2(UpdateTranslator ut)
   at System.Data.Entity.Core.EntityClient.Internal.EntityAdapter.Update(T noChangesResult, Func`2 updateFunction)
   at System.Data.Entity.Core.EntityClient.Internal.EntityAdapter.Update()
   at System.Data.Entity.Core.Objects.ObjectContext.<SaveChangesToStore>b__35()
   at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction(Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess)
   at System.Data.Entity.Core.Objects.ObjectContext.SaveChangesToStore(SaveOptions options, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction)
   at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass2a.<SaveChangesInternal>b__27()
   at System.Data.Entity.Infrastructure.DefaultExecutionStrategy.Execute(Func`1 operation)
   at System.Data.Entity.Core.Objects.ObjectContext.SaveChangesInternal(SaveOptions options, Boolean executeInExistingTransaction)
   at System.Data.Entity.Core.Objects.ObjectContext.SaveChanges(SaveOptions options)
   at System.Data.Entity.Internal.InternalContext.SaveChanges()
 --- End of inner exception stack trace ---
    at System.Data.Entity.Internal.InternalContext.SaveChanges()
   at System.Data.Entity.Internal.LazyInternalContext.SaveChanges()
   at System.Data.Entity.DbContext.SaveChanges()
   at System.Data.Entity.Migrations.History.HistoryRepository.BootstrapUsingEFProviderDdl(VersionedModel versionedModel)
   at System.Data.Entity.Internal.InternalContext.<SaveMetadataToDatabase>b__7()
   at System.Data.Entity.Internal.InternalContext.PerformInitializationAction(Action action)
   at System.Data.Entity.Internal.InternalContext.SaveMetadataToDatabase()
   at System.Data.Entity.Internal.DatabaseCreator.CreateDatabase(InternalContext internalContext, Func`3 createMigrator, ObjectContext objectContext)
   at System.Data.Entity.Internal.InternalContext.CreateDatabase(ObjectContext objectContext, DatabaseExistenceState existenceState)
   at System.Data.Entity.Database.Create(DatabaseExistenceState existenceState)
   at System.Data.Entity.CreateDatabaseIfNotExists`1.InitializeDatabase(TContext context)
   at System.Data.Entity.Internal.InternalContext.<>c__DisplayClassf`1.<CreateInitializationAction>b__e()
   at System.Data.Entity.Internal.InternalContext.PerformInitializationAction(Action action)
 --- End of inner exception stack trace ---
    at System.Data.Entity.Internal.InternalContext.PerformInitializationAction(Action action)
   at System.Data.Entity.Internal.InternalContext.PerformDatabaseInitialization()
   at System.Data.Entity.Internal.LazyInternalContext.<InitializeDatabase>b__4(InternalContext c)
   at System.Data.Entity.Internal.RetryAction`1.PerformAction(TInput input)
   at System.Data.Entity.Internal.LazyInternalContext.InitializeDatabaseAction(Action`1 action)
   at System.Data.Entity.Internal.LazyInternalContext.InitializeDatabase()
   at System.Data.Entity.Internal.InternalContext.GetEntitySetAndBaseTypeForType(Type entityType)
   at System.Data.Entity.Internal.Linq.InternalSet`1.Initialize()
   at System.Data.Entity.Internal.Linq.InternalSet`1.get_InternalContext()
   at System.Data.Entity.Infrastructure.DbQuery`1.System.Linq.IQueryable.get_Provider()
   at System.Linq.Queryable.Count(IQueryable`1 source)

   at Model.MyProj... my test method call stack here

var query = db.MyEntities.Count(); // will throw the exception above FOR SOME DBCONTEXTS ONLY!!!

System.InvalidOperationException occurred
  HResult=-2146233079
  Message=The 'Instance' member of the Entity Framework provider type 'Effort.Provider.EffortProviderServices, Effort, Version=1.0.0.0, Culture=neutral, PublicKeyToken=6a46696d54971e6d' did not return an object that inherits from 'System.Data.Entity.Core.Common.DbProviderServices'. Entity Framework providers must inherit from this class and the 'Instance' member must return the singleton instance of the provider. This may be because the provider does not support Entity Framework 6 or later; see http://go.microsoft.com/fwlink/?LinkId=260882 for more information.
  Source=EntityFramework
  StackTrace:
       at System.Data.Entity.Infrastructure.DependencyResolution.ProviderServicesFactory.GetInstance(Type providerType)
       at System.Data.Entity.Internal.AppConfig.<.ctor>b__2(ProviderElement e)
       at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
       at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
       at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
       at System.Lazy`1.CreateValue()
       at System.Lazy`1.LazyInitValue()
       at System.Data.Entity.Infrastructure.DependencyResolution.AppConfigDependencyResolver.RegisterDbProviderServices()
       at System.Data.Entity.Infrastructure.DependencyResolution.AppConfigDependencyResolver.GetServiceFactory(Type type, String name)
       at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKey key, Func`2 valueFactory)
       at System.Data.Entity.Infrastructure.DependencyResolution.AppConfigDependencyResolver.GetService(Type type, Object key)
       at System.Linq.Enumerable.WhereSelectArrayIterator`2.MoveNext()
       at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source, Func`2 predicate)
       at System.Data.Entity.Infrastructure.DependencyResolution.CompositeResolver`2.GetService(Type type, Object key)
       at System.Data.Entity.Infrastructure.DependencyResolution.DbDependencyResolverExtensions.GetService[T](IDbDependencyResolver resolver)
       at System.Data.Entity.DbContext.InitializeLazyInternalContext(IInternalConnection internalConnection, DbCompiledModel model)
       at Microsoft.AspNet.Identity.EntityFramework.IdentityDbContext`1..ctor(DbConnection existingConnection, Boolean contextOwnsConnection)
       at MyProject.ApplicationDbContext..ctor(DbConnection connection) in ..\MyProject\ApplicationDbContext.cs:Zeile 16.
  InnerException: 

public class PersonEntity
{
       [Key]       
        public int Id { get; set; } 
        public string Name { get; set; } 
        public virtual ICollection<AccomplishmentEntity> Accomplishments{ get; set; } 
        public virtual ICollection<GoalEntity> Goals{ get; set; } 
}

public class PersonModel
{
        public int Id { get; set; } 
        public string Name { get; set; } 
        public IEnumerable<Accomplishment> Accomplishments{ get; set; } 
        public IEnumerable<Goal> Goals{ get; set; } 
}

public class PersonMapperProfile: Profile  
{  
        public PersonMapperProfile()  
        {  
                CreateMap<PersonEntity, PersonModel>()  
                .ForMember(dest => dest.Name, opt => opt.MapFrom(x => x.Name))  
                .ForMember(dest => dest.Accomplishments, opt => opt.MapFrom(x => x.Accomplishments))  
                .ForMember(dest => dest.Goals, opt => opt.MapFrom(x => x.Goals));  
        }  
}

System.Data.Entity.Core.EntityCommandExecutionException : An error occurred while executing the command definition. See the inner exception for details.
  ----> System.IndexOutOfRangeException : Index was outside the bounds of the array.
   at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
   at System.Data.Entity.Core.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext context, ObjectParameterCollection parameterValues)
   at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess)
   at System.Data.Entity.Core.Objects.ObjectQuery`1.<>c__DisplayClassb.<GetResults>b__9()
   at System.Data.Entity.Core.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
   at System.Data.Entity.Core.Objects.ObjectQuery`1.<System.Collections.Generic.IEnumerable<T>.GetEnumerator>b__0()
   at System.Lazy`1.CreateValue()
   at System.Lazy`1.LazyInitValue()
   at System.Data.Entity.Internal.LazyEnumerator`1.MoveNext()
   at System.Linq.Buffer`1..ctor(IEnumerable`1 source)
   at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
   at Crestone.ProjectCoulomb.Web.Handlers.Pqrs.GetMeasuresRequestHandler.Execute(Int32 caseId) in C:\Projects\<ProjectPath>\Handlers\Pqrs\GetMeasuresRequestHandler.cs:line 24
   at <ProjectName>.QaMeasures.QaMeasures.RegisterAndInsertIntoDb() in C:\Projects\<ProjectPath>\QaMeasures\QaMeasures.cs:line 50
--IndexOutOfRangeException
   at NMemory.Common.LinqJoinKeyHelper.CreateKeySelectors(Type outerType, Type innerType, IExpressionBuilder[] outerKeyCreator, IExpressionBuilder[] innerKeyCreator, LambdaExpression& outerKey, LambdaExpression& innerKey)
   at NMemory.Execution.Optimization.Rewriters.InnerJoinLogicalRewriter.VisitMethodCall(MethodCallExpression node)
   at System.Linq.Expressions.ExpressionVisitor.VisitArguments(IArgumentProvider nodes)
   at System.Linq.Expressions.ExpressionVisitor.VisitMethodCall(MethodCallExpression node)
   at NMemory.Execution.Optimization.Rewriters.InnerJoinLogicalRewriter.VisitMethodCall(MethodCallExpression node)
   at System.Linq.Expressions.ExpressionVisitor.VisitArguments(IArgumentProvider nodes)
   at System.Linq.Expressions.ExpressionVisitor.VisitMethodCall(MethodCallExpression node)
   at NMemory.Execution.Optimization.Rewriters.InnerJoinLogicalRewriter.VisitMethodCall(MethodCallExpression node)
   at System.Linq.Expressions.ExpressionVisitor.VisitArguments(IArgumentProvider nodes)
   at System.Linq.Expressions.ExpressionVisitor.VisitMethodCall(MethodCallExpression node)
   at NMemory.Execution.Optimization.Rewriters.InnerJoinLogicalRewriter.VisitMethodCall(MethodCallExpression node)
   at System.Linq.Expressions.ExpressionVisitor.VisitArguments(IArgumentProvider nodes)
   at System.Linq.Expressions.ExpressionVisitor.VisitMethodCall(MethodCallExpression node)
   at NMemory.Execution.Optimization.Rewriters.InnerJoinLogicalRewriter.VisitMethodCall(MethodCallExpression node)
   at System.Linq.Expressions.ExpressionVisitor.VisitArguments(IArgumentProvider nodes)
   at System.Linq.Expressions.ExpressionVisitor.VisitMethodCall(MethodCallExpression node)
   at NMemory.Execution.Optimization.Rewriters.InnerJoinLogicalRewriter.VisitMethodCall(MethodCallExpression node)
   at System.Linq.Expressions.ExpressionVisitor.VisitArguments(IArgumentProvider nodes)
   at System.Linq.Expressions.ExpressionVisitor.VisitMethodCall(MethodCallExpression node)
   at NMemory.Execution.Optimization.Rewriters.InnerJoinLogicalRewriter.VisitMethodCall(MethodCallExpression node)
   at System.Linq.Expressions.ExpressionVisitor.VisitArguments(IArgumentProvider nodes)
   at System.Linq.Expressions.ExpressionVisitor.VisitMethodCall(MethodCallExpression node)
   at NMemory.Execution.Optimization.Rewriters.InnerJoinLogicalRewriter.VisitMethodCall(MethodCallExpression node)
   at System.Linq.Expressions.ExpressionVisitor.VisitArguments(IArgumentProvider nodes)
   at System.Linq.Expressions.ExpressionVisitor.VisitMethodCall(MethodCallExpression node)
   at NMemory.Execution.Optimization.Rewriters.InnerJoinLogicalRewriter.VisitMethodCall(MethodCallExpression node)
   at System.Linq.Expressions.ExpressionVisitor.VisitArguments(IArgumentProvider nodes)
   at System.Linq.Expressions.ExpressionVisitor.VisitMethodCall(MethodCallExpression node)
   at NMemory.Execution.Optimization.Rewriters.InnerJoinLogicalRewriter.VisitMethodCall(MethodCallExpression node)
   at System.Linq.Expressions.ExpressionVisitor.VisitArguments(IArgumentProvider nodes)
   at System.Linq.Expressions.ExpressionVisitor.VisitMethodCall(MethodCallExpression node)
   at NMemory.Execution.Optimization.Rewriters.InnerJoinLogicalRewriter.VisitMethodCall(MethodCallExpression node)
   at System.Linq.Expressions.ExpressionVisitor.VisitArguments(IArgumentProvider nodes)
   at System.Linq.Expressions.ExpressionVisitor.VisitMethodCall(MethodCallExpression node)
   at NMemory.Execution.Optimization.Rewriters.InnerJoinLogicalRewriter.VisitMethodCall(MethodCallExpression node)
   at System.Linq.Expressions.ExpressionVisitor.VisitArguments(IArgumentProvider nodes)
   at System.Linq.Expressions.ExpressionVisitor.VisitMethodCall(MethodCallExpression node)
   at NMemory.Execution.Optimization.Rewriters.InnerJoinLogicalRewriter.VisitMethodCall(MethodCallExpression node)
   at NMemory.Execution.QueryCompilerBase.TransformExpression(Expression expression, ITransformationContext context, TransformationStepRecorder recorder)
   at NMemory.Execution.QueryCompilerBase.Compile[T](Expression expression)
   at NMemory.Linq.TableQuery`1.GetEnumerator(IDictionary`2 parameters, Transaction transaction)
   at NMemory.Linq.TableQueryWrapper`1.System.Collections.IEnumerable.GetEnumerator()
   at Effort.Provider.EffortDataReader..ctor(IEnumerable result, Int32 recordsAffected, FieldDescription[] fields, DbContainer container)
   at Effort.Internal.CommandActions.QueryCommandAction.ExecuteDataReader(ActionContext context)
   at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TInterceptionContext,TResult](Func`1 operation, TInterceptionContext interceptionContext, Action`1 executing, Action`1 executed)
   at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.Reader(DbCommand command, DbCommandInterceptionContext interceptionContext)
   at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)

EntityConnection connection = Effort.EntityConnectionFactory.CreateTransient(connectionString);
var dbContext = new MyDbContext(connection);
dbContext.Users.Add(new User() { UserName= "John" });
dbContext.SaveChanges();

var dbContext2 = new MyDbContext(connection);
var user = dbContext2.Users.FirstOrDefault();

user.UserName= "Mike";
dbContext2.SaveChanges();

// This fails
Assert.AreEqual(dbContext.Users.FirstOrDefault().UserName,
                                       dbContext2.Users.FirstOrDefault().UserName);

Result StackTrace:  
at Effort.DbConnectionFactory.CreateTransient()
   at Tests.MyTest..ctor() 
----- Inner Stack Trace -----
   at Effort.Provider.EffortProviderConfiguration.RegisterDbConfigurationEventHandler()
   at Effort.Provider.EffortProviderConfiguration.RegisterProvider()
   at Effort.DbConnectionFactory..cctor()
----- Inner Stack Trace -----
   at System.Data.Entity.Infrastructure.DependencyResolution.DbConfigurationManager.AddLoadedHandler(EventHandler`1 handler)
   at System.Data.Entity.DbConfiguration.add_Loaded(EventHandler`1 value)
   at Effort.Provider.EffortProviderConfiguration.RegisterDbConfigurationEventHandler()
Result Message: 
System.TypeInitializationException : The type initializer for 'Effort.DbConnectionFactory' threw an exception.
---- Effort.Exceptions.EffortException : The Effort library failed to register its provider automatically, so manual registration is required.

a) Call the Effort.Provider.EffortProviderConfiguration.RegisterProvider() method at entry point of the application

or

b) Add the following configuration to the App.config file:
   <system.data>
      <DbProviderFactories>
         <add name="Effort.Provider"
              invariant="Effort.Provider"
              description="Effort.Provider"
              type="Effort.Provider.EffortProviderFactory, Effort" />
      </DbProviderFactories>
   </system.data>


   <entityFramework>
      <providers>
         <provider invariantName="Effort.Provider"
                   type="Effort.Provider.EffortProviderServices, Effort" />
      </providers>
   </entityFramework>
-------- System.InvalidOperationException : The Entity Framework was already using a DbConfiguration instance before an attempt was made to add an 'Loaded' event handler. 'Loaded' event handlers can only be added as part of application start up before the Entity Framework is used. See http://go.microsoft.com/fwlink/?LinkId=260883 for more information.

var connection = DbConnectionFactory.CreateTransient();
var context = new Mock<PaymentTransactionsDbContext>(connection, true);

        StorageMappingItemCollection smic = new StorageMappingItemCollection(eic, sic, msl.Select(c => c.CreateReader()));

        [Test]
        public void IsUserModelPropertiesMappedCorrectly()
        { 
            var dataLoader = new CsvDataLoader(Path.Combine(AppDomain.CurrentDomain.BaseDirectory, TestDataFolderName));
            var inMemoryDbConnection = Effort.DbConnectionFactory.CreateTransient(dataLoader);

            using (var ctx = new AppDbContext(inMemoryDbConnection))
            {
                
                var firstUser = ctx.Set<User>().First(); // here I'm getting the exception  
                .................................       //  Database has not been initialized.If using CodeFirst  try to add the following line:  context.Database.CreateIfNotExists()          

            }
        }

public class AppDbContext : DbContext
    {
        public AppDbContext(DbConnection connection, IDatabaseInitializer<AppDbContext> dbInitializer = null)
            : base(connection, true)
        {
            Database.SetInitializer(dbInitializer);         
        }

        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            modelBuilder.Conventions.Remove<PluralizingTableNameConvention>();

            modelBuilder.Configurations.Add(new UserTypeConfiguration());
            modelBuilder.Configurations.Add(new RoleTypeConfiguration());
            modelBuilder.Configurations.Add(new PostTypeConfiguration());
            modelBuilder.Configurations.Add(new CommentTypeConfiguration());
            modelBuilder.Configurations.Add(new PermissionTypeConfiguration());
            modelBuilder.Configurations.Add(new RecordTypeConfiguration());
        }
    }

    [Column, DatabaseGenerated(DatabaseGeneratedOption.Computed)]
    public DateTime? LastModified { get; set; }

    var entity = new MyEntity { LastModified = DateTime.Now };
    dbContext.MyEntities.Add(entity);
    dbContext.SaveChanges();
    Assert.NotNull(entity.LastModified);

    public class ComputedColumnEventArgs : EventArgs
    {
        public Type EntityType { get; }
        public string ComputedColumnName { get; }
        public object ComputedValue { get; set; }
    }

    private void ComputeLastModified(object sender, ComputedColumnEventArgs e)
    {
        if (e.EntityType = typeof(MyEntity) 
            && e.ComputedColumnName == nameof(MyEntity.LastModified))
        {
            e.ComputedValue = _now;
        }
    }

        [Test]
        public void WillRetrieveTrackGradeIfItExists()
        {
            //Arrange
            InsertAssetCharacteristicAndValue(asset, AssetCharacteristicClassName.BRIDGE, AssetCharacteristicName.TRACK_GRADE, 11.23M);
            using (var cmd = ConnectionProviderBase.Connection.CreateCommand())
            {
                cmd.CommandText = "SELECT * FROM class";
                using (var reader = cmd.ExecuteReader())
                {
                    reader.HasRows.Should().BeTrue();
                }
            }

            //Act
            var results = Repository.FindMultipleByAsset(asset, AssetCharacteristicClassName.BRIDGE, AssetCharacteristicName.TRACK_GRADE).ToArray();

            //Assert
            results.Should().HaveCount(1);
            results[0].AssetCharacteristicName.Should().Be(AssetCharacteristicName.TRACK_GRADE.ToStorageValue<string>());
            results[0].NumericValue.Should().Be(11.23M);
        }

        private void InsertClassDefinition(string classId, string className)
        {
            using (var cmd = ConnectionProviderBase.Connection.CreateCommand())
            {
                var sql = @"INSERT INTO class ([CLASS_TYPE],[CLASS_NUM_INT],[CLASSNUM],[VALID_DATE_FROM],[VALID_DATE_TO]) VALUES('002',?,?,'1999-12-14','9999-12-31')";
                cmd.CommandText = sql;
                cmd.CommandType = CommandType.Text;
                CreateParameter(cmd, "@CLASS_NUM_INT", DbType.String, classId);
                CreateParameter(cmd, "@CLASS_NUM", DbType.String, className);

                cmd.ExecuteNonQuery();
            }
        }

        private void CreateParameter(DbCommand cmd, string parameterName, DbType dbType, object value)
        {
            IDbDataParameter parameter;

#if EFFORT 
            parameter = new EffortParameter();
#else 
            parameter = new SAParameter();
#endif
            parameter.ParameterName = parameterName;
            parameter.DbType = dbType;
            parameter.Value = value;
            cmd.Parameters.Add(parameter);
        }

 CREATE TABLE  z_script (
    script_id                       char(30)                         not null  ,
    release_id                      char(10)                         not null  ,
    description                     char(255)                        not null  ,
    script                          text                             not null  ,
    release_num                     char(7)                          not null  ,
    sequence_num                    float(16)                        not null  ,
    before_after                    char(1)                          not null  ,
    key_prefix                      varchar(10)                          null   
)

<EntityType Name="z_script">
    <Key>
        <PropertyRef Name="script_id" />
    </Key>
    <Property Name="script_id" Type="char" MaxLength="30" Nullable="false" />
    <Property Name="release_id" Type="char" MaxLength="10" Nullable="false" />
    <Property Name="description" Type="char" MaxLength="255" Nullable="false" />
    <Property Name="script" Type="text" Nullable="false" />
    <Property Name="release_num" Type="char" MaxLength="7" Nullable="false" />
    <Property Name="sequence_num" Type="float" Precision="24" Nullable="false" />
    <Property Name="before_after" Type="char" MaxLength="1" Nullable="false" />
    <Property Name="key_prefix" Type="varchar" MaxLength="10" />
</EntityType>

<EntityType Name="z_script">
    <Key>
        <PropertyRef Name="script_id" />
    </Key>
    <Property Name="script_id" Type="String" Nullable="false" MaxLength="30" FixedLength="true" Unicode="false" />
    <Property Name="release_id" Type="String" Nullable="false" MaxLength="10" FixedLength="true" Unicode="false" />
    <Property Name="description" Type="String" Nullable="false" MaxLength="255" FixedLength="true" Unicode="false" />
    <Property Name="script" Type="String" Nullable="false" MaxLength="Max" FixedLength="false" Unicode="false" />
    <Property Name="release_num" Type="String" Nullable="false" MaxLength="7" FixedLength="true" Unicode="false" />
    <Property Name="before_after" Type="String" Nullable="false" MaxLength="1" FixedLength="true" Unicode="false" />
    <Property Name="key_prefix" Type="String" MaxLength="10" FixedLength="false" Unicode="false" />
    <Property Name="sequence_num" Type="Double" Nullable="false" />
</EntityType>

<EntitySetMapping Name="z_script">
    <EntityTypeMapping TypeName="DxP.Services.CopathPlus.Data.z_script">
        <MappingFragment StoreEntitySet="z_script">
            <ScalarProperty Name="sequence_num" ColumnName="sequence_num" />
            <ScalarProperty Name="key_prefix" ColumnName="key_prefix" />
            <ScalarProperty Name="before_after" ColumnName="before_after" />
            <ScalarProperty Name="release_num" ColumnName="release_num" />
            <ScalarProperty Name="script" ColumnName="script" />
            <ScalarProperty Name="description" ColumnName="description" />
            <ScalarProperty Name="release_id" ColumnName="release_id" />
            <ScalarProperty Name="script_id" ColumnName="script_id" />
        </MappingFragment>
    </EntityTypeMapping>
</EntitySetMapping>

System.Data.MetadataException: Schema specified is not valid. Errors: 
(0,0) : error 0063: Precision facet isn't allowed for properties of type double.   
at System.Data.Metadata.Edm.StoreItemCollection.Loader.ThrowOnNonWarningErrors()   
at System.Data.Metadata.Edm.StoreItemCollection.Loader.LoadItems(IEnumerable`1 xmlReaders, IEnumerable`1 sourceFilePaths)   
at System.Data.Metadata.Edm.StoreItemCollection.Loader..ctor(IEnumerable`1 xmlReaders, IEnumerable`1 sourceFilePaths, Boolean throwOnError)   
at System.Data.Metadata.Edm.StoreItemCollection.Init(IEnumerable`1 xmlReaders, IEnumerable`1 filePaths, Boolean throwOnError, DbProviderManifest& providerManifest, DbProviderFactory& providerFactory, String& providerManifestToken, Memoizer`2& cachedCTypeFunction)   
at System.Data.Metadata.Edm.StoreItemCollection..ctor(IEnumerable`1 xmlReaders)   
at Effort.Internal.Common.MetadataWorkspaceHelper.CreateMetadataWorkspace(List`1 csdl, List`1 ssdl, List`1 msl)   
at Effort.Internal.Common.MetadataWorkspaceHelper.Rewrite(String metadata, String providerInvariantName, String providerManifestToken)   
at Effort.EntityConnectionFactory.<GetEffortCompatibleMetadataWorkspace>b__1(String metadata)   
at Effort.Internal.Caching.MetadataWorkspaceStore.<>c__DisplayClass1.<GetMetadataWorkspace>b__0()   
at System.Lazy`1.CreateValue()   at System.Lazy`1.LazyInitValue()   at System.Lazy`1.get_Value()   
at Effort.Internal.Caching.ConcurrentCache`2.Get(TKey key, Func`1 factory)   
at Effort.Internal.Caching.MetadataWorkspaceStore.GetMetadataWorkspace(String metadata, Func`2 workspaceFactoryMethod)   
at Effort.EntityConnectionFactory.GetEffortCompatibleMetadataWorkspace(String& entityConnectionString)   
at Effort.EntityConnectionFactory.CreateTransient(String entityConnectionString, IDataLoader dataLoader)   
at Effort.EntityConnectionFactory.CreateTransient(String entityConnectionString)