c# - Linq Where Clause - Accessing a tables column name -

I need inspiration from somewhere and no one is hoping, nobody can help.

This I created a previous thread, through which I want to be able to do an autocomplete search on a complete data table i.e. all the data from all the columns

I have created a stored procedure that pulls the completed item and the columns are derived from these objects ie

tblAutoCompleteItems:

  Item column item1 product item 2 product item 3 product red category 1 green category 1 blue range 1 small category 2 middle class 2 large category 2  

I have sorted the text box autocomplete and It works fine based on client selection, a label display That is generated columns relating to this column (hence the customers are happy with it can check that they're looking for) that. Lovely.

However, with my help with hard bits and bits, they are pulling back the second data set based on the parameters selected by them. Other data sets look like ...

tblProductInfo:

  Product Category 1 Category 2 Item 1 Red Big Item 2 Red Small Item 3 Blue Small  For example, a user for 'item 1' is an auto-integer, the textbox shows this and the label displays the 'product' Alternatively, a user wants to search by category 1 , Therefore 'red' is searched for, it is presented in the text box and label Displays 'Category 1' 
 
 When looking at tblProductInfo, I somehow need to query the dataset so that it can view the autocomplete column and the autocomplete item. 
 
 So when I press a button or whatever, the links appear on the first column, "Oh, I know, I need to see Category 1 and then return anything back to Red with it Drag "or" OK that is a product, I first recall the data associated with the product column and then item 1 "
 
. I am struggling in two parts (1) how to use the column names Make a table and (2) ou can be constructed in the linux section. 
 
 Any help, tips or advice received from heart - even if it means reconsideration of the whole strategy. 
 
 This is using C #, LINQ and asp.net. By 
 
 - I think that this is not an ideal looking at the full table, but it is out of my hands ... sadly. 
 

There are some ways to get metadata; You can drag it through a stored procedure (the sequences of SQL, Oracle, which can extract the metadata of a table), or if you are using SQL from LINQ, then you have the class to represent TBP Product Info You can use reflection to reflect.

To create the segment, you would like to use dynamic LINQ:

Because this allows you to use the string column name to query.

HTH