C# (CSharp) SQLUtils.CheckTableExists示例

        private void CreateTables()
        {
            if (!SQLUtils.CheckTableExists(CategoryTable, client))
            {
                CreateCategoriesTable();
            }

            if (!SQLUtils.CheckTableExists(ItemsTable, client))
            {
                CreateItemsTable();
            }

            if (!SQLUtils.CheckTableExists(TagsTable, client))
            {
                CreateTagsTable();
            }

            if (!SQLUtils.CheckTableExists(ItemTagsTable, client))
            {
                CreateItemTagsTable();
            }

            if (!SQLUtils.CheckTableExists(ItemAttributesTable, client))
            {
                CreateItemAttributesTable();
            }
        }

示例#2

显示文件

文件： SQLiteStore.cs 项目： gitpushdev/devrant

        private void Upgrade()
        {
            if (!SQLUtils.CheckTableExists(TableDrafts, this))
            {
                ExecuteNonQuery(CreateDraftsTableQuery);
            }

            if (!SQLUtils.CheckTableExists(TableSubscribed, this))
            {
                ExecuteNonQuery(CreateSubscribedTableQuery);
            }
        }

示例#3

显示文件

文件： SQLiteStore.cs 项目： allanx2000/PrimeTracker

        private void CreateTables()
        {
            if (!SQLUtils.CheckTableExists(VideosTable, this))
            {
                string sql = LoadFromText("CreateSeriesTable", SeriesTable);
                ExecuteNonQuery(sql);

                sql = LoadFromText("CreateVideosTable", VideosTable, SeriesTable);
                ExecuteNonQuery(sql);

                sql = LoadFromText("CreateTagsTable", TagsTable, VideosTable);
                ExecuteNonQuery(sql);
            }

            if (!SQLUtils.CheckTableExists(RatingsTable, this))
            {
                string sql = LoadFromText("CreateRatingsTable", RatingsTable, VideosTable);
                ExecuteNonQuery(sql);
            }
        }