Return a Join to a view
Question
Answers
-
User-893317190 posted
Hi tmatiwure,
I use my model to make a test and it works well . It seems the error is caused be your database , are you sure that you have WeekId and WeekEnding column in your database?
My model
public partial class Category { public int CategoryID { get; set; } [Required] [StringLength(15)] public string CategoryName { get; set; } [Column(TypeName = "ntext")] public string Description { get; set; } } public partial class Product { public int ProductID { get; set; } [Required] [StringLength(40)] public string ProductName { get; set; } public int? CategoryID { get; set; } }My dbContext.
public partial class EntityDb1 : DbContext { public EntityDb1() : base("name=EntityDb1") { } public virtual DbSet<Product> Products { get; set; } public virtual DbSet<Category> Categories { get; set; } protected override void OnModelCreating(DbModelBuilder modelBuilder) { modelBuilder.Entity<Product>() .Property(e => e.UnitPrice) .HasPrecision(19, 4); } }My joinView.
public class JoinView { public Product product { get; set; } public Category category { get; set; } }My controller.
public ActionResult Join() { EntityDb1 db1 = new EntityDb1(); EntityDb1 db2 = new EntityDb1(); IEnumerable<Product> products = db1.Products; IEnumerable<Category> categories = db2.Categories; var result = from pro in products join ca in categories on pro.CategoryID equals ca.CategoryID select new JoinView { product = pro, category=ca }; return View(result); }My view.
@model IEnumerable<MVCLearning.Models.JoinView> @{ ViewBag.Title = "Join"; } <h2>Join</h2> <table class="table table-striped"> <tr> <td>ProductID </td> <td>ProductName</td> <td>CategoryID</td> <td>CategoryName</td> </tr> @foreach (var item in Model) { <tr> <td>@item.product.ProductID</td> <td>@item.product.ProductName</td> <td>@item.category.CategoryID</td> <td>@item.category.CategoryName</td> </tr> } </table>And the result.
Best regards,
Ackerly Xu
- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
All replies
-
User-893317190 posted
Hi tmatiwure,
I use my model to make a test and it works well . It seems the error is caused be your database , are you sure that you have WeekId and WeekEnding column in your database?
My model
public partial class Category { public int CategoryID { get; set; } [Required] [StringLength(15)] public string CategoryName { get; set; } [Column(TypeName = "ntext")] public string Description { get; set; } } public partial class Product { public int ProductID { get; set; } [Required] [StringLength(40)] public string ProductName { get; set; } public int? CategoryID { get; set; } }My dbContext.
public partial class EntityDb1 : DbContext { public EntityDb1() : base("name=EntityDb1") { } public virtual DbSet<Product> Products { get; set; } public virtual DbSet<Category> Categories { get; set; } protected override void OnModelCreating(DbModelBuilder modelBuilder) { modelBuilder.Entity<Product>() .Property(e => e.UnitPrice) .HasPrecision(19, 4); } }My joinView.
public class JoinView { public Product product { get; set; } public Category category { get; set; } }My controller.
public ActionResult Join() { EntityDb1 db1 = new EntityDb1(); EntityDb1 db2 = new EntityDb1(); IEnumerable<Product> products = db1.Products; IEnumerable<Category> categories = db2.Categories; var result = from pro in products join ca in categories on pro.CategoryID equals ca.CategoryID select new JoinView { product = pro, category=ca }; return View(result); }My view.
@model IEnumerable<MVCLearning.Models.JoinView> @{ ViewBag.Title = "Join"; } <h2>Join</h2> <table class="table table-striped"> <tr> <td>ProductID </td> <td>ProductName</td> <td>CategoryID</td> <td>CategoryName</td> </tr> @foreach (var item in Model) { <tr> <td>@item.product.ProductID</td> <td>@item.product.ProductName</td> <td>@item.category.CategoryID</td> <td>@item.category.CategoryName</td> </tr> } </table>And the result.
Best regards,
Ackerly Xu
- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
-
User-164452226 posted
Hi tmatiwure,
I use my model to make a test and it works well . It seems the error is caused be your database , are you sure that you have WeekId and WeekEnding column in your database?
My model
public partial class Category { public int CategoryID { get; set; } [Required] [StringLength(15)] public string CategoryName { get; set; } [Column(TypeName = "ntext")] public string Description { get; set; } } public partial class Product { public int ProductID { get; set; } [Required] [StringLength(40)] public string ProductName { get; set; } public int? CategoryID { get; set; } }My dbContext.
public partial class EntityDb1 : DbContext { public EntityDb1() : base("name=EntityDb1") { } public virtual DbSet<Product> Products { get; set; } public virtual DbSet<Category> Categories { get; set; } protected override void OnModelCreating(DbModelBuilder modelBuilder) { modelBuilder.Entity<Product>() .Property(e => e.UnitPrice) .HasPrecision(19, 4); } }
My joinView.
public class JoinView { public Product product { get; set; } public Category category { get; set; } }
My controller.
public ActionResult Join() { EntityDb1 db1 = new EntityDb1(); EntityDb1 db2 = new EntityDb1(); IEnumerable<Product> products = db1.Products; IEnumerable<Category> categories = db2.Categories; var result = from pro in products join ca in categories on pro.CategoryID equals ca.CategoryID select new JoinView { product = pro, category=ca }; return View(result); }
My view.
@model IEnumerable<MVCLearning.Models.JoinView> @{ ViewBag.Title = "Join"; } <h2>Join</h2> <table class="table table-striped"> <tr> <td>ProductID </td> <td>ProductName</td> <td>CategoryID</td> <td>CategoryName</td> </tr> @foreach (var item in Model) { <tr> <td>@item.product.ProductID</td> <td>@item.product.ProductName</td> <td>@item.category.CategoryID</td> <td>@item.category.CategoryName</td> </tr> } </table>
And the result.
Best regards,
Ackerly Xu
This was a great eye opener for me. l simply hat to combine this with the above suggestions and it yielded results
