System.Data.SQLite
View Ticket
Not logged in
Ticket UUID: c957cf767ab496b4e95071131b6d030848b45bfb
Title: Generate DB from model error
Status: Closed Type: Incident
Severity: Important Priority: Medium
Subsystem: VsDesignerInstaller Resolution: Need_More_Info
Last Modified: 2016-10-31 01:39:10
Version Found In: 1.0.102.0
User Comments:
anonymous added on 2016-09-15 13:36:31:
I am switch from using SQL Server to SQLite for the first time. I just installed Visual Studio 2015 Enterprise. As a trial, I created a simple wpf application with nothing in it but a new ADO.NET Entity Data Model. I added one table to the model. When I try to generate the database from the model, System.Data.SQLite Database File is available and chosen as the Data Source. But when I try to generate the SQL script I get the error:

Encountered the following errors while processing the template 
'C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\Extensions\Microsoft\Entity Framework Tools\DBGen\SSDLToSQL10.tt:
Line 56, Column 0: '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. 

Here is my Config file

<entityFramework>
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework">
      <parameters>
        <parameter value="v13.0" />
      </parameters>
    </defaultConnectionFactory>
    <providers>
      <provider invariantName="System.Data.SQLite.EF6" type="System.Data.SQLite.EF6.SQLiteProviderServices, System.Data.SQLite.EF6" />
      <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
    </providers>
  </entityFramework>
  <system.data>
    <DbProviderFactories>
      <remove invariant="System.Data.SQLite.EF6" />
      <add name="SQLite Data Provider (Entity Framework 6)" invariant="System.Data.SQLite.EF6" description=".NET Framework Data Provider for SQLite (Entity Framework 6)" type="System.Data.SQLite.EF6.SQLiteProviderFactory, System.Data.SQLite.EF6" />
      <remove invariant="System.Data.SQLite" />
      <add name="SQLite Data Provider" invariant="System.Data.SQLite" description=".NET Framework Data Provider for SQLite" type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite" />
    </DbProviderFactories>
  </system.data>

Any ideas?

mistachkin added on 2016-09-15 19:47:27:
Which release packages are you using?  Did you install the design-time components
for Visual Studio 2015?