namespace ConsoleApplication2
{
    using System.Data.SQLite;
    using System.Data;
    using System;
    internal class Program
    {
        public static void Main(string[] args)
        {
            //Open DB
            SQLiteConnection conn = new SQLiteConnection(
                "Data Source=/Users/renurt/Desktop/log05.sq3; Version=3;");
            conn.Open();

            //GET ONE VALUE
            SQLiteCommand cmd = conn.CreateCommand();
            cmd.CommandText = "SELECT activity FROM Events WHERE id = @param1";
            cmd.Parameters.Add(new SQLiteParameter("@param1", 98));
            var value = cmd.ExecuteScalar();
            Console.WriteLine(value);

            //GET PLENTY VALUES
            DataSet data = new DataSet();
            data.Reset();
            cmd.CommandText = "SELECT * FROM Events WHERE id < 98;";
            SQLiteDataAdapter ad = new SQLiteDataAdapter(cmd);
            ad.Fill(data);
            //PRINTING DATASET
            foreach (DataTable ds in data.Tables)
            {
                for (int row = 0; row < ds.Rows.Count; row++)
                {
                    for (int col = 0; col < ds.Columns.Count; col++)
                    {
                        Console.Write(ds.Rows[row][col].GetType().Name + "\t");
                    }

                    Console.WriteLine();
                }
            }

            //CLOSE DB
            conn.Close();
        }
    }
}