Failed to set one or more properties on type .'' is not a valid value for Int32

http://social.msdn.microsoft.com/Forums/en/linqtosql/thread/0d36be8a-d801-46f8-a2aa-76315be65240

'System.Array' does not contain a definition for 'Contains' ...

http://social.msdn.microsoft.com/Forums/en-US/csharpgeneral/thread/d20d585c-de6f-4fce-bb62-8a4ff2321657

You have to Add Linq references.

using System.Linq; and (possibly):
using System.Data.Linq; // not sure about the latter though.

Convert sql to linq

http://blogs.msdn.com/vbteam/archive/2007/11/19/converting-sql-to-linq-part-1-the-basics-bill-horst.aspx

LINQ – Aggregate Functions & Help

http://www.dev102.com/2008/04/16/how-to-use-aggregate-functions-with-linq-to-sql/

http://www.packtpub.com/article/linq-quick-starter-table-of-contents

http://66.129.67.4/p/1234587/2238326.aspx

http://forums.asp.net/p/1207566/2135749.aspx

LINQ

http://aspalliance.com/1427_LINQ_to_SQL_Part_5__Binding_UI_using_the_ASPLinqDataSource_Control.all

http://www.devx.com/dotnet/Article/37065/0/page/2

LINQ to SQL and aggregate functions

http://linq.vinkas.com/index.php/2009/01/using-linq-to-sql/

http://knol.google.com/k/developer-shed/using-linq-to-sql/9r4tqiuaz279/3#

http://msdn.microsoft.com/en-us/vbasic/bb688088.aspx

Get ID of the latest item using LINQ

http://blog.jemm.net/articles/databases/how-to-common-data-patterns-with-linq-to-sql/#4

http://stackoverflow.com/questions/370547/get-id-using-linq-to-sql

Using MAX and aggregate functions with LINQ

http://social.msdn.microsoft.com/forums/en-US/linqprojectgeneral/thread/84c720e0-a734-4320-9cf7-b9a198a25184/

http://msdn.microsoft.com/en-us/vcsharp/aa336746.aspx

http://www.linqpad.net/

LinqDataSource & multiple tables

http://forums.asp.net/p/1355873/2784407.aspx

http://www.devx.com/dotnet/Article/37065/1954

http://weblogs.asp.net/toddanglin/archive/2007/09/18/using-the-linqdatasource-a-practical-look.aspx

http://stackoverflow.com/questions/32433/linq-select-with-multiple-tables

http://forums.asp.net/t/1301850.aspx

http://stackoverflow.com/questions/66094/net-35-linq-datasource-and-joins

http://www.beansoftware.com/ASP.NET-Tutorials/LINQDataSource-Control.aspx

http://www.ddj.com/205100230

Custom Insertion & Deletion using LINQ

http://www.codeproject.com/KB/aspnet/LinqDataSource3.aspx

http://www.programminghelp.com/web-development/asp-net/using-linq-to-sql-to-add-delete-from-sql-database-in-c/

http://www.dbtutorials.com/advanced/linq-delete-vb.aspx

http://www.albahari.com/nutshell/predicatebuilder.aspx

Custom insertion & deletion using LINQ

http://www.codeproject.com/KB/aspnet/LinqDataSource3.aspx

http://www.programminghelp.com/web-development/asp-net/using-linq-to-sql-to-add-delete-from-sql-database-in-c/

http://www.dbtutorials.com/advanced/linq-delete-vb.aspx

http://www.albahari.com/nutshell/predicatebuilder.aspx

Update Data using LINQ

http://dotnetstories.wordpress.com/2008/12/13/linq-to-sql-and-stored-procedures/

http://codebetter.com/blogs/david.hayden/archive/2008/02/19/linq-to-sql-and-stored-procedures-visual-studio-2008-and-repository-factory.aspx

SubmitChanges() not saving changes

It does not save changes when the table does not have a primary key defined.

http://forums.asp.net/t/1241069.aspx