LINQ to SQL Backup Script

Question

I have been asked to generate a Backup Script. Which comprises of a lot of insert statements.

However im not sure how to go about this with SQL to Linq, I have looked at the DataContext Mapping which is able to list all the tables. However I need to be able to then go through each row and grab the data, which will be wrote into the Backup Script.

Any advice would be appreciated.

Thank you

Pleun · Accepted Answer · 2011-03-03 12:30:00Z

1

Is it really a requirement to use Linq2SQL. Otherwise I guess the following stored procedure will do?

This procedure generates INSERT statements using existing data from the given tables and views. Later, you can use these INSERT statements to generate the data. It's very useful when you have to ship or package a database application. This procedure also comes in handy when you have to send sample data to your vendor or technical support provider for troubleshooting purposes.

http://vyaskn.tripod.com/code.htm#inserts

answered Mar 3, 2011 at 12:30

Pleun

8,9102 gold badges32 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

LINQ to SQL Backup Script

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related