Issue.cs

public async Task<List<KeyValuePair<string, string>>> WithoutDapper(Guid id)
		{
			using (var connection = new SqlConnection(ConnectionString))
			{
				List<KeyValuePair<string, string>> propertiesList = new List<KeyValuePair<string, string>>();
					SqlCommand command = new SqlCommand(queryString, connection);
					command.Parameters.AddWithValue("Id", id);

					connection.Open();
					SqlDataReader reader = await command.ExecuteReaderAsync();
					if (reader.HasRows)
					{
						while (reader.Read())
						{
							propertiesList.Add(new KeyValuePair<string, string>(
								reader["Name"].ToString(),
								reader["Type"].ToString()));
						}
					}
				return propertiesList;
			}
		}