SQLite操作类C#

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Configuration;
using System.Data.Common;
using System.Data.SQLite;
using System.IO;
using System.Windows.Forms;

namespace Common.Tools
{
    /// 
 
    /// 说明：这是一个针对System.Data.SQLite的数据库常规操作封装的通用类。 
    /// huangjie add 2014-10-31
    /// 
    
    public class SQLiteDBHelper
    {
        private string dbPath = Application.StartupPath + “\\Database.db3“;
        private string connectionString = string.Empty;

        #region 数据库连接必要条件参数

        private SQLiteConnection dbConnection = null;
        /// 

        /// 数据库连接
        /// 

        public SQLiteConnection DbConnection
        {
            get
            {
                if （this.dbConnection == null）
                {
                    // 若没打开，就变成自动打开关闭的
                    this.Open（）;
                    this.AutoOpenClose = true;
                }
                return this.dbConnection;
            }
            set
            {
                this.dbConnection = value;
            }
        }
        private SQLiteCommand dbCommand = null;
        /// 

        /// 命令
        /// 

        public SQLiteCommand DbCommand
        {
            get
            {
                return this.dbCommand;
            }
            set
            {
                this.dbCommand = value;
            }
        }
        private SQLiteDataAdapter dbDataAdapter = null;
        /// 

        /// 数据库适配器
        /// 

        public SQLiteDataAdapter DbDataAdapter
        {
            get
            {
                return this.dbDataAdapter;
            }
            set
            {
                this.dbDataAdapter = value;
            }
        }

        /// 

        /// 数据库连接
        /// 

        public string ConnectionString
        {
            get
            {
                return this.connectionString;
            }
            set
            {
                this.connectionString = value;
            }
        }

        private SQLiteTransaction dbTransaction = null;
        private bool inTransaction = false;
        /// 

        /// 是否已采用事务
        /// 

        public bool InTransaction
        {
            get
            {
                return this.inTransaction;
            }
            set
            {
                this.inTransaction = value;
            }
        }
        private bool autoOpenClose = false;
        /// 

        /// 默认打开关闭数据库选项（默认为否）
        /// 

        public bool AutoOpenClose
        {
            get
            {
                return autoOpenClose;
            }
            set
            {
                autoOpenClose = value;
            }
        }

        #endregion