private void connectBtnClicked(object sender, EventArgs e) { if (_currentConnection == null) { return; } toolStripStatusLabel1.Text = string.Format("Connecting to {0}...", _currentConnection.Name); statusStrip1.Refresh(); Cursor.Current = Cursors.WaitCursor; try { tablesListBox.DataSource = null; tablesListBox.DisplayMember = "Name"; sequencesComboBox.Items.Clear(); metadataReader = MetadataFactory.GetReader(_currentConnection.Type, _currentConnection.ConnectionString); toolStripStatusLabel1.Text = "Retrieving owners..."; statusStrip1.Refresh(); PopulateOwners(); toolStripStatusLabel1.Text = string.Empty; } catch (Exception ex) { toolStripStatusLabel1.Text = ex.Message; } finally { Cursor.Current = Cursors.Default; } }
public void ShouldCreateTheAppropriateMetadataReader() { IMetadataReader metadataReader = MetadataFactory.GetReader(ServerType.Oracle, "conn"); Assert.That(metadataReader, Is.TypeOf(typeof (OracleMetadataReader))); metadataReader = MetadataFactory.GetReader(ServerType.SqlServer, "conn"); Assert.That(metadataReader, Is.TypeOf(typeof (SqlServerMetadataReader))); }
private void openMetadataToolStripMenuItem_Click(object sender, System.EventArgs e) { var cfg = Configuration.Project.Directories[Configuration.DirectoryCollection.DirectoryType.Metadata]; using (var ofd = new OpenFileDialog()) { ofd.InitialDirectory = cfg.FullPath; ofd.FileName = cfg.File; ofd.Filter = "CSV|*.csv|Excel 97-2003|*.xls"; if (!string.IsNullOrEmpty(cfg.File)) { ofd.FilterIndex = cfg.File.EndsWith("csv") ? 1 : 2; } if (ofd.ShowDialog() == DialogResult.OK) { var mr = MetadataFactory.GetReader(ofd.FileName); var openMetadataDetailsForm = new MetadataOpen(); if (mr.SupportSheets) { openMetadataDetailsForm.MetadataReader = mr; openMetadataDetailsForm.ShowDialog(); } StartClick(null); metadataTreeview.Nodes.Clear(); mr.ProgressStatusChanged += new ProgressStatusHandler(ProgressStatus); Metadata = mr.Read(); mr.ProgressStatusChanged -= new ProgressStatusHandler(ProgressStatus); metadataTreeview.Content = Metadata; if (mr.SupportSheets && openMetadataDetailsForm.Track != "None") { var perspTrack = mr.Read(openMetadataDetailsForm.Track); metadataTreeview.Selection = perspTrack; } cfg.FullFileName = ofd.FileName; EndClick(null); } } }
private void generateMapclass() { var Mapclasssettings = new Connection(); string mapTempPath = Path.GetTempPath(); if (mapTempPath.EndsWith(@"\") == false) { mapTempPath += @"\"; } mapTempPath += @"Mapping\"; if (Directory.Exists(mapTempPath) == false) { Directory.CreateDirectory(mapTempPath); } Mapclasssettings.Domainfolderpath = mapTempPath; Mapclasssettings.ConnectionString = ConfigurationManager.AppSettings["ConnectionString"]; Mapclasssettings.EntityName = "Entity"; if ((RecoEngine_BI.Common.iDBType) == (int)Enums.DBType.Oracle) { Mapclasssettings.Type = ServerType.Oracle; } metadataReader = MetadataFactory.GetReader(Mapclasssettings.Type, Mapclasssettings.ConnectionString); var owners = metadataReader.GetOwners(); IList <Table> tblList = metadataReader.GetTables("RECOUSR"); int tableindex = 0; for (int i = 0; i < tblList.Count; i++) { if (tblList[i].Name == "OPPORTUNITY") { tableindex = i; break; } } Table table = tblList[tableindex]; table.PrimaryKey = metadataReader.DeterminePrimaryKeys(table); metadataReader.GetTableDetails(table, "RECOUSR"); var applicationPreferences = GetApplicationPreferences(table, false, Mapclasssettings); new ApplicationController(applicationPreferences, table).Generate(); }
private void connectBtnClicked(object sender, EventArgs e) { errorLabel.Text = string.Empty; Cursor.Current = Cursors.WaitCursor; try { tablesListBox.Items.Clear(); sequencesComboBox.Items.Clear(); metadataReader = MetadataFactory.GetReader((ServerType)serverTypeComboBox.SelectedItem, connStrTextBox.Text); PopulateOwners(); PopulateTablesAndSequences(); } catch (Exception ex) { errorLabel.Text = ex.Message; } finally { Cursor.Current = Cursors.Default; } }