SQLite操作封装，包括获取表格，查询、更新、插入等操作（SQLite.NET）

获取表中的数据

using System;
using System.Collections.Generic;
using System.Text;

namespace SQLiteHelperTestApp
{
    class config
    {
        public static string DatabaseFile = ““;
        public static string DataSource
        {
            get
            {
                return string.Format（“data source={0}“ DatabaseFile）;
            }
        }
    }
}

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----
     目录           0  2018-09-16 23:28  SQLiteHelper.net-master\
     文件           8  2018-09-16 23:28  SQLiteHelper.net-master\.gitignore
     文件        8600  2018-09-16 23:28  SQLiteHelper.net-master\README.md
     目录           0  2019-11-06 14:50  SQLiteHelper.net-master\source code\
     目录           0  2019-11-06 14:48  SQLiteHelper.net-master\source code\.vs\
     目录           0  2019-11-06 14:48  SQLiteHelper.net-master\source code\.vs\SQLiteHelperTestApp\
     目录           0  2019-11-06 14:48  SQLiteHelper.net-master\source code\.vs\SQLiteHelperTestApp\v16\
     文件      122368  2019-11-06 18:28  SQLiteHelper.net-master\source code\.vs\SQLiteHelperTestApp\v16\.suo
     目录           0  2019-11-06 14:48  SQLiteHelper.net-master\source code\.vs\SQLiteHelperTestApp\v16\Server\
     目录           0  2019-11-06 17:19  SQLiteHelper.net-master\source code\.vs\SQLiteHelperTestApp\v16\Server\sqlite3\
     文件           0  2019-11-06 14:48  SQLiteHelper.net-master\source code\.vs\SQLiteHelperTestApp\v16\Server\sqlite3\db.lock
     文件      765952  2019-11-06 14:51  SQLiteHelper.net-master\source code\.vs\SQLiteHelperTestApp\v16\Server\sqlite3\storage.ide
     文件       32768  2019-11-06 17:19  SQLiteHelper.net-master\source code\.vs\SQLiteHelperTestApp\v16\Server\sqlite3\storage.ide-shm
     文件           0  2019-11-06 17:19  SQLiteHelper.net-master\source code\.vs\SQLiteHelperTestApp\v16\Server\sqlite3\storage.ide-wal
     文件        1530  2019-11-06 14:50  SQLiteHelper.net-master\source code\app.config
     目录           0  2019-11-06 14:50  SQLiteHelper.net-master\source code\bin\
     目录           0  2019-11-06 14:50  SQLiteHelper.net-master\source code\bin\Release\
     文件     4988280  2019-09-14 17:01  SQLiteHelper.net-master\source code\bin\Release\Entityframework.dll
     文件      591736  2019-09-14 17:01  SQLiteHelper.net-master\source code\bin\Release\Entityframework.SqlServer.dll
     文件      163193  2019-09-14 17:01  SQLiteHelper.net-master\source code\bin\Release\Entityframework.SqlServer.xml
     文件     3737307  2019-09-14 17:01  SQLiteHelper.net-master\source code\bin\Release\Entityframework.xml
     文件       74240  2019-11-06 14:50  SQLiteHelper.net-master\source code\bin\Release\SQLiteHelperTestApp.exe
     文件        1530  2019-11-06 14:50  SQLiteHelper.net-master\source code\bin\Release\SQLiteHelperTestApp.exe.config
     文件      169472  2019-11-06 14:50  SQLiteHelper.net-master\source code\bin\Release\SQLiteHelperTestApp.pdb
     文件      355328  2019-10-27 06:40  SQLiteHelper.net-master\source code\bin\Release\System.Data.SQLite.dll
     文件         736  2018-08-13 21:49  SQLiteHelper.net-master\source code\bin\Release\System.Data.SQLite.dll.config
     文件      184832  2019-10-27 06:41  SQLiteHelper.net-master\source code\bin\Release\System.Data.SQLite.EF6.dll
     文件      184832  2019-10-27 06:41  SQLiteHelper.net-master\source code\bin\Release\System.Data.SQLite.Linq.dll
     文件     1099530  2019-10-27 06:40  SQLiteHelper.net-master\source code\bin\Release\System.Data.SQLite.xml
     目录           0  2019-11-06 14:50  SQLiteHelper.net-master\source code\bin\Release\x64\
     文件     1631744  2019-10-27 06:41  SQLiteHelper.net-master\source code\bin\Release\x64\SQLite.Interop.dll
............此处省略120个文件信息