System.Data.SQLite
Check-in [573499eaf2]
Not logged in

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Configuration file cleanup: omit the 'remove' element for the legacy 'System.Data.SQLite' provider from the LINQ-specific and EF6-specific configuration files.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 573499eaf2a98de7f1473c9008db6bab149fbde3
User & Date: mistachkin 2015-01-07 01:11:37
References
2015-01-07
04:20 Ticket [2be4298631] EF6 Provider not working (VS 2012) status still Pending with 3 other changes artifact: d767b41e31 user: mistachkin
Context
2015-01-13
03:30
Remove a comment that is no longer accurate. check-in: 812281ccef user: mistachkin tags: trunk
2015-01-08
04:55
Work in progress for ticket [8d928c3e88]. These changes are not yet fully tested. check-in: 0b6d0e63ca user: mistachkin tags: tkt-8d928c3e88
2015-01-07
01:11
Configuration file cleanup: omit the 'remove' element for the legacy 'System.Data.SQLite' provider from the LINQ-specific and EF6-specific configuration files. check-in: 573499eaf2 user: mistachkin tags: trunk
2014-12-16
19:00
Fix missing 'and'. check-in: d4cb6858ed user: mistachkin tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to NuGet/net40/EF6/content/config.transform.

     4      4           NOTE: The extra "remove" element below is to prevent the design-time
     5      5                 support components within EF6 from selecting the legacy ADO.NET
     6      6                 provider for SQLite (i.e. the one without any EF6 support).  It
     7      7                 appears to only consider the first ADO.NET provider in the list
     8      8                 within the resulting "app.config" or "web.config" file.
     9      9       -->
    10     10       <DbProviderFactories>
    11         -      <remove invariant="System.Data.SQLite" />
    12     11         <remove invariant="System.Data.SQLite.EF6" />
    13     12         <add name="SQLite Data Provider (Entity Framework 6)"
    14     13              invariant="System.Data.SQLite.EF6"
    15     14              description=".NET Framework Data Provider for SQLite (Entity Framework 6)"
    16     15              type="System.Data.SQLite.EF6.SQLiteProviderFactory, System.Data.SQLite.EF6" />
    17     16       </DbProviderFactories>
    18     17     </system.data>
    19     18   </configuration>

Changes to testlinq/2008/LINQ/App.config.

     1      1   <?xml version="1.0"?>
     2      2   <configuration>
     3      3     <system.data>
     4      4       <DbProviderFactories>
     5         -      <remove invariant="System.Data.SQLite" />
     6      5         <remove invariant="System.Data.SQLite.Linq" />
     7      6         <add name="SQLite Data Provider (LINQ)" invariant="System.Data.SQLite.Linq" description=".NET Framework Data Provider for SQLite (LINQ)" type="System.Data.SQLite.Linq.SQLiteProviderFactory, System.Data.SQLite.Linq, Version=1.0.95.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" />
     8      7       </DbProviderFactories>
     9      8     </system.data>
    10      9     <connectionStrings>
    11     10       <add name="northwindEFEntities" connectionString="metadata=res://*/NorthwindModel.Linq.2008.csdl|res://*/NorthwindModel.Linq.2008.ssdl|res://*/NorthwindModel.Linq.2008.msl;provider=System.Data.SQLite.Linq;provider connection string=&quot;data source=.\northwindEF.db&quot;" providerName="System.Data.EntityClient" />
    12     11     </connectionStrings>
    13     12   </configuration>

Changes to testlinq/2010/EF6/App.config.

     1      1   <?xml version="1.0"?>
     2      2   <configuration>
     3      3     <configSections>
     4      4       <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
     5      5     </configSections>
     6      6     <system.data>
     7      7       <DbProviderFactories>
     8         -      <remove invariant="System.Data.SQLite" />
     9      8         <remove invariant="System.Data.SQLite.EF6" />
    10      9         <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, Version=1.0.95.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" />
    11     10       </DbProviderFactories>
    12     11     </system.data>
    13     12     <connectionStrings>
    14     13       <add name="northwindEFEntities" connectionString="metadata=res://*/NorthwindModel.EF6.2010.csdl|res://*/NorthwindModel.EF6.2010.ssdl|res://*/NorthwindModel.EF6.2010.msl;provider=System.Data.SQLite.EF6;provider connection string=&quot;data source=.\northwindEF.db&quot;" providerName="System.Data.EntityClient" />
    15     14     </connectionStrings>
    16     15     <entityFramework>
    17     16       <providers>
    18     17         <provider invariantName="System.Data.SQLite.EF6" type="System.Data.SQLite.EF6.SQLiteProviderServices, System.Data.SQLite.EF6, Version=1.0.95.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" />
    19     18       </providers>
    20     19     </entityFramework>
    21     20   </configuration>

Changes to testlinq/2010/LINQ/App.config.

     1      1   <?xml version="1.0"?>
     2      2   <configuration>
     3      3     <system.data>
     4      4       <DbProviderFactories>
     5         -      <remove invariant="System.Data.SQLite" />
     6      5         <remove invariant="System.Data.SQLite.Linq" />
     7      6         <add name="SQLite Data Provider (LINQ)" invariant="System.Data.SQLite.Linq" description=".NET Framework Data Provider for SQLite (LINQ)" type="System.Data.SQLite.Linq.SQLiteProviderFactory, System.Data.SQLite.Linq, Version=1.0.95.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" />
     8      7       </DbProviderFactories>
     9      8     </system.data>
    10      9     <connectionStrings>
    11     10       <add name="northwindEFEntities" connectionString="metadata=res://*/NorthwindModel.Linq.2010.csdl|res://*/NorthwindModel.Linq.2010.ssdl|res://*/NorthwindModel.Linq.2010.msl;provider=System.Data.SQLite.Linq;provider connection string=&quot;data source=.\northwindEF.db&quot;" providerName="System.Data.EntityClient" />
    12     11     </connectionStrings>
    13     12   </configuration>

Changes to testlinq/2012/EF6/App.config.

     1      1   <?xml version="1.0"?>
     2      2   <configuration>
     3      3     <configSections>
     4      4       <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
     5      5     </configSections>
     6      6     <system.data>
     7      7       <DbProviderFactories>
     8         -      <remove invariant="System.Data.SQLite" />
     9      8         <remove invariant="System.Data.SQLite.EF6" />
    10      9         <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, Version=1.0.95.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" />
    11     10       </DbProviderFactories>
    12     11     </system.data>
    13     12     <connectionStrings>
    14     13       <add name="northwindEFEntities" connectionString="metadata=res://*/NorthwindModel.EF6.2012.csdl|res://*/NorthwindModel.EF6.2012.ssdl|res://*/NorthwindModel.EF6.2012.msl;provider=System.Data.SQLite.EF6;provider connection string=&quot;data source=.\northwindEF.db&quot;" providerName="System.Data.EntityClient" />
    15     14     </connectionStrings>
    16     15     <entityFramework>
    17     16       <providers>
    18     17         <provider invariantName="System.Data.SQLite.EF6" type="System.Data.SQLite.EF6.SQLiteProviderServices, System.Data.SQLite.EF6, Version=1.0.95.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" />
    19     18       </providers>
    20     19     </entityFramework>
    21     20   </configuration>

Changes to testlinq/2012/LINQ/App.config.

     1      1   <?xml version="1.0"?>
     2      2   <configuration>
     3      3     <system.data>
     4      4       <DbProviderFactories>
     5         -      <remove invariant="System.Data.SQLite" />
     6      5         <remove invariant="System.Data.SQLite.Linq" />
     7      6         <add name="SQLite Data Provider (LINQ)" invariant="System.Data.SQLite.Linq" description=".NET Framework Data Provider for SQLite (LINQ)" type="System.Data.SQLite.Linq.SQLiteProviderFactory, System.Data.SQLite.Linq, Version=1.0.95.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" />
     8      7       </DbProviderFactories>
     9      8     </system.data>
    10      9     <connectionStrings>
    11     10       <add name="northwindEFEntities" connectionString="metadata=res://*/NorthwindModel.Linq.2012.csdl|res://*/NorthwindModel.Linq.2012.ssdl|res://*/NorthwindModel.Linq.2012.msl;provider=System.Data.SQLite.Linq;provider connection string=&quot;data source=.\northwindEF.db&quot;" providerName="System.Data.EntityClient" />
    12     11     </connectionStrings>
    13     12   </configuration>

Changes to testlinq/2013/EF6/App.config.

     1      1   <?xml version="1.0"?>
     2      2   <configuration>
     3      3     <configSections>
     4      4       <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
     5      5     </configSections>
     6      6     <system.data>
     7      7       <DbProviderFactories>
     8         -      <remove invariant="System.Data.SQLite" />
     9      8         <remove invariant="System.Data.SQLite.EF6" />
    10      9         <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, Version=1.0.95.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" />
    11     10       </DbProviderFactories>
    12     11     </system.data>
    13     12     <connectionStrings>
    14     13       <add name="northwindEFEntities" connectionString="metadata=res://*/NorthwindModel.EF6.2013.csdl|res://*/NorthwindModel.EF6.2013.ssdl|res://*/NorthwindModel.EF6.2013.msl;provider=System.Data.SQLite.EF6;provider connection string=&quot;data source=.\northwindEF.db&quot;" providerName="System.Data.EntityClient" />
    15     14     </connectionStrings>
    16     15     <entityFramework>
    17     16       <providers>
    18     17         <provider invariantName="System.Data.SQLite.EF6" type="System.Data.SQLite.EF6.SQLiteProviderServices, System.Data.SQLite.EF6, Version=1.0.95.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" />
    19     18       </providers>
    20     19     </entityFramework>
    21     20   </configuration>

Changes to testlinq/2013/LINQ/App.config.

     1      1   <?xml version="1.0"?>
     2      2   <configuration>
     3      3     <system.data>
     4      4       <DbProviderFactories>
     5         -      <remove invariant="System.Data.SQLite" />
     6      5         <remove invariant="System.Data.SQLite.Linq" />
     7      6         <add name="SQLite Data Provider (LINQ)" invariant="System.Data.SQLite.Linq" description=".NET Framework Data Provider for SQLite (LINQ)" type="System.Data.SQLite.Linq.SQLiteProviderFactory, System.Data.SQLite.Linq, Version=1.0.95.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" />
     8      7       </DbProviderFactories>
     9      8     </system.data>
    10      9     <connectionStrings>
    11     10       <add name="northwindEFEntities" connectionString="metadata=res://*/NorthwindModel.Linq.2013.csdl|res://*/NorthwindModel.Linq.2013.ssdl|res://*/NorthwindModel.Linq.2013.msl;provider=System.Data.SQLite.Linq;provider connection string=&quot;data source=.\northwindEF.db&quot;" providerName="System.Data.EntityClient" />
    12     11     </connectionStrings>
    13     12   </configuration>