public void AddLogEntry(LogEntry entry) { ConnectionStringSettings constr = ConfigurationManager.ConnectionStrings["mssql"]; SqlConnection db = new SqlConnection(); //constr.DataSource = "DAIMONX"; //constr.InitialCatalog = "MSMONGO"; //constr.UserID = "sa"; //constr.Password = "******"; //constr.IntegratedSecurity=true; db.ConnectionString = constr.ToString(); SqlCommand myCommand = new SqlCommand(); myCommand.Parameters.Add("@mdate", System.Data.SqlDbType.DateTime).Value = entry.Date; myCommand.Parameters.Add("@msg", System.Data.SqlDbType.VarChar).Value = entry.Message; myCommand.CommandText = "INSERT INTO ENTRIES (mdate, message) VALUES(@mdate, @msg)"; myCommand.Connection = db; db.Open(); myCommand.ExecuteNonQuery(); db.Close(); }
public void AddLogEntry(LogEntry entry) { string myInsertQuery = "INSERT INTO entries (mdate, message) Values(@mdate, @msg)"; MySqlParameter mdate = new MySqlParameter(); mdate.MySqlDbType = MySqlDbType.DateTime; mdate.ParameterName = "@mdate"; mdate.Value = entry.Date; MySqlParameter msg = new MySqlParameter(); msg.MySqlDbType = MySqlDbType.VarChar; msg.ParameterName = "@msg"; msg.Value = entry.Message; MySqlCommand myCommand = new MySqlCommand(myInsertQuery, db); myCommand.Parameters.Add(mdate); myCommand.Parameters.Add(msg); myCommand.Connection.Open(); myCommand.ExecuteNonQuery(); myCommand.Connection.Close(); }
public void AddLogEntry(LogEntry entry) { Document entryDOC = json.DocumentFrom(entry); logs.Insert(entryDOC); }