How Popular a Listview, and her Popular another Listview by Primary Key?

Question

I have two Listviews that I need popular using LINQ to SQL (C#, WPF project) from a search field. When typing in the field(textbox) the Keydown event will popular the first Listview (1), as the second has a column that is the Primary Key of the first, I need that in this second Listview (2) search the populated Primary Key in the first Listview (1). It is possible?

Detail: In both lists the variables are strings but have different values. For example, in Listiview(1) you search for a Description and in Listview(2) a Primary Key that are numbers (although it is a string) that is in Listview(1).

Understand: Databases_1 Popula Listview_1 Databases_2 Popula Listview_2

DataBases_1
Codigo(string_PK) | Descricao (string)
101               | Uva 
202               | Maca
303               | Melao
404               | Salada Mista
505               | Morango

DataBases_2
Nome              | Codigo(string_PK) 
Joao              | 404
Maria             | 404
Paulo             | 505
Felipe            | 101
Renata            | 202

First Listview Search Method(1) - Keydown Event :

using (DataClassesDataContext oDB = DataClassesDataContext())
{
    var busca = from p in oDB.DataBases where p.Descricao.Contains(txtPesquisa.Text) orderby p.Codigo descending select p;
    listView_1.ItemsSource = busca.ToList();
    listView_2.ItemsSource = ??????? ---> //Popular com base na lista encontrada pelo ListView_1 (var busca)
}

XMAL:

       <ListView x:Name="listView_1" Margin="34,345,618,51" ItemsSource="{Binding}" ScrollViewer.CanContentScroll="True" SelectionMode="Extended"><ListView.View>                                                                  <GridView>
    <GridViewColumn Header="Código" Width="Auto"  DisplayMemberBinding="{Binding Codigo/>
    <GridViewColumn Header="Descricao" Width="Auto" DisplayMemberBinding="{Binding Descricao}"/>
            </GridView>
            </ListView.View>
            </ListView>

        <ListView x:Name="listView_2" Margin="1050,345,72,51" ItemsSource="{Binding}" ScrollViewer.CanContentScroll="True" SelectionMode="Extended">
        <ListView.View>     

        <GridView>
<GridViewColumn Header="Nome" Width="Auto"  DisplayMemberBinding="{Binding Nome}"/>
<GridViewColumn Header="Código" Width="Auto" DisplayMemberBinding="{Binding Codigo}"/>
            </GridView>
            </ListView.View>
            </ListView>

Answer 1

You can do a second search using the first search codes:

using (DataClassesDataContext oDB = DataClassesDataContext())
{
    var busca = from p in oDB.DataBases_1 where p.Descricao.Contains(txtPesquisa.Text) orderby p.Codigo descending select p;
    listView_1.ItemsSource = busca.ToList();
    var codigosList1 = busca.Select((b) => b.Codigo).ToList();
    var busca2 = from p2 in oDB.DataBases_2 where codigosList1.Contains(p2.Codigo) orderby p2.Codigo descending select p2;
    listView_2.ItemsSource = busca2.ToList();
}

I recommend placing the search for the second listview on Event onchange (or WPF equivalent) of the first list view.