public void ClearLog() { DataLogger.ClearLog(DataLogger.requestsLogFile); { string sqlString = "delete from RequestsLog"; try { using (SqlConnection con = new SqlConnection(connectionString)) { using (var com = new SqlCommand(sqlString)) { com.Connection = con; com.CommandText = sqlString; con.Open(); com.ExecuteNonQuery(); } } } catch (SqlException e) { } } { string sqlString = "Insert into RequestsLog values (0, 'start');"; using (SqlConnection con = new SqlConnection(connectionString)) { using (var com = new SqlCommand(sqlString)) { com.Connection = con; com.CommandText = sqlString; con.Open(); com.ExecuteNonQuery(); } } } }
public Startup(IConfiguration configuration) { Configuration = configuration; DataLogger.ClearLog(DataLogger.requestsLogFile); }