Linqpad cannot insert into tables with no primary key defined in the database. For instance, I have a table with an auto-incrementing identity column. In visual studio I can insert into this table simply by defining the identity column as primary key with auto-sync false in the dbml or editing the edmx xml by hand.