SQLiteHelper封装辅助类

 <connectionStrings>
    <add name="SQLiteConnectionString" connectionString="Data Source=test.db;version=3;" />
  </connectionStrings>

using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.Entity.Infrastructure;
using System.Data.SqlClient;
using System.Data.SQLite;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace SQLiteHelper
{
   
    public static class SQLiteHelper
    {
   
        //设置连接字符串
        private static readonly string connectionString = ConfigurationManager.ConnectionStrings["SQLiteConnectionString"].ConnectionString;
        //封装executeNonQuery

        /// <summary>
        /// 执行增删改的语句
        /// </summary>
        /// <param name="sql">sql语句</param>
        /// <param name="pms">参数</param>