public string GenerateDataScript()
{
DataGenType dtype = DataGenType.Insert;
if (rbDInsert.Checked)
{
dtype = DataGenType.Insert;
}
else if (rbDUpdate.Checked)
{
dtype = DataGenType.Update;
}
else if (rbDTruncate.Checked)
{
dtype = DataGenType.Truncate;
}
else if (rbDTruncateInsert.Checked)
{
dtype = DataGenType.TruncateInsert;
}
ScriptBusiness scriptBusiness = new ScriptBusiness();
var server = new EntityBusiness().GetServerList().Where(x => x.ServerID == Convert.ToInt32(tscomserver.ComboBox.SelectedValue)).First();
string query = scriptBusiness.GenerateTableData(server, dtype, selectedtables);
return(query);
}
public string GenerateStructureScript()
{
StructureType stype = StructureType.IfNotExists;
if (rbStIfNotExists.Checked)
{
stype = StructureType.IfNotExists;
}
else if (rbStDropnCreate.Checked)
{
stype = StructureType.DropAndCreate;
}
else if (rbStCreate.Checked)
{
stype = StructureType.Create;
}
ScriptBusiness scriptBusiness = new ScriptBusiness();
string query = scriptBusiness.GenerateTableStructure(AppTimeConfiguration.MainServer, stype, selectedtables);
return(query);
}
