C#使用ado.net技术操作sqlite

1. 安装Nget包 Microsoft.Data.Sqlite 6.0.0.1
2. 把下面通用类复制到程序中

using Microsoft.Data.Sqlite;
using System;
using System.Collections.Concurrent;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading;
using System.Threading.Tasks;
using System.Reflection;
using System.Data;

namespace Common_ClassLibrary
{
   
    public class Sqlite64Helper : IDisposable
    {
   
        /// <summary>
        /// 连接字符串
        /// </summary>
        public string ConStr {
    get; private set; }

        /// <summary>
        /// 连接数据库对象池
        /// </summary>
        private Queue<SqliteConnection> ConQueue;

        /// <summary>
        /// 执行对象池
        /// </summary>
        private Queue<SqliteCommand> ComQueue;

        /// <summary>
        /// 线程互斥对象
        /// </summary>
        public Mutex CurMutex {
    get; set; }

        /// <summary>
        /// 实体类中属性的字典
        /// </summary>
        private ConcurrentDictionary<Type, List<PropertyInfo>> EntityPropDic;

        public Sqlite64Helper(string dataBaseLinkStr)
        {
   
            try
            {
   
                ConStr = dataBaseLinkStr;
                ConQueue = new Queue<SqliteConnection>();
                ComQueue = new Queue<SqliteCommand>();
                EntityPropDic = new ConcurrentDictionary<Type, List<PropertyInfo>>();
                CurMutex = new Mutex();
                EnConnectionQueue(CreateCon());
            }
            catch (Exception ex)
            {
   
                throw ex;
            }
        }

        private SqliteConnection CreateCon()
        {
   
            SqliteConnection con = new SqliteConnection(ConStr);
            return con;
        }

        private void EnConnectionQueue(SqliteConnection con)