title: How do I get Effort to work with EntityFramework?
body: <p>OVERVIEW<br>
  Using Fitnesse with EF6, can't get Effort to start up.
  I've tried every trick in all the posts I can find.<br>
  All the posts say to either call 'RegisterProvider', or add a config section.  Neither is working.</p>
  
  <p>So far:<br>
  I have "Effort.Provider" in the DbProviderFactories section in machine.config.
  I have Effort.Provider showing up when I look at DbProviderFactories.GetFactoryClasses();
  ProcMon shows that it is looking  for and finding Effort.dll.</p>
  
  <p>Result:<br>
  Any of    </p>
  
  <pre><code>DbConnectionFactory.CreateTransient();   
  Effort.EntityConnectionFactory.CreateTransient(connectionString);   
  DbProviderFactory dataFactory = DbProviderFactories.GetFactory(dt.Rows[5]);   
  </code></pre>
  
  <p>throw    </p>
  
  <pre><code>Effort.Exceptions.EffortException: The Effort library failed to register
  </code></pre>
  
  <p>Also tried:<br>
  "Effort.Provider" in the entityFramework section of Runner.exe.config but couldn't get that to work. Just crashed the app.<br>
  Uninstalling EF and Effort.EF6 and re-installing. No visible effect.<br>
  Calling Effort.Provider.EffortProviderConfiguration.RegisterProvider(); from a class constructor and various startup locations.   Effort.Provider never showed up in DbProviderFactories.GetFactoryClasses();<br>
  With "Effort.Provider" in the DbProviderFactories section in app.config, it shows up in GetFactoryClasses just as well as machine.config.   </p>
  
  <p>Using:<br>
      Windows 10<br>
      .Net 4.6<br>
      VS 2016<br>
      EF 6.1.2 (although it says 6.1.3 is installed, not sure what that means)</p>
  
  <p>Do I need to register a DLL or something? Nothing in the instructions about that.   </p>
  
  <p>More Details:<br>
  App.config</p>
  
  <pre><code>&lt;configuration&gt;
      &lt;runtime&gt;
          &lt;loadFromRemoteSources enabled="true"/&gt;
      &lt;/runtime&gt;
      &lt;system.data&gt;
          &lt;DbProviderFactories&gt;
              &lt;add name="Effort.Provider" invariant="Effort.Provider" description="Effort.Provider" type="Effort.Provider.EffortProviderFactory, Effort" /&gt;
          &lt;/DbProviderFactories&gt;
      &lt;/system.data&gt;
  &lt;/configuration&gt;
  </code></pre>