C# 7 and .NET Core Cookbook - Second Edition

How to do it...

1. Create a new class called StarShip:

        public class Starship         {         }

2. To your class, add a new method that will set the maximum troop capacity of the StarShip class:

        public void SetMaximumTroopCapacity(int capacity)         {                     }

3. Inside this method, add a trycatch clause that will attempt to set the maximum troop capacity, but for some reason, it will fail. Upon failure, it will write the error to the log table inside the database:

        try         {           // Read current capacity and try to add more         }         catch (Exception ex)         {           string connectionString = "connection string goes  here";          string sql = $"INSERT INTO tblLog (error, date) VALUES            ({ex.Message}, GetDate())";          using (SqlConnection con = new                  SqlConnection(connectionString))           {  SqlCommand ...