コード例 #1
0
 public void QueryCityDataByExt()
 {
     try
     {
         GetCityDatas();
         ConfigurationItems cfg = new ConfigurationItems();
         DBReporistory <Domain.CommonData.CategoryData> cds = new DBReporistory <CategoryData>("TecentDASQLite");//提供配置的节点名,不能直接使用配置的连接串内容
         List <Domain.CommonData.CategoryData>          ds  = cds.DoQuery <Domain.CommonData.CategoryData>().ToList();
     }
     catch (Exception ex)
     {
     }
 }
コード例 #2
0
 /// <summary>
 /// 使用System.Data.SQLite 访问sqlite数据库
 /// </summary>
 public void GetCityDatas()
 {
     try
     {
         ConfigurationItems cfg  = new ConfigurationItems();
         SQLiteConnection   conn = new SQLiteConnection(cfg.SqliteDbConnString);
         conn.Open();
         string            sql  = "select * from CategoryData";
         SQLiteCommand     comq = new SQLiteCommand(sql, conn);
         SQLiteDataAdapter dap  = new SQLiteDataAdapter();
         dap.SelectCommand = comq;
         DataSet ds = new DataSet();
         dap.Fill(ds);
         conn.Clone();
     }
     catch (Exception ex)
     {
     }
 }