Ever tried to drop a DEFAULT CONSTRAINT, how do you find the constraint name – try this:
USE [<database>]
EXEC sp_helpconstraint [<schema>.<table_name>]
GO
I found that little tip here: http://www.mssqltips.com/tip.asp?tip=1425
Category: Reference
Useful LINQ to SQL links
I like LINQ to SQL, but I get occasionally caught out when trying something that seems like it should work. It compiles fine, but when you run the code you get: “Static method blah blah blah has no supported translation to SQL.”
This http://msdn.microsoft.com/en-us/library/bb386970.aspx details what methods and types are supported by LINQ to SQL.
Goto http://msdn.microsoft.com/en-us/library/bb386934.aspx for a general reference.
Helpful Programming Tips 