C# 讀取sqlite檔案

標籤：ring   pen   reader   ndt   ati   pst   exe   tar   sele   

class Program    {        static void Main(string[] args)        {            getsqliteData();        }        public static void getsqliteData()        {            SQLiteConnection cnn = new SQLiteConnection();            cnn.ConnectionString = @"Data Source=D:\test.db";            cnn.Open();            string sql = "select * from table";            SQLiteCommand cmd = cnn.CreateCommand();            cmd.CommandText = sql;            SQLiteDataReader reader = cmd.ExecuteReader();            List<ImportInfo> infoList = new List<ImportInfo>();            while (reader.Read())            {                ImportInfo info = new ImportInfo();                var tempStr = reader.GetString(4);                dynamic jsonInfos = JsonConvert.DeserializeObject(tempStr);                var episode_title = jsonInfos.episode_title.ToString();                var audio_file_name = jsonInfos.audio_file_name.ToString();                var lrc_file_name = jsonInfos.lrc_file_name.ToString();                infoList.Add(new ImportInfo() { data1 = data1, data2 = data2 });            }        }    }    public class ImportInfo    {        public string data1{ get; set; }        public string data2{ get; set; }    }

 

C# 讀取sqlite檔案