SQLiteSample

Prerequisites

Setup

Errors

Config related errors

 <?xml version="1.0" encoding="utf-8"?>
 <configuration>
 <entityFramework>
 <defaultConnectionFactory type="System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework">
 <parameters>
 <parameter value="mssqllocaldb" />
 </parameters>
 </defaultConnectionFactory>
 <providers>
 <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
 <provider invariantName="System.Data.SQLite.EF6" type="System.Data.SQLite.EF6.SQLiteProviderServices, System.Data.SQLite.EF6" />
 <provider invariantName="System.Data.SQLite" type="System.Data.SQLite.EF6.SQLiteProviderServices, System.Data.SQLite.EF6" />
 </providers>
 </entityFramework>
 <system.data>
 <!--
 NOTE: The extra "remove" 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 "app.config" or "web.config" file.
 -->
 <DbProviderFactories>
 <remove invariant="System.Data.SQLite" />
 <remove invariant="System.Data.SQLite.EF6" />
 <add name="SQLite Data Provider" invariant="System.Data.SQLite" description=".NET Framework Data Provider for SQLite" type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite" />
 <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" />
 </DbProviderFactories>
 </system.data>
 </configuration>

Reference to complex property in entity class requires specifying the property that references the complex property

SQL logic error or missing database
no such column: Extent1.Artist_ArtistId
namespace SQLiteSample.Entities
{
 public class Album
 {
 public long AlbumId { get; set; }
 public string Title { get; set; }
 public long ArtistId { get; set; } // Required for sqlite to properly reference Artist
 public virtual Artist Artist { get; set; }
 }
}

Caveats

References