asp.net core code first

Question

I need to call 3 diferents views from my db context, but 3 views return sameview model.so how to declare 3 views and retund types in context class and onmodel builder creating.

public virtual DbSet<VwM> View1 { get; set; }
public virtual DbSet<VwM> View2 { get; set; }
public virtual DbSet<VwM> View3{ get; set; }

modelBuilder.Entity<VwM>().ToView($"{nameof(this.View1 )}");
modelBuilder.Entity<VwM>().ToView($"{nameof(this.View2 )}");
modelBuilder.Entity<VwM>().ToView($"{nameof(this.View3)}"); this code didnt work

Amit Mohanty · Answer

You cannot use the same entity type ( VwM ) to map to multiple views in the same DbContext . However, you can create a separate class for each view, even though they have the same model. public class View1M { // Properties that match the columns of View1 } public class View2M { // Properties that match the columns of View2 } public class View3M { // Properties that match the columns of View3 } public virtual DbSet View1 { get; set; } public virtual DbSet View2 { get; set; } public virtual DbSet View3 { get; set; } modelBuilder.Entity ().ToView("View1"); modelBuilder.Entity ().ToView("View2"); modelBuilder.Entity ().ToView("View3");

Tuhin Paul · Answer

Part 2 In your DbContext class, create a DbSet for each view and map it to the corresponding model class: public virtual DbSet View1 { get; set; } public virtual DbSet View2 { get; set; } public virtual DbSet View3 { get; set; } protected override void OnModelCreating(ModelBuilder modelBuilder) { modelBuilder.Entity ().ToTable("View1"); modelBuilder.Entity ().ToTable("View2"); modelBuilder.Entity ().ToTable("View3"); } Now you can query each view using the corresponding DbSet: var view1Data = context.View1.ToList(); var view2Data = context.View2.ToList(); var view3Data = context.View3.ToList();

Tuhin Paul · Answer

Part 1 Create separate model classes for each view: public class View1Model { public int Id { get; set; } public string Name { get; set; } // Add other properties as needed } public class View2Model { public int Id { get; set; } public string Name { get; set; } // Add other properties as needed } public class View3Model { public int Id { get; set; } public string Name { get; set; } // Add other properties as needed }

Tuhin Paul · Answer

You cannot declare multiple DbSets with the same model type in your DbContext class as it will cause conflicts. Instead, you can create separate model classes for each view and map them accordingly in your DbContext's OnModelCreating method.