Display Specific Value in View ASP.NET CORE

Question

For my website, I am able to display every detail of the Account Table in my database. My AccountStatus has 2 values inside the database; "Approved" and "Rejected". However, I want to display the details on my website only if the value of the AccountStatus is "Approved".

I am currently using ASP.net core MVC with EF core and SQL server.

Model:

public class AccountModel
   {
       [Key]
       public Guid AccountID { get; set; }

       public DateTime AccountCreationDateTime { get; set; }

       public string AccountStatus { get; set; }
   }

Controller:

public async Task<IActionResult> Account()
       {
           return View(await _context.Account.ToListAsync());
       }

Wouter · Accepted Answer · 2020-07-10 11:45:52Z

2

public async Task<IActionResult> Account()
       {
           return View(await _context.Account.Where(s => s.AccountStatus == "Approved").ToListAsync());
       }

I would advice you to learn some more about the basics of queries an linq: https://www.entityframeworktutorial.net/efcore/querying-in-ef-core.aspx

PS: Better to put your AccountStatus in a seperate table instead of using a string

answered Jul 10, 2020 at 11:45

Wouter

1,3633 gold badges18 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

addsw Over a year ago

Sorry, I am new to Asp.net. Why is it better to put the AccountStatus in a separate table?

Collectives™ on Stack Overflow

Display Specific Value in View ASP.NET CORE

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related