System.Data.SQLite

<strong>
Hi.<br/>
I am a freelancer (ASP.NET Developer) and recently, I have installed SQLite 3.8.6 (x86/x64) for research purposes.<br/>
I use Microsoft Visual Studio 2013 Ultimate + Update 3.<br/>
When I try to generate SQL code from EDMX model, after setting up the connection, generating wizard shows me this error:
</strong>
<br/>
<pre>
----------
...
Running transformation: System.InvalidOperationException: 
The SSDL generated by the activity called 'CsdlToSsdlAndMslActivity' is not valid and has the following errors: 
No Entity Framework provider found for the ADO.NET provider with invariant name 'System.Data.SQLite.EF6'. 
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.
...
----------
</pre>
<br/>
<strong>
My App.config file content _that configured by <em>Nuget Package Manager</em>_ is:
</strong>
<br/>
<pre>
----------
&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;
&lt;configuration&gt;
  &lt;configSections&gt;
    &lt;!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 --&gt;
    &lt;section name=&quot;entityFramework&quot; type=&quot;System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089&quot; requirePermission=&quot;false&quot; /&gt;
  &lt;/configSections&gt;
  &lt;system.data&gt;
    &lt;!--
        NOTE: The extra &quot;remove&quot; element below is to prevent the design-time
              support components within EF6 from selecting the legacy ADO.NET
              provider for SQLite (i.e. the one without any EF6 support).  It
              appears to only consider the first ADO.NET provider in the list
              within the resulting &quot;app.config&quot; or &quot;web.config&quot; file.
    --&gt;
    &lt;DbProviderFactories&gt;
      &lt;add name=&quot;SQLite Data Provider&quot; invariant=&quot;System.Data.SQLite&quot; description=&quot;.NET Framework Data Provider for SQLite&quot; type=&quot;System.Data.SQLite.SQLiteFactory, System.Data.SQLite&quot; /&gt;
      &lt;remove invariant=&quot;System.Data.SQLite&quot; /&gt;
      &lt;remove invariant=&quot;System.Data.SQLite.EF6&quot; /&gt;
      &lt;add name=&quot;SQLite Data Provider (Entity Framework 6)&quot; invariant=&quot;System.Data.SQLite.EF6&quot; description=&quot;.NET Framework Data Provider for SQLite (Entity Framework 6)&quot; type=&quot;System.Data.SQLite.EF6.SQLiteProviderFactory, System.Data.SQLite.EF6&quot; /&gt;
    &lt;/DbProviderFactories&gt;
  &lt;/system.data&gt;
  &lt;entityFramework&gt;
    &lt;defaultConnectionFactory type=&quot;System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework&quot; /&gt;
    &lt;providers&gt;
      &lt;provider invariantName=&quot;System.Data.SqlClient&quot; type=&quot;System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer&quot; /&gt;
      &lt;provider invariantName=&quot;System.Data.SQLite.EF6&quot; type=&quot;System.Data.SQLite.EF6.SQLiteProviderServices, System.Data.SQLite.EF6&quot; /&gt;
    &lt;/providers&gt;
  &lt;/entityFramework&gt;
&lt;/configuration&gt;
----------
</pre>
<strong>
Please tell me:<br/>
1- Does SQLite EF6 Provider support Model-First approach? (If Yes, What should I do to resolve this situation?)<br/>
2- Are you sure about <em>internal</em> accessibility of <em>System.Data.SQLite.EF6.SQLiteProviderServices</em>?<br/>
<br/>
Thanks to your consideration.
</strong>

Answers to your questions:

1. I think it should.
2. Yes.

Please try removing the following line from your "app.config" file:

<add name="SQLite Data Provider" invariant="System.Data.SQLite" description=".NET Framework Data Provider for SQLite" type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite" />

<strong>
I have tried your solution, but the error still exists.(attachment: error.gif)<br/>
I think default [SSDT to SQL T4 Template] is not compatible to SQLite.<br/>
Is there any official [SSDT to SQLite T4 Template] that does sql code generation?
</strong>

If it requires a special template, then System.Data.SQLite does not currently
support this scenario.

Changing to feature request.

Any update on this?  I'm also seeing this error.