EntityFramework集成Sqlite的详细步骤

public SQLiteContext(string filename)
: base(new SQLiteConnection()
{
ConnectionString =
new SQLiteConnectionStringBuilder()
{ DataSource = filename, ForeignKeys = true }
.ConnectionString
}, true)
{
}
///

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
}
public DbSet Employees { get; set; }
}
[Table("Employee")]
public class Employee
{
public int EmployeeID { get; set; }
public string FirstName { get; set; }
public string LastName { get; set; }
}
}
}

 7、测试

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
namespace ConsoleApp8
{
class Program
{
static void Main(string[] args)
{
SQLiteTest.SQLiteContext context;
context = new SQLiteTest.SQLiteContext("TestSQLite");
var empList = context.Employees.OrderBy(c => c.FirstName).ToList();
}
}
}

错误1 遇到错误如下：

System.InvalidOperationException:“No Entity Framework provider found for the ADO.NET provider with invariant name 'System.Data.SQLite'. 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.”

解决方法：

去掉app.config的如下代码：

把红线标的部分去掉，新的app.config内容如下：

"1.0" encoding="utf-8"?>