sqlLite数据库操作--项目中小练

 <!--客户端数据库配置-->
  <dataConfiguration defaultDatabase="SQLiteDB" />
  <connectionStrings>
    <add name="SQLiteDB" connectionString="data source=E:\Next\src\Framework\Burgeon.Next.Framework.Client\DB\CatelogDataBase.db" providerName="System.Data.SQLite" />

  </connectionStrings>

---------------SQLLite工具 建表 和导入数据-----------------

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

实例代码：

//对应的有4个 bll应用using Microsoft.Practices.EnterpriseLibrary.Data;      /// <summary>      /// 获取C店铺类目，本地sqlLite      /// </summary>      /// <returns></returns>      public static DataTable GetCatelogs()      {          DataTable catelogdt = null;          try          {              Database db = DatabaseFactory.CreateDatabase();              string sql = "select CID, PARENT_CID,IS_PARENT,STATUS,SORT_ORDER,NAME1 as NAME,OWNERID,MODIFIERID,IS_ACTIVE, TYPE,ID from tb_catelog ";              DataSet ds = db.ExecuteDataSet(CommandType.Text, sql);              if (ds != null && ds.Tables.Count > 0)              {                  catelogdt = new DataTable();                  catelogdt = ds.Tables[0];              }          }          catch (Exception ex)          {              throw ex;          }          return catelogdt;      }

对应的 bll应用

Microsoft.Practices.ServiceLocation.dll

Microsoft.Practices.Unity.dll

Microsoft.Practices.Unity.Interception.dll

Microsoft.Practices.EnterpriseLibrary.Data.dll