public async Task <string> CompleteAdoption([FromQuery] string petId, string pettype) { try { Console.WriteLine($"[{AWSXRayRecorder.Instance.GetEntity().TraceId}] - In CompleteAdoption Action method - PetId:{petId} - PetType:{pettype}"); AWSXRayRecorder.Instance.AddAnnotation("PetId", petId); AWSXRayRecorder.Instance.AddAnnotation("PetType", pettype); _sqlConnection.ConnectionString = await GetConnectionString(); var sqlCommandText = $"INSERT INTO [dbo].[transactions] ([PetId], [Transaction_Id], [Adoption_Date]) VALUES ('{petId}', '{Guid.NewGuid().ToString()}', '{DateTime.Now.ToString()}')"; AWSXRayRecorder.Instance.AddMetadata("Query", sqlCommandText); using (_sqlConnection) { using var command = new TraceableSqlCommand(sqlCommandText, _sqlConnection); command.Connection.Open(); command.ExecuteNonQuery(); } } catch (Exception e) { return(e.Message); } AWSXRayRecorder.Instance.TraceMethod("UpdateAvailability", () => UpdateAvailability(petId, pettype)); return("Success"); }
private void QuerySql(int id) { var connectionString = ConfigurationManager.AppSettings["RDS_CONNECTION_STRING"]; using (var sqlConnection = new SqlConnection(connectionString)) using (var sqlCommand = new TraceableSqlCommand("SELECT " + id, sqlConnection)) { sqlCommand.Connection.Open(); sqlCommand.ExecuteNonQuery(); } }
private void QuerySql(int id) { var connectionString = ""; // Configure Connection string -> Format : "Data Source=(RDS endpoint),(port number);User ID=(your user name);Password=(your password);" using (var sqlConnection = new SqlConnection(connectionString)) using (var sqlCommand = new TraceableSqlCommand("SELECT " + id, sqlConnection)) { sqlCommand.Connection.Open(); sqlCommand.ExecuteNonQuery(); } }
public async Task CleanupAdoptions() { _sqlConnection.ConnectionString = await GetConnectionString(); var sqlCommandText = $"DELETE FROM [dbo].[transactions]"; AWSXRayRecorder.Instance.AddMetadata("Query", sqlCommandText); using (_sqlConnection) { using var command = new TraceableSqlCommand(sqlCommandText, _sqlConnection); command.Connection.Open(); command.ExecuteNonQuery(); } }
public void CleanupAdoptions() { _sqlConnection.ConnectionString = _configuration["rdsconnectionstring"]; var sqlCommandText = $"DELETE FROM [dbo].[transactions]"; AWSXRayRecorder.Instance.AddMetadata("Query", sqlCommandText); using (_sqlConnection) { using var command = new TraceableSqlCommand(sqlCommandText, _sqlConnection); command.Connection.Open(); command.ExecuteNonQuery(); } }