How to properly organize a database search?

Question

C++ / C#

The database has several tables. I would like to organize a search in all tables. I think to do it in the following way
var t = from n in Product
Where n.Productname. Contains(textbox.text) || and so on ..
Is this the right train of thought?
And I would also like to clarify one point, how do you then display the results in the datagrid?

Answer 1

stackoverflow.com/questions/7938507/ef-code-first-...
But I like extension methods better IQueryable query = table.Query().Where( x => x.Name == 'query');