>>>To All:
>>>
>>>I have the following code:
>>>
>>>

>>>var _CSVTests = from cs in db.CSVTests
>>>                         select cs;
>>>
>>>foreach (CSVTest tst in _CSVTests)
>>>	{
>>>		
>>>		 In here I want to iterate over each column in each record and 
>>>		 if it is not equal to NULL I want to do something with the value,
>>>		 such as insert that value into another table.
>>>		
>>>	}
>>>

>>>
>>>How do I access the properties and values of each column in the results of my _CSVTests? Do I use IQueryable instead of var? How will that help me? I've been searching for this answer for two days now. PLEASE HELP.
>>>
>>>Thank you.
>>
>>You could do something like this:
>>

>>    var fields = typeof(CSVTest).GetProperties();
>>    foreach (CSVTest tst in _CSVTests)
>>    {
>>          foreach (var field in fields)
>>          {
>>              object v = field.GetValue(tst, null);
>>              if ( v == null ) 
>>                // ...
>>         }
>>    }
>>

>>Maybe copying to a datatable would be easier. Check ObjectShredder< T >:
>>http://msdn2.microsoft.com/library/bb669096.aspx
>>
>>Cetin
>
>You mean v not equal null, right?

Oh he wants NOT, yes:)
Cetin