示例#1
0
        public void Initialize(DatabaseType databaseType, string connectionString, string generatedNamespace)
        {
            DatabaseType       = databaseType;
            ConnectionString   = connectionString;
            GeneratedNamespace = generatedNamespace;


            string databaseName = String.Empty;

            switch (databaseType)
            {
            case DatabaseType.SqlServer:
                var databaseAnalzer = new DatabaseAnalyzer(null);
                databaseName = databaseAnalzer.GetDatabaseName(connectionString);
                break;

            case DatabaseType.MySQL:
                var mysqlDatabaseAnalzer = new MySqlDatabaseAnalyzer(null);
                databaseName = mysqlDatabaseAnalzer.GetDatabaseName(connectionString);
                break;

            default:
                throw new NotSupportedException(databaseType.ToString());
            }


            //SqlConnection connection = new SqlConnection(connectionString);

            // These can be overridden by the templates, these values are just the defaults.
            _generatedClassName = databaseName;
            ConnectionKey       = databaseName;
        }
        private void btnSelect_Click(object sender, RoutedEventArgs e)
        {
            // Create OpenFileDialog
            Microsoft.Win32.OpenFileDialog dlg = new Microsoft.Win32.OpenFileDialog();

            // Set filter for file extension and default file extension
            dlg.DefaultExt = ".db";
            dlg.Filter     = "SqLite DB Files (*.db)|*.db|All Files (*.*)|*.*";

            // Display OpenFileDialog by calling ShowDialog method
            bool?result = dlg.ShowDialog();

            // Get the selected file name and display in a TextBox
            if (result == true)
            {
                // Open document
                string filename = dlg.FileName;
                txtDbPath.Text = filename;

                analyzer = new DatabaseAnalyzer(filename);
                if (analyzer.Load())
                {
                    FillList();
                }
            }
        }