How to generate sql server script from c#.net?

[nirmalsingh]

hai all,
for example i am having a table: customer(sql server 2005), i want to generate a script for that table (insert) in which customer id > 10, and then i want to delete that table, and then again i want to restore it by running the insert script. how should i do this in c#.net? its very urgent.
Thanx in advance
Regards
Nirmal.

[nmsreddi]

Hello

In c# you have separate concept for SQLServer management called SMO ,have a look at it, using SMO objects you can do almost all possibilities using C#.

other wise simply you can generate script using SQLServer any you can run it at runtime in c# which also useful to solve your problem

Regards
nmsreddi

[nirmalsingh]

Hello

In c# you have separate concept for SQLServer management called SMO ,have a look at it, using SMO objects you can do almost all possibilities using C#.

other wise simply you can generate script using SQLServer any you can run it at runtime in c# which also useful to solve your problem

Regards
nmsreddi

Thanx a lot. it works fine.