In our application we have used SQLMetal to generate classes based on an SQL Server 2005 Database. As a bit of an experiment we then use the DataContext CreateDatabase() method to create a .mdf file (i.e. a SQL Express 2005 database) from code at runtime (we have our reasons for trying to do this ). The 2 databases compared very well with a couple of exceptions: 1. None of the SQL Express tables had constraints. 2. Some tables that had foreign key relationships had the delete rule set to 'No Action':
Read More...