private void SetupCustomTables(ApplicationContext applicationContext) { var logger = LoggerResolver.Current.Logger; var dbContext = applicationContext.DatabaseContext; var schemaHelper = new DatabaseSchemaHelper(dbContext.Database, logger, dbContext.SqlSyntax); if (!schemaHelper.TableExist("PolRegioUser")) { schemaHelper.CreateTable <UserDB>(overwrite: false); } if (!schemaHelper.TableExist("PolRegioUserRegion")) { schemaHelper.CreateTable <UserRegionDB>(overwrite: false); } if (!schemaHelper.TableExist("PolRegioAgreement")) { schemaHelper.CreateTable <AgreementDB>(overwrite: false); } if (!schemaHelper.TableExist("PolRegioUserAgreement")) { schemaHelper.CreateTable <UserAgreementDB>(overwrite: false); } if (!schemaHelper.TableExist("PolRegioStations")) { schemaHelper.CreateTable <StationDB>(overwrite: false); } }
protected void EnsureTablesExist() { // TODO: Should this be stored in UmbracoIdentity SQL CE database? var dbCtx = ApplicationContext.Current.DatabaseContext; var dbSchemaHelper = new DatabaseSchemaHelper(dbCtx.Database, LoggerResolver.Current.Logger, dbCtx.SqlSyntax); if (!dbSchemaHelper.TableExist(typeof(OAuthClient).Name)) { // Create table dbSchemaHelper.CreateTable(false, typeof(OAuthClient)); // Seed the table dbCtx.Database.Save(new OAuthClient { ClientId = "DemoClient", Name = "Demo Client", Secret = "demo", SecurityLevel = SecurityLevel.Insecure, RefreshTokenLifeTime = 14400, AllowedOrigin = "*" }); } if (!dbSchemaHelper.TableExist(typeof(OAuthRefreshToken).Name)) { // Create table dbSchemaHelper.CreateTable(false, typeof(OAuthRefreshToken)); } }
protected override void ApplicationStarting( UmbracoApplicationBase umbracoApplication, ApplicationContext applicationContext) { DatabaseContext ctx = ApplicationContext.Current.DatabaseContext; DatabaseSchemaHelper dbSchema = new DatabaseSchemaHelper( ctx.Database, ApplicationContext.Current.ProfilingLogger.Logger, ctx.SqlSyntax); if (!dbSchema.TableExist <Category>()) { dbSchema.CreateTable <Category>(false); ctx.Database.Execute("ALTER TABLE Categories ADD CONSTRAINT UC_CategoryName UNIQUE(CategoryName);"); } if (!dbSchema.TableExist <Product>()) { dbSchema.CreateTable <Product>(false); ctx.Database.Execute("ALTER TABLE Products ADD CONSTRAINT UC_ProductName UNIQUE(Name);"); } if (!dbSchema.TableExist <Order>()) { dbSchema.CreateTable <Order>(false); dbSchema.CreateTable <OrderItem>(false); } }
//This happens everytime the Umbraco Application starts protected override void ApplicationStarted(UmbracoApplicationBase umbracoApplication, ApplicationContext applicationContext) { //Get the Umbraco Database context var dbCtx = applicationContext.DatabaseContext; var db = new DatabaseSchemaHelper(dbCtx.Database, applicationContext.ProfilingLogger.Logger, dbCtx.SqlSyntax); //Check if the DB table does NOT exist if (!db.TableExist("PetaPocoHomePageWhatsNew")) { //Create DB table - and set overwrite to false db.CreateTable <PetaPocoHomePageWhatsNew>(false); } if (!db.TableExist("PetaPocoOutOfDateContent")) { //Create DB table - and set overwrite to false db.CreateTable <PetaPocoOutOfDateContent>(false); } if (!db.TableExist("PetaPocoUserProfiles")) { //Create DB table - and set overwrite to false db.CreateTable <PetaPocoUserProfile>(false); } }
protected override void ApplicationStarted(UmbracoApplicationBase umbracoApplication, ApplicationContext applicationContext) { var ctx = applicationContext.DatabaseContext; using (var db = ctx.Database) { var schema = new DatabaseSchemaHelper(db, applicationContext.ProfilingLogger.Logger, ctx.SqlSyntax); if (!schema.TableExist("simpleTranslationProposals")) { schema.CreateTable <TranslationProposal>(false); } if (!schema.TableExist("simpleTranslationTasks")) { schema.CreateTable <TranslationTask>(false); } if (!schema.TableExist("simpleTranslationUserLanguages")) { schema.CreateTable <UserLanguage>(false); } if (!schema.TableExist("simpleTranslationUserRoles")) { schema.CreateTable <UserRole>(false); } } }
protected override void ApplicationStarted(UmbracoApplicationBase umbracoApplication, ApplicationContext applicationContext) { var logger = LoggerResolver.Current.Logger; var dbContext = applicationContext.DatabaseContext; var dbHelper = new DatabaseSchemaHelper(dbContext.Database, logger, dbContext.SqlSyntax); if (!dbHelper.TableExist(PackageConstants.DbSettingsTable)) { dbHelper.CreateTable <TSetting>(false); } if (!dbHelper.TableExist(PackageConstants.DbHistoryTable)) { dbHelper.CreateTable <TinyPNGResponseHistory>(false); } if (!dbHelper.TableExist(PackageConstants.DbStatisticTable)) { dbHelper.CreateTable <TImageStatistic>(false); } if (!dbHelper.TableExist(PackageConstants.DbStateTable)) { dbHelper.CreateTable <TState>(false); } base.ApplicationStarted(umbracoApplication, applicationContext); }
/// <summary> /// Nadpisanie metody ApplicationStarted /// Metoda zawiera customowe rozwiązania dla CMS /// </summary> /// <param name="umbracoApplication">obiekt UmbracoApplicationBase</param> /// <param name="applicationContext">obiekt ApplicationContext</param> protected override void ApplicationStarted(UmbracoApplicationBase umbracoApplication, ApplicationContext applicationContext) { #region CustomTables var _db = applicationContext.DatabaseContext.Database; var _logger = LoggerResolver.Current.Logger; var _sqlSyntax = applicationContext.DatabaseContext.SqlSyntax; var _dbHelper = new DatabaseSchemaHelper(_db, _logger, _sqlSyntax); if (!_dbHelper.TableExist("PolRegioRegion")) { _dbHelper.CreateTable <RegionDB>(true); } if (!_dbHelper.TableExist("PolRegioArticleType")) { _dbHelper.CreateTable <ArticleTypeDB>(true); } if (!_dbHelper.TableExist("PolRegioAdministrative")) { _dbHelper.CreateTable <AdministrativeDB>(true); } #endregion var _contentServiceEvents = new ContentServiceEvents(applicationContext); ContentService.Saved += _contentServiceEvents.ContentService_Saved; }
protected override void ApplicationStarted(UmbracoApplicationBase umbracoApplication, ApplicationContext applicationContext) { var dbContext = applicationContext.DatabaseContext; var db = new DatabaseSchemaHelper(dbContext.Database, applicationContext.ProfilingLogger.Logger, dbContext.SqlSyntax); if (!db.TableExist <Booking>()) { db.CreateTable <Booking>(); } if (!db.TableExist <Token>()) { db.CreateTable <Token>(); } if (!db.TableExist <SummaryEmail>()) { db.CreateTable <SummaryEmail>(); } if (!db.TableExist <NewBookingEmail>()) { db.CreateTable <NewBookingEmail>(); } }
public bool CreateTables() { var importConfig = false; try { var schema = new DatabaseSchemaHelper(dbContext.Database, ApplicationContext.Current.ProfilingLogger.Logger, dbContext.SqlSyntax); if (!schema.TableExist("LeBlenderGridEditor")) { schema.CreateTable <LeBlenderGridEditorModel>(false); importConfig = true; } if (!schema.TableExist("LeBlenderConfig")) { schema.CreateTable <LeBlenderConfigModel>(false); } if (!schema.TableExist("LeBlenderProperty")) { schema.CreateTable <LeBlenderPropertyModel>(false); } } catch (Exception ex) { LogHelper.Error <DatabaseHelper>($"Error while creating database tables", ex); } return(importConfig); }
//This happens everytime the Umbraco Application starts protected override void ApplicationStarted(UmbracoApplicationBase umbracoApplication, ApplicationContext applicationContext) { //Get the Umbraco Database context var ctx = applicationContext.DatabaseContext; var db = new DatabaseSchemaHelper(ctx.Database, applicationContext.ProfilingLogger.Logger, ctx.SqlSyntax); //Check if the DB table does NOT exist if (!db.TableExist(FortressConstants.TableNames.FortressUser2FASettings)) { //Create DB table - and set overwrite to false db.CreateTable <FortressUser2FASettings>(false); } /* if (!db.TableExist(FortressConstants.TableNames.FortressLoginEvents)) * { * //Create DB table - and set overwrite to false * db.CreateTable<FortressLoginEvent>(false); * }*/ if (!db.TableExist(FortressConstants.TableNames.FortressSettings)) { //Create DB table - and set overwrite to false db.CreateTable <FortressSettingEntry>(false); FortressSettingEntry.InsertInitialSettings(ctx.Database, ApplicationContext.Current.DatabaseContext.SqlSyntax); } /* if (!db.TableExist(FortressConstants.TableNames.FortressFirewallEntry)) * { * //Create DB table - and set overwrite to false * db.CreateTable<FortressFirewallEntry>(false); * }*/ FortressContext.Initialize(); }
/// <summary> /// Creates the table for the specified object type. /// </summary> /// <typeparam name="T">The object type.</typeparam> public void CreateTable <T>() where T : new() { if (TableExists <T>()) { return; } _databaseSchemaHelper.CreateTable <T>(); }
public override void Up() { try { _sh.CreateTable <NovicellMapBuilderMapsModel>(false); _sh.CreateTable <NovicellMapBuilderDataModel>(false); } catch (Exception e) { _logger.Error <MapBuilderMigration>("Error creating tables for NcMapBuilder", e); } }
/// <summary> /// Creates the Configuration table /// </summary> public override void Up() { // Environment if (_schemaHelper.TableExist <Dto.Environment.Environment100>()) { var sql = new Sql().Where("id != 1"); _database.Delete <Dto.Environment.Environment100>(sql); Alter.Table <Dto.Environment.Environment103>().AddColumn(nameof(Dto.Environment.Environment103.SortOrder)).AsInt32().NotNullable().WithDefaultValue(Constants.Tree.DefaultEnvironmentSortOrder); Alter.Table <Dto.Environment.Environment103>().AddColumn(nameof(Dto.Environment.Environment103.Enable)).AsBoolean().NotNullable().WithDefaultValue(true); Alter.Table <Dto.Environment.Environment103>().AddColumn(nameof(Dto.Environment.Environment103.ContinueProcessing)).AsBoolean().NotNullable().WithDefaultValue(true); Alter.Table <Dto.Environment.Environment103>().AddColumn(nameof(Dto.Environment.Environment103.ColorIndicator)).AsString(7).NotNullable().WithDefaultValue("#df7f48"); } else { _schemaHelper.CreateTable <Dto.Environment.Environment103>(); _database.Insert(new Dto.Environment.Environment103 { Name = "Default", Icon = "icon-firewall red", Enable = true, ContinueProcessing = true, SortOrder = Constants.Tree.DefaultEnvironmentSortOrder, ColorIndicator = "#df7f48" }); } // Domain if (!_schemaHelper.TableExist <Dto.Domain.Domain100>()) { _schemaHelper.CreateTable <Dto.Domain.Domain100>(); } // Configuration if (!_schemaHelper.TableExist <Dto.Configuration.Configuration100>()) { _schemaHelper.CreateTable <Dto.Configuration.Configuration103>(); } // Journal if (_schemaHelper.TableExist <Dto.Journal.Journal100>()) { Delete.Index("IX_" + nameof(Shield) + "_" + nameof(Dto.Journal.Journal100.Datestamp)).OnTable <Dto.Journal.Journal100>(); Create.Index("IX_" + nameof(Shield) + "_" + nameof(Dto.Journal.Journal103.Datestamp)).OnTable <Dto.Journal.Journal103>() .OnColumn(nameof(Dto.Journal.Journal103.Datestamp)).Ascending().WithOptions().NonClustered(); } else { _schemaHelper.CreateTable <Dto.Journal.Journal103>(); } }
/// <inheritdoc /> protected override void ApplicationStarted( UmbracoApplicationBase umbracoApplication, ApplicationContext applicationContext) { if (applicationContext.IsConfigured) { var ctx = applicationContext.DatabaseContext; var db = new DatabaseSchemaHelper(ctx.Database, applicationContext.ProfilingLogger.Logger, ctx.SqlSyntax); db.CreateTable <ClaremontEvent>(false); db.CreateTable <Participant>(false); db.CreateTable <Notification>(false); db.CreateTable <JobInfo>(false); } }
protected override void ApplicationStarted(UmbracoApplicationBase umbracoApplication, ApplicationContext applicationContext) { var ctx = applicationContext.DatabaseContext; var db = new DatabaseSchemaHelper(ctx.Database, applicationContext.ProfilingLogger.Logger, ctx.SqlSyntax); if (!db.TableExist("CMSPoints")) { db.CreateTable <Points>(false); } if (!db.TableExist("CMSStateInfo")) { db.CreateTable <States>(false); } }
private void CreateTables() { if (!_schemaHelper.TableExist(accountsTableName)) { Logger.Info <CreateInitialTables>("Creation Accounts Table"); _schemaHelper.CreateTable <Account>(); } if (!_schemaHelper.TableExist(accountSettingsTableName)) { Logger.Info <CreateInitialTables>("Creating AccountSettings Table"); _schemaHelper.CreateTable <AccountSettings>(); } }
public override void Up() { try { // Create tables _schemaHelper.CreateTable <Dto.Entry.Entry100>(); _schemaHelper.CreateTable <Dto.Ancestor.Ancestor100>(); // Scrape all existing content and place into the index var ancestorDb = new AncestorContext(); var entryDb = new EntryContext(); var now = DateTime.UtcNow; var contents = new Stack <Umbraco.Core.Models.IContent>(); var contentService = ApplicationContext.Current.Services.ContentService; foreach (var content in contentService.GetChildren(Umbraco.Core.Constants.System.Root)) { if (content.Published) { contents.Push(content); } } while (contents.Count != 0) { var content = contents.Pop(); foreach (var child in contentService.GetChildren(content.Id)) { if (child.Published) { contents.Push(child); } } foreach (var entry in new ContentService().Entries(new Umbraco.Core.Models.IContent[] { content })) { entryDb.Write(entry.Key, entry.Id, entry.Map, now); ancestorDb.Write(entry.Id, entry.Key, now); foreach (var ancestor in entry.Ancestors) { ancestorDb.Write(ancestor, entry.Key, now); } } System.Threading.Thread.Sleep(50); } } catch (Exception ex) { LogHelper.Error <SqlIndexer>($"Error trying to create content with indexer", ex); } }
protected override void ApplicationStarted(UmbracoApplicationBase umbracoApplication, ApplicationContext applicationContext) { var dbContext = applicationContext.DatabaseContext; var db = new DatabaseSchemaHelper(dbContext.Database, applicationContext.ProfilingLogger.Logger, dbContext.SqlSyntax); // automatically create the tables for the index on app start if (db.TableExist("FormEditorEntries") == false) { db.CreateTable <Entry>(false); } if (db.TableExist("FormEditorFiles") == false) { db.CreateTable <File>(false); } }
/// <summary> /// When umbraco has started up /// </summary> protected override void ApplicationStarted(UmbracoApplicationBase umbracoApplication, ApplicationContext applicationContext) { // Store our JWT secret somewhere safe before adding it to the Env variable. // This allows us to move the project between environments and maintain the // same secret. This should ideally be in a config file of its own so // we can ignore it from source control etc. but we're just going to use // AppSettings for now... Configuration config = WebConfigurationManager.OpenWebConfiguration("/"); if (config.AppSettings.Settings["JWT:Secret"] == null) { config.AppSettings.Settings.Add("JWT:Secret", Membership.GeneratePassword(50, 5)); config.Save(ConfigurationSaveMode.Modified); } //When Umbraco Started lets check for DB table exists var dbContext = applicationContext.DatabaseContext; var db = new DatabaseSchemaHelper(dbContext.Database, applicationContext.ProfilingLogger.Logger, dbContext.SqlSyntax); //If table does not exist if (!db.TableExist("identityAuthTokens")) { //Create Table - do not override db.CreateTable <UmbracoAuthToken>(false); } //Add event to saving/chaning pasword on Umbraco backoffice user UserService.SavingUser += UserService_SavingUser; //Add event to saving/chaning pasword on Umbraco member MemberService.Saving += MemberService_Saving; //Continue as normal base.ApplicationStarted(umbracoApplication, applicationContext); }
/// <summary> /// Adds the indexes to the merchDigitalMedia table. /// </summary> public override void Up() { if (!_schemaHelper.TableExist("merchDigitalMedia")) { _schemaHelper.CreateTable(false, typeof(DigitalMediaDto)); } }
protected override void ApplicationStarted(UmbracoApplicationBase umbracoApplication, ApplicationContext applicationContext) { var ctx = applicationContext.DatabaseContext; var db = new DatabaseSchemaHelper(ctx.Database, applicationContext.ProfilingLogger.Logger, ctx.SqlSyntax); db.CreateTable <Person>(false); }
public override void Up() { var schemaHelper = new DatabaseSchemaHelper(Context.Database, Logger, SqlSyntax); //NOTE: This isn't the correct way to do this but to manually create this table with the Create syntax is a pain in the arse schemaHelper.CreateTable <ServerRegistrationDto>(); }
public void CreateTabelIfNone() { if (!_dbSchemaHelper.TableExist(_tableName)) { _dbSchemaHelper.CreateTable <ReceiveDbModel>(false); } }
/// <summary> /// Adds the new table to the database. /// </summary> public override void Up() { if (!_schemaHelper.TableExist("merchProductOptionAttributeShare")) { _schemaHelper.CreateTable(false, typeof(ProductOptionAttributeShareDto)); } }
/// <summary> /// Performs the task of adding the table. /// </summary> public void Up() { if (!_schemaHelper.TableExist("merchNote")) { _schemaHelper.CreateTable(false, typeof(NoteDto)); } }
/// <summary> /// The up. /// </summary> public void Up() { foreach (var item in OrderedTables.OrderBy(x => x.Key)) { _schemaHelper.CreateTable(false, item.Value); } }
/// <summary> /// Adds the table to the database /// </summary> public void Up() { if (!_schemaHelper.TableExist("merchCustomer2EntityCollection")) { _schemaHelper.CreateTable(false, typeof(Customer2EntityCollectionDto)); } }
/// <summary> /// Creates the ProductVariant2DetachedContentType table /// </summary> public void Up() { if (!_schemaHelper.TableExist("merchProductVariantDetachedContent")) { _schemaHelper.CreateTable(false, typeof(ProductVariantDetachedContentDto)); } }
private void CreateTinifierTables() { var logger = LoggerResolver.Current.Logger; var dbContext = ApplicationContext.Current.DatabaseContext; var dbHelper = new DatabaseSchemaHelper(dbContext.Database, logger, dbContext.SqlSyntax); var tables = new Dictionary <string, Type> { { PackageConstants.DbSettingsTable, typeof(TSetting) }, { PackageConstants.DbHistoryTable, typeof(TinyPNGResponseHistory) }, { PackageConstants.DbStatisticTable, typeof(TImageStatistic) }, { PackageConstants.DbStateTable, typeof(TState) }, { PackageConstants.MediaHistoryTable, typeof(TinifierMediaHistory) } }; for (var i = 0; i < tables.Count; i++) { if (!dbHelper.TableExist(tables.ElementAt(i).Key)) { dbHelper.CreateTable(false, tables.ElementAt(i).Value); } } // migrations foreach (var migration in Application.Migrations.MigrationsHelper.GetAllMigrations()) { migration?.Resolve(dbContext); } }
protected override void ApplicationStarted(UmbracoApplicationBase umbracoApplication, ApplicationContext applicationContext) { DatabaseContext ctx = ApplicationContext.Current.DatabaseContext; DatabaseSchemaHelper dbSchema = new DatabaseSchemaHelper(ctx.Database, ApplicationContext.Current.ProfilingLogger.Logger, ctx.SqlSyntax); if (!dbSchema.TableExist("CompanyInvetoryAudit")) { dbSchema.CreateTable <CompanyInvetoryAudit>(false); } if (!dbSchema.TableExist("CompanyInventory")) { dbSchema.CreateTable <CompanyInventory>(false); } }
protected override void ApplicationStarted(UmbracoApplicationBase umbracoApplication, ApplicationContext applicationContext) { var dbContext = applicationContext.DatabaseContext; var db = new DatabaseSchemaHelper(dbContext.Database, applicationContext.ProfilingLogger.Logger, dbContext.SqlSyntax); // automatically create the tables for the index on app start if (db.TableExist("FormEditorEntries") == false) { db.CreateTable<Entry>(false); // hack to get SQL server to use NVARCHAR(MAX) datatype dbContext.Database.Execute("ALTER TABLE FormEditorEntries ALTER COLUMN FieldValues NVARCHAR(MAX)"); } if (db.TableExist("FormEditorFiles") == false) { db.CreateTable<File>(false); } }
/// <summary> /// On Application Started we need to ensure that the Redirects table exists. If not, create it /// </summary> protected override void ApplicationStarted(UmbracoApplicationBase umbracoApplication, ApplicationContext applicationContext) { //Grab the Umbraco database context and spin up a new DatabaseSchemaHelper var db = applicationContext.DatabaseContext.Database; var creator = new DatabaseSchemaHelper(db, LoggerResolver.Current.Logger, SqlSyntaxContext.SqlSyntaxProvider); //Ensure the Redirects table exists. If not, create it if (!creator.TableExist("Redirects")) creator.CreateTable<Redirect>(false); }
internal static void CreateTables(ApplicationContext applicationContext) { //Get the Umbraco Database context var ctx = applicationContext.DatabaseContext; var db = new DatabaseSchemaHelper(ctx.Database, applicationContext.ProfilingLogger.Logger, ctx.SqlSyntax); LogHelper.Info<EasyADApplication>("Creating EasyAD tables"); //Check if the DB table does NOT exist if (!db.TableExist(AppConstants.TableNames.EasyADGroups)) { //Create DB table - and set overwrite to false db.CreateTable<EasyADGroup>(false); } //Check if the DB table does NOT exist if (!db.TableExist(AppConstants.TableNames.EasyADGroup2Users)) { //Create DB table - and set overwrite to false db.CreateTable<EasyADGroup2User>(false); } }
protected override void ApplicationStarted(UmbracoApplicationBase umbracoApplication, ApplicationContext applicationContext) { TreeControllerBase.TreeNodesRendering += TreeControllerBase_TreeNodesRendering; var ctx = ApplicationContext.Current.DatabaseContext; var db = new DatabaseSchemaHelper(ctx.Database, applicationContext.ProfilingLogger.Logger, ctx.SqlSyntax); //Check if the DB table does NOT exist if (!db.TableExist("LookWhosEditingNow")) { //Create DB table - and set overwrite to false db.CreateTable<Edit>(false); } //Install dashboard AddStartUpSectionDashboard(); }
protected override void ApplicationStarted(UmbracoApplicationBase umbracoApplication, ApplicationContext applicationContext) { //Get the Umbraco Database context var ctx = applicationContext.DatabaseContext; var db = new DatabaseSchemaHelper(ctx.Database, applicationContext.ProfilingLogger.Logger, ctx.SqlSyntax); //Check if the DB table does NOT exist if (!db.TableExist("JobsplusRegions")) { //Create DB table - and set overwrite to false db.CreateTable<Region>(false); } //Check if the DB table does NOT exist if (!db.TableExist("JobsplusDistricts")) { //Create DB table - and set overwrite to false db.CreateTable<District>(false); } //Check if the DB table does NOT exist if (!db.TableExist("JobsplusGrants")) { //Create DB table - and set overwrite to false db.CreateTable<Grant>(false); } //Check if the DB table does NOT exist if (!db.TableExist("JobsplusEmployDepartments")) { //Create DB table - and set overwrite to false db.CreateTable<EmployDepartment>(false); } //Check if the DB table does NOT exist if (!db.TableExist("JobsplusGrantDefinitions")) { //Create DB table - and set overwrite to false db.CreateTable<GrantDefinition>(false); } //Check if the DB table does NOT exist /* if (!db.TableExist("JobsplusGrantsGrantDefinitions")) { //Create DB table - and set overwrite to false db.CreateTable<GrantGrantDefinition>(false); } */ if (!db.TableExist("JobsplusGrantDefEmployDeparts")) { //Create DB table - and set overwrite to false db.CreateTable<GrantDefEmployDeparts>(false); } //Check if the DB table does NOT exist if (!db.TableExist("JobsplusSpecializations")) { //Create DB table - and set overwrite to false db.CreateTable<Specialization>(false); } //Check if the DB table does NOT exist if (!db.TableExist("JobsplusJobs")) { //Create DB table - and set overwrite to false db.CreateTable<Job>(false); } //Check if the DB table does NOT exist if (!db.TableExist("JobsplusJobTemplates")) { //Create DB table - and set overwrite to false db.CreateTable<JobTemplate>(false); } //Check if the DB table does NOT exist if (!db.TableExist("JobsplusAdvertisementReply")) { //Create DB table - and set overwrite to false db.CreateTable<AdvertisementReply>(false); } }
/// <summary> /// Modifies the database (e.g., adding necessary tables). /// </summary> /// <param name="applicationContext"> /// The application context. /// </param> private void InitializeDatabase(ApplicationContext applicationContext) { var dbContext = applicationContext.DatabaseContext; var logger = applicationContext.ProfilingLogger.Logger; var db = dbContext.Database; var dbHelper = new DatabaseSchemaHelper(db, logger, dbContext.SqlSyntax); try { dbHelper.CreateTable<FormulateSubmission>(); } catch (Exception ex) { LogHelper.Error<ApplicationStartedHandler>(TableCreationError, ex); } }