public void CreateToDosTable()

in webapi/Models/TodoContext.cs [68:88]

• 20 lines of code
• 1 McCabe index (conditional complexity)

        public void CreateToDosTable()
        {
            using (MySqlConnection conn = GetConnection())
            {
                conn.Open();
                MySqlCommand cmd = new MySqlCommand();
                cmd.Connection = conn;

                string createTableSql = "use todo; ";
                createTableSql += "create table IF NOT EXISTS ToDos(";
                createTableSql += "id MEDIUMINT not null auto_increment,";
                createTableSql += "   CreatedTime TIMESTAMP DEFAULT now(),";
                createTableSql += "   Status VARCHAR(50),";
                createTableSql += "   Task VARCHAR(50),";
                createTableSql += "   primary key(id)";
                createTableSql += "); ";
                cmd.CommandText = createTableSql;
                cmd.ExecuteNonQuery();
            }
            Console.WriteLine("Table created successfully");
        }