public static ProvisionTable ( |
||
master | ||
destination | ||
tableName | string | |
srid | int | |
oneWayOnly | bool | |
Résultat | void |
private void ProvisionMasterButton_Click(object sender, EventArgs e) { using (SqlConnection master = new SqlConnection(Settings.Default.MasterConnectionString)) { try { // SpatialProvisioning.ProvisionDatabase(master, master, this.scopeNameTextBox.Text, this.sridTextBox.Text); TableProvisioning.ProvisionTable(master, master, TableName, int.Parse(this.sridTextBox.Text), false); MessageBox.Show("Database successfully provisioned for syncing.", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception exception) { MessageBox.Show(exception.Message, @"Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void ProvisionClientButton_Click(object sender, EventArgs e) { using (SqlConnection master = new SqlConnection(Settings.Default.MasterConnectionString), slave = new SqlConnection(Settings.Default.SlaveConnectionString)) { try { using (SqlCommand command = slave.CreateCommand()) { slave.Open(); command.CommandText = string.Format("IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[{0}]') AND type in (N'U')) DROP TABLE [dbo].[{0}]", TableName); command.ExecuteNonQuery(); slave.Close(); } // SpatialProvisioning.ProvisionDatabase(slave, master, this.scopeNameTextBox.Text, this.sridTextBox.Text); TableProvisioning.ProvisionTable(master, slave, TableName, int.Parse(this.sridTextBox.Text), false); MessageBox.Show("Database successfully provisioned for syncing.", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception exception) { MessageBox.Show(exception.Message, @"Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }