Selecting Usernames Uniquely

Question

Suppose that I have a table with a column labeled Name, which contains (possibly) repeating entries of unique usernames. What LINQ-to-SQL statement can I write to uniquely traverse the usernames? In other words:

Here is an example of the table:

Name    Log
User1   05/13/13
User2   05/13/13
User2   05/14/13
User3   05/15/13
User1   05/15/13

I want to select usernames uniquely:

User1, User2, User3.

Thanks in advance!

Answer 1

SELECT DISTINCT NAME FROM TABLE;

or in LinQ;

var names = Table.Select( t => t.Name ).Distinct().ToList();

Answer 2

Create a linq query and use the .Distinct extension method on the result.
Example:

var users = (from logfile in logfiles select logfile.Name).Distinct();