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; }