Usually when creating a database table, you will tend to add “default values” to some columns (Guid, Dates, …).
BEGIN ALTER TABLE [dbo].[User] ADD DEFAULT (getdate()) FOR [Created] END
Adding the table to a DBML file under visual studio will ‘by default’ disallow the default value in the table.
The mapping with default values will work on identity and computed columns. It does not bring in default values set up in the database. You need to manually add those to your dbml table definitions.
Do not forget to set the value to True when you “delete” and re “add” the table into the dbml file.