EntityFramework集成Sqlite的详细步骤

1、建解决方案（本示使用的是 framework4.0）如图：

　　

2、添加 System.Data.SQLite引用 如图：

　　

3、制作sqlite数据库文件

　　使用的是navcat 建立一张Employee表

4、把新建的数据库文件起名为：TestSQLite

　　然后拷贝到程序的bin/Debug里，如图：

　

5、配置链接字符串

  <connectionStrings>    <add name="SQLiteContext" connectionString="Data Source=.TestSQLite" providerName="System.Data.SQLite.EF6" />  </connectionStrings>

6、建立上下文

using System;using System.Collections.Generic;using System.ComponentModel.DataAnnotations.Schema;using System.Data.Entity;using System.Data.SQLite;using System.Linq;using System.Text;namespace ConsoleApp8{    public class SQLiteTest    {        /// <summary>        /// 此属性用于指定配置类        /// </summary>        //[DbConfigurationType(typeof(MyConfiguration))]        public class SQLiteContext : DbContext        {            /// <summary>            /// 指定连接字符串            /// </summary>            /// <param name="filename"></param>            public SQLiteContext(string filename)                : base(new SQLiteConnection()                {                    ConnectionString =                        new SQLiteConnectionStringBuilder()                        { DataSource = filename, ForeignKeys = true }                        .ConnectionString                }, true)            {            }            /// <summary>            /// 生成数据库用，不需要生成的话可以注释掉            /// </summary>            /// <param name="modelBuilder"></param>            protected override void OnModelCreating(DbModelBuilder modelBuilder)            {            }            public DbSet<Employee> 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内容如下：

<?xml version="1.0" encoding="utf-8"?><configuration>  <configSections>    <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />  </configSections>  <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" />    </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" />    </DbProviderFactories>  </system.data></configuration>

错误2 如果遇到找不着“SQLite.Interop.dll” 的错误

解决方法：

去当前解决方法的nugit包里的路径里复制出来这两个文件夹，拷贝到 bin/debug里，如图：

完成