public void Insert(Dictionary entries) { this.cmd = connection.CreateCommand(); string sql = "Insert into eventlogs(id,Machinename,Log,Category,Entrytype,"+ "EventId,Message,Source,Generated,Username) Values(null,@Machinename,@Log,"+ "@Category,@Entrytype,@EventId,@Message,@Source,@Generated,@Username);"; this.cmd.CommandText = sql; SqliteParameter machinename = new SqliteParameter(); machinename.ParameterName = "Machinename"; SqliteParameter category = new SqliteParameter(); category.ParameterName = "Category"; SqliteParameter entrytype = new SqliteParameter(); entrytype.ParameterName = "Entrytype"; SqliteParameter eventid = new SqliteParameter(); eventid.ParameterName = "EventId"; SqliteParameter message = new SqliteParameter(); message.ParameterName = "Message"; SqliteParameter source = new SqliteParameter(); source.ParameterName = "Source"; SqliteParameter generated = new SqliteParameter(); generated.ParameterName = "Generated"; SqliteParameter username = new SqliteParameter(); username.ParameterName = "Username"; SqliteParameter log = new SqliteParameter(); log.ParameterName = "Log"; this.cmd.Parameters.Add(machinename); this.cmd.Parameters.Add(category); this.cmd.Parameters.Add(entrytype); this.cmd.Parameters.Add(eventid); this.cmd.Parameters.Add(message); this.cmd.Parameters.Add(source); this.cmd.Parameters.Add(generated); this.cmd.Parameters.Add(username); this.cmd.Parameters.Add(log); foreach(KeyValuePair key_value in entries) { string Log = key_value.Key; EventLogEntryCollection entrycollection = key_value.Value; foreach(EventLogEntry entry in entrycollection) { machinename.Value = entry.MachineName; log.Value = Log; category.Value = entry.Category; entrytype.Value = entry.EntryType.ToString(); eventid.Value = entry.EventID; message.Value = entry.Message; source.Value = entry.Source; generated.Value = entry.TimeGenerated; username.Value = entry.UserName; try { this.cmd.ExecuteNonQuery(); } catch(Exception e) { } } } this.cmd = null; }