If you want to use the Linq2Sql adventure, but we will find out about it.
I suggest you use EntityFrameWork if you are using .Net Framework 4.0 .. In EntityFramework you can use Linq queries better than Linq2Sql files.
ADO.Net become old, and we need to learn new things from time to time.
source share