DbProviderFactory fact = DbProviderFactories.GetFactory("System.Data.SQLite");
  using (SQLiteConnection cnn = (SQLiteConnection)fact.CreateConnection())
  {
    cnn.ConnectionString = "Data Source=trace.db";
    cnn.Open();
    if (Settings.tblFill){
      DataSet ds = new DataSet();
  //     
      SQLiteDataAdapter da = new SQLiteDataAdapter( "select * from version", cnn);
     // SQLiteDataAdapter da1 = new SQLiteDataAdapter(  cnn);
      da.Fill(ds, "select");
      PrintTable(ds, "select",  true);
      ds.Dispose();
    }
    else {
     SQLiteCommand cmd = new SQLiteCommand (cnn);
     cmd.CommandText = "select * from version";
                                                                

     SQLiteDataReader  dr =  cmd.ExecuteReader();
     Console.WriteLine ("fields number: '{0}'", dr.FieldCount);

     if (dr.HasRows){
       while (dr.Read()){
         Console.WriteLine ("col1/name: '{0}'/'{2}', col2: '{1}', val column: '{3}'"
                  , dr.GetValue(0)
                  , dr.GetValue(1)
                  , dr.GetName(0)
                  , dr["val"]
                  );
       }
     }
    
     dr.Close();
    }
  }

<configuration>
  <system.data>
    <DbProviderFactories>
      <remove invariant="System.Data.SQLite" />
      <add name="SQLite Data Provider" invariant="System.Data.SQLite" description=".Net Framework Data Provider for SQLite" type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite, Version=1.0.86.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" />
    </DbProviderFactories>
  </system.data>
</configuration>

 // DbProviderFactory fact = DbProviderFactories.GetFactory("System.Data.SQLite");

  
//  using (SQLiteConnection cnn = (SQLiteConnection)fact.CreateConnection())
  using (SQLiteConnection cnn = new SQLiteConnection("Data Source=trace.db"))