>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