I Have Lost Sql Server 2008 Database, I Need To The Database Structure Back From Linq Schema

My SQL Server 2008 server database for one of my new projects has deleted accidentally. What I'm left with is LINQ to SQL schema file (DataContext schema and classes) and with hope

Solution 1:

For simple schema you can just call dataContext.CreateDatabase() - however it would be ambitious to hope for this to handle everything. I suspect you may have to accept the loss and (sadly) learn about the value of backups.

See MSDN for more on CreateDatabase:

http://msdn.microsoft.com/en-us/library/system.data.linq.datacontext.createdatabase.aspx

Solution 2:

DataContext.CreateDatabase

Watch out for missing indexes, lookup data, etc.