Setup a linq statement for a C# 2010 application?

Question

Since I am new to linq, I am asking this question. I would like to know how to setup a linq statement for a C# 2010 application

that communicates with a sql server2008 r2 database. I have the following two questions:
1. I would like to know how to select 6 specific columns from one database table. They key to the table is based on an identity

seed that is increment by one.
2. i would like to know how to pick the largest (maximum) and smallest (minimum) value for a create date in one table called

main.