Ticket Hash: | 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: (text/x-fossil-plain) Which release packages are you using? Did you install the design-time components for Visual Studio 2015? |