C# using linq to sql

Question

Since I am new to working  a C# 2010 console application, I have the following questions to ask about how to accomplish the following tasks:

1. I would like to use linq to sql on a sql server 2008 r2 database to pull all the data from one column in one particular table. The value for the one array would be varchar(50) There will be more than one row selected at the time. (What I have seen of linq so far is to pull only one value by using singleordefault.)

2. I then would like to take the values obtained from step number one and load those values into array,collection, or some type of similar object.

Can tell me how to accomplisth this goal and/or point me to a reference that I can use?