http://www.compiledthoughts.com/2008/05/web-site-vs-web-application-project.html
http://blogs.vertigo.com/personal/swarren/Blog/Lists/Posts/Post.aspx?ID=10
http://isthmuspuravida.blogspot.com/2007/12/look-into-linq-to-sql.html
http://www.onedotnetway.com/linq-to-sql-tutorial/
http://aspguy.wordpress.com/2008/07/28/a-3-tier-architecture-with-linq-to-sql/
http://forums.asp.net/p/1299758/2532587.aspx
http://guy.dotnet-expertise.com/PermaLink,guid,dcd6dcf4-bee5-4a32-86d4-20821e8f556b.aspx
http://aspalliance.com/1414_LINQ_to_SQL_Part_4__Updating_our_Database.3
I was having the problem that SharePoint column was set to date only but when I used it in SPD workflows and sent emails and included this column in the emails, it put a timestamp of 12:00:00 on the column values. I had to use two datetime columns in my workflow to show duration of [DATE FROM] to [DATE TO]. In order to cut it, I created a calculated column and used the following formula and then I used the new column called "Duration" in my workflow.
=MONTH([Date From])&"/"&DAY([Date From])&"/"&YEAR([Date From])&" to "&MONTH([Date To])&"/"&DAY([Date To])&"/"&YEAR([Date To])
**[Date From] and [Date To] are columns of my SP list
Link that suggested me to do this was:
http://www.wssdemo.com/Lists/Resources/DispFormOld.aspx?ID=2086