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) { } }
/// <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) { } }