解决Sqlite“无法加载 DLL“e_sqlite3”: 找不到指定的模块”的做法实用指南-45看点

平时做技术实践时，很多问题不是概念不会，而是细节没串起来。拿“解决Sqlite“无法加载 DLL“e_sqlite3”: 找不到指定的……”来说，它看着像小点，放到项目里常会牵出环境、配置、兼容性和维护成本。下面按实际采用顺序，把思路、关键写法和容易踩坑的地方讲清楚，便于大家直接对照操作。

结合项目来看，今天在采用 NuGet 安装 System.Data.SQLite 库后，发现运行就报错：System.DllNotFoundException:“无法加载 DLL“e_sqlite3”: 找不到指定的模块。 (异常来自 HRESULT:0x8007007E)。”

从实现思路看，百度查了半天，啥都没有，我也是醉了，问AI也没问出个答案，回答全是乱七八糟的，于是我又查看了 System.Data.SQLite 的自述文件和包详细信息，是这样：

在这个场景下，啥都没写，这种库也是奇葩，我有点好奇能用在商业项目中么，一点规范都没有，有点像个人开发者的行为。

我又搜了下 e_sqlite3，不是没用就是要钱，what ??

理解这一步时，后面我又在百度找 System.Data.SQLite 官网，找到了这么一个地址

打开一看，刚好找到了答案，界面如下所示：

这里的描述文字写着：

System.Data.SQLite is available on nuget.org. Typical usage would involve adding two packages, one for System.Data.SQLite, and one containing a native built of SQLite. For example:

翻译成中文：

落到代码里，System.Data.SQLite 可在 nuget.org 上拿到。典型用法通常需添加两个 NuGet 包：一个用来 System.Data.SQLite，另一个包含 SQLite 的本机构建（比如 System.Data.SQLite.Core）。比如：

看到这里我算是知道了，还需安装另一个库：SourceGear.sqlite3

实际处理时，这下就好办了，于是我就装了 SourceGear.sqlite3 这个库，如下所示：

SourceGear.sqlite3 这个库包详细信息这里有一段描述

This package contains builds of the native SQLite code for various platforms.
These builds have "e_sqlite3" as the base name. The first three numbers in the version number of this package indicate the version of SQLite that was used to build it. The fourth number, if there is one, is incremented as needed for packaging-specific changes.

翻译成中文：

从实现思路看，此软件包包含适用来不同平台的原生 SQLite 代码构建版本。这些构建版本的基础名称均为 "e_sqlite3" 理解这一步时，。软件包版本号中的前三位数字表示构建时所采用的 SQLite 版本，若存在第四位数字，则会根据打包相关的修改需求进行递增

结合项目来看，好吧，我先搭建下 Sqlite 的环境，让 Winform 能调用 Sqlite 进行增删改查，项目我就不上传了，直接贴一个 SqliteHelper.cs 好了

using System;
using System.Data;
using System.Data.SQLite;
using System.Collections.Generic;
using System.Reflection;

public class SqliteHelper
{
    /// 
    /// 数据库连接字符串
    /// 

    public static string ConnectionString { get; set; } = "Data Source=work.db;Version=3;Pooling=True;Journal Mode=WAL;Cache=Shared;Synchronous=NORMAL;BusyTimeout=5000;";

    /// 
    /// 执行 插入、更新、删除 操作
    /// 

    /// 要执行的SQL语句（INSERT/UPDATE/DELETE）
    /// SQL参数数组，防止SQL注入
    /// p1.是否成功，p2.错误信息
    public static (bool, string) ExecuteSql(string sql, params SQLiteParameter[] parameters)
    {
        if (ConnectionString == null)
            return (false, "请先设置 ConnectionString");

        try
        {
            int line = 0;
            using (var conn = new SQLiteConnection(ConnectionString))
            {
                conn.Open();
                using (var cmd = new SQLiteCommand(sql, conn))
                {
                    if (parameters != null && parameters.Length > 0)
                        cmd.Parameters.AddRange(parameters);
                    // ExecuteNonQuery 返回受影响的行数
                    line = cmd.ExecuteNonQuery();
                }
                conn.Close();
            }
            return (true, null);
        }
        catch (Exception ex)
        {
            Console.WriteLine(ex.ToString());
            return (false, ex.Message);
        }
    }

    /// 
    /// 执行查询SQL
    /// 

    /// SQL语句
    /// SQL参数数组，防止SQL注入
    /// p1.是否成功，p2.查询的数据，p3.错误信息
    public static (bool, DataTable, string) Query(string sql, params SQLiteParameter[] parameters)
    {
        if (ConnectionString == null)
            return (false, null, "请先设置 ConnectionString");

        try
        {
            var dataTable = new DataTable();
            using (var conn = new SQLiteConnection(ConnectionString))
            {
                conn.Open();
                using (var cmd = new SQLiteCommand(sql, conn))
                {
                    if (parameters != null && parameters.Length > 0)
                        cmd.Parameters.AddRange(parameters);
                    //使用数据适配器填充 DataTable
                    using (var adapter = new SQLiteDataAdapter(cmd))
                        adapter.Fill(dataTable);
                }
                conn.Close();
            }
            return (true, dataTable, null);
        }
        catch (Exception ex)
        {
            Console.WriteLine(ex.ToString());
            return (false, null, ex.Message);
        }
    }

    /// 
    /// 执行查询SQL
    /// 

    /// 结果集列表中对象的类型，需提供无参构造函数
    /// SQL语句
    /// SQL参数数组，防止SQL注入
    /// p1.是否成功，p2.查询的数据，p3.错误信息
    public static (bool, List, string) Query(string sql, params SQLiteParameter[] parameters) where T : new()
    {
        if (ConnectionString == null)
            return (false, null, "请先设置 ConnectionString");

        List list = new List();
        try
        {
            using (var conn = new SQLiteConnection(ConnectionString))
            {
                conn.Open();
                using (var cmd = new SQLiteCommand(sql, conn))
                {
                    if (parameters != null && parameters.Length > 0)
                        cmd.Parameters.AddRange(parameters);
                    
                    using (var reader = cmd.ExecuteReader())
                    {
                        // 获取一次性获取列的元数据，用于反射匹配属性
                        var schemaTable = reader.GetSchemaTable();
                        // 建立列名到序号的映射
                        var ordinals = new Dictionary();
                        foreach (DataRow col in schemaTable.Rows)
                        {
                            string colName = col["ColumnName"].ToString();
                            ordinals[colName] = (int)col["ColumnOrdinal"];
                        }
                        // 获取泛型类型的所有可写属性
                        Type objType = typeof(T);
                        PropertyInfo[] properties = objType.GetProperties();
                        while (reader.Read())
                        {
                            T obj = new T();
                            foreach (PropertyInfo prop in properties)
                            {
                                if (!prop.CanWrite) continue;
                                if (ordinals.ContainsKey(prop.Name))
                                {
                                    object value = reader.GetValue(ordinals[prop.Name]);
                                    if (value != DBNull.Value)
                                    {
                                        // 转换为属性的实际类型后赋值
                                        Type targetType = Nullable.GetUnderlyingType(prop.PropertyType) ?? prop.PropertyType;
                                        object safeValue = Convert.ChangeType(value, targetType);
                                        prop.SetValue(obj, safeValue);
                                    }
                                }
                            }
                            list.Add(obj);
                        }
                        reader.Close();
                    }
                }
                conn.Close();
            }
            return (true, list, null);
        }
        catch (Exception ex)
        {
            Console.WriteLine(ex.ToString());
            return (false, null, ex.Message);
        }
    }
}