Create a table in an existing database with LINQ to SQL

Question

I have a SQL Express 2008 database that has been broadcast. I would like to create a new table in this database without deleting all existing data in the live database. I created an entity class for the new table and a separate data context.

What is the best way to add a new table using LINQ to SQL

Thanks...

Answer 1

This is not a Linq To Sql role in your architecture. You need to create tables before deploying a new version of your data model.

You can manually update your db w / direct SQL commands against it, or you can pack it with a deployment (e.g. using continuous integration scripts or something like Migrator.NET)

Answer 2

The new Linq to Entity shipped with Visual Studio 2010 has an easy way to create a database table from the model you created.

here is an example: Create a database using the first model

Answer 3

Why not just execute an SQL statement like create table [mytable] ... ?

Answer 4

Why are you adding unmapped-entities to the chart? I think first you need to create tables after map objects.