EF Core 3 DbQuery equivalent functionality

.net-core c# ef-core-3.0 ef-core-3.1 entity-framework-core

Question

In ef core 2.2 I have used DbQuery to map raw sql results to object as following:

public partial class AppDbContext{
    public DbQuery<SimpleQueryModel> SimpleQM {get;set;}
}

and then

var result=_dbContext.SimpleQM.FromSql(sqlString,params);

this wouldn't create any extra table and working just fine. In ef core 3.1 DbQuery is obsolete and telling me to use keyless DbSet instead. I have configured it as following:

public partial class AppDbContext{
    public DbSet<SimpleQueryModel> SimpleQM {get;set;}
}

and in ModelCreating

builder.Entity<SimpleQueryModel>().HasNoKey();

but this will create a new table in new DB migration and if I tell ef to Ignore this entity as following

builder.Entity<SimpleQueryModel>().HasNoKey().Ignore();

I can't use _dbContext.SimpleQM.FromSqlRaw(); this will throw an exception and telling that the model is not included in the Context. how can I achieve same functionality in ef core 3.1?

1
2
12/20/2019 3:55:15 PM

Accepted Answer

Problem solved! just used this configuration.

builder.Entity<SimpleQueryModel>().HasNoKey().ToView("view_name_that_doesnt_exist");
5
12/20/2019 7:13:10 PM


Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow