Base solution for your next web application

Activities of "Kelly"

Are you sure? if I create a table in my database that does not have a custom Schema like Marketing.Categories , but rather just dbo.Table1 it shows up (and only that table). if I rename Table1 to dbo.Categories so that I have a table dbo.Categories and Marketing.Categories, then two tables show up to pick.

I was able to resolve this by adding the following to OnModelCreating();

        modelBuilder.Entity<AuditLog>()
            .ToTable("AuditLogs", "Application")
            .Property(x => x.Id)
            .HasDefaultValueSql("NEXT VALUE FOR [Sequences].[AuditLogId]");

If anyone knows a better way to handle this, please comment. I have over 100 tables in this database, so this will get a little tedious.

Showing 1 to 2 of 2 entries