Пример #1
0
        private IVistaDBDatabase GetDatabase(string connectionString)
        {
            var builder = new VistaDBConnectionStringBuilder(connectionString);
            IVistaDBDatabase database = _dda.OpenDatabase(builder.DataSource, builder.OpenMode, builder.Password);

            return(database);
        }
        private IVistaDBDatabase GetDatabase(string connectionString)
        {
            var builder  = new VistaDBConnectionStringBuilder(connectionString);
            var password = !String.IsNullOrWhiteSpace(builder.Password) ? builder.Password : null;
            IVistaDBDatabase database = _dda.OpenDatabase(builder.DataSource, builder.OpenMode, password);

            return(database);
        }
Пример #3
0
        public DataTable GetDatabases()
        {
            DataTable metaData = new DataTable();

            metaData.Columns.Add("CATALOG_NAME", Type.GetType("System.String"));
            metaData.Columns.Add("DESCRIPTION", Type.GetType("System.String"));
            metaData.Columns.Add("SCHEMA_NAME", Type.GetType("System.String"));
            metaData.Columns.Add("SCHEMA_OWNER", Type.GetType("System.String"));
            metaData.Columns.Add("DEFAULT_CHARACTER_SET_CATALOG", Type.GetType("System.String"));
            metaData.Columns.Add("DEFAULT_CHARACTER_SET_SCHEMA", Type.GetType("System.String"));
            metaData.Columns.Add("DEFAULT_CHARACTER_SET_NAME", Type.GetType("System.String"));

            DataRow row = metaData.NewRow();

            metaData.Rows.Add(row);

            IVistaDBDatabase db = DDA.OpenDatabase(dbName, VistaDBDatabaseOpenMode.NonexclusiveReadOnly, password);

            row["CATALOG_NAME"] = GetDatabaseName();
            row["DESCRIPTION"]  = db.Description;

            return(metaData);
        }
Пример #4
0
        /// <summary>
        /// Turns off auto record identity generation so the record id from the master database can be used.
        /// </summary>
        /// <param name="tableName">SQL table name</param>
        /// <param name="columnName">the identity column</param>
        /// <param name="enable"></param>
        public void SetIdentityInsert(string tableName, string columnName, bool enable)
        {
            // VistaDB DDA code
            IVistaDBTable tbl = null;

            try
            {
                IVistaDBDDA DDAObj      = VistaDBEngine.Connections.OpenDDA();
                string      vistaDbPath = (string)AppDomain.CurrentDomain.GetData("DataDirectory");
                Debug.WriteLine("FormsSql.SetIdentityInsert VistaDbPath: " + vistaDbPath);
                // IVistaDBDatabase db = DDAObj.OpenDatabase(System.AppDomain.CurrentDomain.BaseDirectory + "App_Data\\forms.vdb5", VistaDB.VistaDBDatabaseOpenMode.NonexclusiveReadWrite, "aj80995");
                IVistaDBDatabase db = DDAObj.OpenDatabase(vistaDbPath + @"\forms.vdb5", VistaDB.VistaDBDatabaseOpenMode.NonexclusiveReadWrite, "P@ssword1");

                tbl = db.OpenTable(tableName, false, false);
            }
            catch (Exception xcptn)
            {
                Debug.WriteLine("FormsSql.SetIdentityInsert Exception: " + xcptn.Message);
                throw xcptn;
            }

            // table1s.AddColumn("ID", VistaDBType.Int);
            // table1s.DefineColumnAttributes("ID", false, false, false, false, null, null);
            // table1s.AddColumn("COLINT", VistaDBType.Int);
            // table1s.DefineColumnAttributes("COLINT", false, false, false, false, null, null);

            if (tbl.EnforceIdentities)
            {
                if (enable)
                {
                    tbl.DropIdentity(columnName);
                }
                else
                {
                    if (tableName == "def_FormResults")
                    {
                        int min  = getMin(columnName, tableName);
                        int next = min - 1;
                        tbl.CreateIdentity(columnName, next.ToString(), "-1");
                    }
                    else
                    {
                        int max  = getMax(columnName, tableName);
                        int next = max + 1;
                        tbl.CreateIdentity(columnName, next.ToString(), "1");
                    }
                }
            }
            else
            {
                if (!enable)
                {
                    if (tableName == "def_FormResults")
                    {
                        int min  = getMin(columnName, tableName);
                        int next = min - 1;
                        tbl.CreateIdentity(columnName, next.ToString(), "-1");
                    }
                    else
                    {
                        int max  = getMax(columnName, tableName);
                        int next = max + 1;
                        tbl.CreateIdentity(columnName, next.ToString(), "1");
                    }
                }
            }
            // tbl.CreateIndex("Primary", "ID", true, true);
            // tbl.CreateIndex("idxDate", "COLDATETIME", false, false);

            tbl.Close();
            tbl.Dispose();
            tbl = null;
        }
Пример #5
0
        public void OpenDatabase(bool readOnly)
        {
            System.Diagnostics.Debug.Assert(dda == null, "The database is already open");

            dda = VistaDBEngine.Connections.OpenDDA();
            db = dda.OpenDatabase(Path.Combine(basePath, "game.vdb3"),
              readOnly ? VistaDBDatabaseOpenMode.NonexclusiveReadOnly : VistaDBDatabaseOpenMode.ExclusiveReadWrite, null);
            packTable = db.OpenTable("Pack", false, readOnly);
            markerTable = db.OpenTable("Marker", false, readOnly);
            cardTable = db.OpenTable("Card", false, readOnly);
            cardModelCache = new Dictionary<Guid, CardModel>();
            setCache = new Dictionary<Guid, Set>();
        }
Пример #6
0
        public void GetDBCompexInfo(string dbName)
        {
            try
            {
                using (IVistaDBDDA conn = VistaDBEngine.Connections.OpenDDA())
                {
                    using (IVistaDBDatabase db = conn.OpenDatabase(dbName, VistaDBDatabaseOpenMode.ExclusiveReadOnly, null))
                    {
                        Console.WriteLine("METAINFORMATION FOR " + dbName + " DATABASE");
                        Console.WriteLine("-------------------------------------------");
                        Console.WriteLine("Table Description: " + db.Description);
                        Console.WriteLine("Row count: " + db.RowCount.ToString());
                        Console.WriteLine("PageSize:  " + db.PageSize.ToString());
                        Console.WriteLine("Open mode: " + db.Mode.ToString());
                        Console.WriteLine("Culture: " + db.Culture.ToString());
                        Console.WriteLine("Case Sensitive: " + db.CaseSensitive.ToString());

                        ArrayList tables = db.EnumTables();

                        foreach (string table in tables)
                        {
                            IVistaDBTableStructure tblStructure = db.TableStructure(table);
                            Console.WriteLine("============================================");
                            Console.WriteLine("Table " + table);
                            Console.WriteLine("============================================");

                            //columns
                            Console.WriteLine("COLUMNS:");
                            foreach (IVistaDBColumnAttributes colInfo in tblStructure)
                            {
                                Console.WriteLine("\t" + colInfo.Name);
                                //use colInfo for getting columns metadata
                            }

                            //indexes
                            Console.WriteLine("INDEXES:");
                            foreach (IVistaDBIndexInformation indexInfo in tblStructure.Indexes)
                            {
                                Console.WriteLine("\t" + indexInfo.Name);
                                //use indexInfo for getting columns metadata
                            }

                            //constraints
                            Console.WriteLine("CONSTRAINTS:");
                            foreach (IVistaDBConstraintInformation constrInfo in tblStructure.Constraints)
                            {
                                Console.WriteLine("\t" + constrInfo.Name);
                                //use constrInfo for getting columns metadata
                            }

                            //foreignKeys
                            Console.WriteLine("FOREIGN KEYS:");
                            foreach (IVistaDBRelationshipInformation relInfo in tblStructure.ForeignKeys)
                            {
                                Console.WriteLine("\t" + relInfo.Name);
                                //use foreignKeys for getting columns metadata
                            }
                        }
                    }
                }
            }
            catch (VistaDBException ex)
            {
            }
            catch
            {
            }
        }
Пример #7
0
        /// <summary>
        /// Returns a page of errors from the databse in descending order
        /// of logged time.
        /// </summary>

        public override int GetErrors(int pageIndex, int pageSize, IList errorEntryList)
        {
            if (pageIndex < 0)
            {
                throw new ArgumentOutOfRangeException("pageIndex", pageIndex, null);
            }

            if (pageSize < 0)
            {
                throw new ArgumentOutOfRangeException("pageSize", pageSize, null);
            }

            VistaDBConnectionStringBuilder builder = new VistaDBConnectionStringBuilder(_connectionString);


            // Use the VistaDB Direct Data Access objects
            IVistaDBDDA ddaObjects = VistaDBEngine.Connections.OpenDDA();
            // Create a connection object to a VistaDB database
            IVistaDBDatabase vistaDB = ddaObjects.OpenDatabase(_databasePath, builder.OpenMode, builder.Password);
            // Open the table
            IVistaDBTable elmahTable = vistaDB.OpenTable("ELMAH_Error", false, true);

            elmahTable.ActiveIndex = "IX_ELMAH_Error_App_Time_Id";

            if (errorEntryList != null)
            {
                if (!elmahTable.EndOfTable)
                {
                    // move to the correct record
                    elmahTable.First();
                    elmahTable.MoveBy(pageIndex * pageSize);

                    int rowsProcessed = 0;

                    // Traverse the table to get the records we want
                    while (!elmahTable.EndOfTable && rowsProcessed < pageSize)
                    {
                        rowsProcessed++;

                        string id    = Convert.ToString(elmahTable.Get("ErrorId").Value, CultureInfo.InvariantCulture);
                        Error  error = new Error();

                        error.ApplicationName = (string)elmahTable.Get("Application").Value;
                        error.HostName        = (string)elmahTable.Get("Host").Value;
                        error.Type            = (string)elmahTable.Get("Type").Value;
                        error.Source          = (string)elmahTable.Get("Source").Value;
                        error.Message         = (string)elmahTable.Get("Message").Value;
                        error.User            = (string)elmahTable.Get("User").Value;
                        error.StatusCode      = (int)elmahTable.Get("StatusCode").Value;
                        error.Time            = ((DateTime)elmahTable.Get("TimeUtc").Value).ToLocalTime();

                        errorEntryList.Add(new ErrorLogEntry(this, id, error));

                        // move to the next record
                        elmahTable.Next();
                    }
                }
            }

            return(Convert.ToInt32(elmahTable.RowCount));
        }