How to get the id value knowing one of the record parameters?

Question

C++ / C#

How to find out the record id knowing the variable in the record?

command = new SqlCommand("SELECT * FROM [Recent] WHERE [LibraryId] = @LibraryId", sqlConnection);//не знаю
            byte _id = 0;
            try
            {
                _id = Convert.ToByte(command.ExecuteScalar());
            }
            catch (Exception exc)
            {
                Console.WriteLine(exc.Message + "  2   " + exc.Source);
                _id = 0;
            }
            finally
            {
                if (_id != 0)
                {
                    command = new SqlCommand("DELETE FROM [Recent] WHERE [Id] = @Id", sqlConnection);
                    command.Parameters.AddWithValue("Id", _id);
                    await command.ExecuteNonQueryAsync();
                }
            }

Answer 1

command = new SqlCommand("SELECT [Id] FROM [Recent] WHERE [LibraryId] = @LibraryId", sqlConnection);
command.Parameters.AddWithValue("LibraryId", вашеЗначение);