Invalid object name 'Application' about openiddict-core HOT 11 CLOSED

Have you tried the samples?

from openiddict-core.

I have not, i wanted to start with a clean project to start with, so i could follow everything. I can try a sample project, which one do i need, Server or Client?

from openiddict-core.

Right, i have narrowed the problem down, and found out what is causing the error. Not sure if this is my mistake, or whether the readme file needs to be updated. In a default webApplication, this appears in the startup.cs file.

if (env.IsDevelopment())
{
    app.UseBrowserLink();
    app.UseDeveloperExceptionPage();
    app.UseDatabaseErrorPage();
}
else
{
    app.UseExceptionHandler("/Home/Error");

    // For more details on creating database during deployment see http://go.microsoft.com/fwlink/?LinkID=615859
    try
    {
        using (var serviceScope = app.ApplicationServices.GetRequiredService<IServiceScopeFactory>()
            .CreateScope())
        {
            serviceScope.ServiceProvider.GetService<ApplicationDbContext>()
                 .Database.Migrate();
        }
    }
    catch { }
}

I have not got my site in development mode, so it is calling the Database.Migrate() method. I am not sure why the Application table is not created, because this is being called, but this is the reason.

Can someone shed some light on this?? I havent used EF7 yet, so not sure what is right/wrong

from openiddict-core.

Make sure your application DataSet is inside your ApplicationDbContext and the OnModelCreating has code to create the application table. If database already exists, you need create the migration code as well.

from openiddict-core.

Dbset added as tried inheriting from openid context as well as using own
and it compiles successfully.

Database didnt exist so would expect Application table to be created like
all other tables are
On 9 Jan 2016 23:41, "Yue Zhou" [email protected] wrote:

Make sure your application DataSet is inside your ApplicationDbContext and
the OnModelCreating has code to create the application table. If database
already exists, you need create the migration code as well.

—
Reply to this email directly or view it on GitHub
#44 (comment).

from openiddict-core.

This was an issue with the DI. All sorted now

from openiddict-core.

Can you explain how you sorted it out? Tried with new project and run the examples but still getting the same error. Invalid Applications object.

Thanks

from openiddict-core.

Might exists a better solution, but this fixed the issue:

public class ApplicationDbContext : IdentityDbContext
{
public ApplicationDbContext(DbContextOptions options)
: base(options)
{ }

    public DbSet<Application> Applications { get; set; }
}

Hopefully this can help others.

from openiddict-core.

Might exists a better solution, but this fixed the issue:

Nope, it's the right approach if you don't want to inherit from OpenIddictContext. It's clearly mentioned in the README:

from openiddict-core.

Thanks, I read the readme and it did help resolving the issue; however the readme does not mention if inheriting from OpenIddictContext the Applications table will not be created. Which is the issue reported.
If there is a reason why the table is not created when inheriting from OpenIddictContext I would be interested to know why. Thanks

from openiddict-core.

If there is a reason why the table is not created when inheriting from OpenIddictContext I would be interested to know why.

Hum weird. Are you sure you didn't have a pre-existing database before updating your context class to inherit from OpenIddictContext?

from openiddict-core.