Linq to SQL Error: Specified cast is not valid

I’ve been working with LINQ to SQL a fair bit recently, which so far has proved to be a very efficient and clean way to access data, although I think I found a bug! One of my SQL (2005) tables was defined as TinyInt, which the .Net framework saw as a boolean value, giving me a runtime error of ‘Specified cast is not valid’. I applied a work-around of changing the SQL data type to int, ans all was fine, although I’m not 100% happy with that as a fix.

I’ve also read of this error occuring after changing the datatype on a column, where the LINQ to SQL DBML hasnt caught up with the change, in this case the best option is to delete the table from the LINQ to SQL designer surface, then re-add, unless of course you have made any specific changes on the designer.