title: Effort issue when testing
body: <p>I have been reading on using Effort for unit testing due to how "easy" it is to setup a database in memory. I have been trying to implement this in my test data service but I keep running into issues. 
  I am using Entity Framework 6 and models that were generated from existing tables.</p>
  
  <p><strong>Context Model</strong></p>
  
  <pre><code>public partial class Entities : DbContext
  {
      public Entities()
          : base("name=Entities")
      {
      }
  
      //Overloading for effort unit test
      public Entities(DbConnection connection) : base(connection,true)
      {
  
      }
  
      protected override void OnModelCreating(DbModelBuilder modelBuilder)
      {
          //throw new UnintentionalCodeFirstException();
      }
  
      public virtual DbSet&lt;REPAIR_CHECK_IN_TABLE&gt; REPAIR_CHECK_IN_TABLEs { get; set; }
      public virtual DbSet&lt;tblPlanarWarranty&gt; tblPlanarWarranties { get; set; }
  }
  </code></pre>
  
  <p><strong>Test DataService</strong></p>
  
  <pre><code>private IDataLoader loader;
      private Entities context;
  
  
      public TestDataService()
      {
  
          loader = new Effort.DataLoaders.CsvDataLoader(@"_TestDataFiles\");
          context = new Entities(Effort.DbConnectionFactory.CreateTransient(loader));
      }
  </code></pre>
  
  <p>Initially I would get the following error.</p>
  
  <blockquote>
    <p>No entity Framework provider for the ADO.NET provider withe invariant name 'Effort.Provider'</p>
  </blockquote>
  
  <p>I then added said provider to my provider section of the app config file and started receiving this error.</p>
  
  <blockquote>
    <p>The 'Instance' member of the entity Framework provider type 'Effort.ProviderServices,Effort,Version-1.0.0.0 didt not return an object that inherits from 'System.Data.Entity.Core.Common.DBProviderServices'</p>
  </blockquote>
  
  <p>Does anyone have some insight as to what I am doing wrong? On the site it was as easy as a few lines but this has turned into a huge mess.</p>