通过code C#.NET生成SQL脚本 [英] generating sql script through code c#.net
问题描述
我已经手动通过生成脚本在任务生成的脚本菜单按右键点击数据库。
现在我的问题是,产生通过C#code该脚本...
Now my problem is to generate that script through c# code...
我的问题是
1),才有可能产生通过C#code?
1) is it possible to generate through c# code?
2)给我一些建议,以完成?
2) give me some tips in order to complete?
等待您的宝贵建议和命令
Waiting for your valuable suggestions and commands
推荐答案
由于它已经提到的,你CAS使用SMO要做到这一点,这里是一个用C#编写脚本的数据库,我提到的几个选项,但因为它的一个例子在@大卫布拉班特后,你可以指定许多选项的值。
As it's already mentioned, you cas use SMO to do this, here is a an example using C# to script a database, I mentioned few options, but as it is in the post of @David Brabant, you can specify the values of many options.
public string ScriptDatabase()
{
var sb = new StringBuilder();
var server = new Server(@"ServerName");
var databse = server.Databases["DatabaseName"];
var scripter = new Scripter(server);
scripter.Options.ScriptDrops = false;
scripter.Options.WithDependencies = true;
scripter.Options.IncludeHeaders = true;
//And so on ....
var smoObjects = new Urn[1];
foreach (Table t in databse.Tables)
{
smoObjects[0] = t.Urn;
if (t.IsSystemObject == false)
{
StringCollection sc = scripter.Script(smoObjects);
foreach (var st in sc)
{
sb.Append(st);
}
}
}
return sb.ToString();
}
这链接可以帮助您获取和脚本编写存储过程。
This link may help you getting and scripting stored procedures
这篇关于通过code C#.NET生成SQL脚本的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!