如何检查数据库中有多少记录符合ASP.NET MVC中的正确标准？

Question

当管理员在结束视图中按下“conlude”按钮时，我希望程序遍历数据库中的每条记录，并检查是否正好有2条记录（不多不少）将候选设置为true。（Rest会是假的）。我以为我可以通过计数循环来实现这一点，该循环遍历每个记录并检查候选是否设置为true或false，但是我如何在ASP.NET MVC中实现这一点？？

谢谢你抽出时间

存储过程

ALTER PROCEDURE [dbo].[conclude]
AS
BEGIN
    SET NOCOUNT ON;

    delete from dbo.Applications
    where Candidate=0
END

行动/方法

 public ActionResult Conclude(Concluded concluded, Application application)
        {
            foreach (NEA.Models.Application app in db.Applications.ToList())
            {
                if (app.Candidate.Count = 2)
                {
                    using (var context = new ApplicationDbContext())
                    {
                        var none = context.Applications.SqlQuery("dbo.removeAllButChosen");

                        return View(none);
                    }
                }
            }
                return View("Conclude");
        }

Answer 1

以下是msdn示例：

static void GetDepartments(String connectionString, Int32 year) {  
      String commandText = "dbo.GetDepartmentsOfSpecifiedYear";  

      // Specify the year of StartDate  
      SqlParameter parameterYear = new SqlParameter("@Year", SqlDbType.Int);  
      parameterYear.Value = year;  

      // When the direction of parameter is set as Output, you can get the value after   
      // executing the command.  
      SqlParameter parameterBudget = new SqlParameter("@BudgetSum", SqlDbType.Money);  
      parameterBudget.Direction = ParameterDirection.Output;  

      using (SqlDataReader reader = SqlHelper.ExecuteReader(connectionString, commandText,  
          CommandType.StoredProcedure, parameterYear, parameterBudget)) {  
         Console.WriteLine("{0,-20}{1,-20}{2,-20}{3,-20}", "Name", "Budget", "StartDate",  
             "Administrator");  
         while (reader.Read()) {  
            Console.WriteLine("{0,-20}{1,-20:C}{2,-20:d}{3,-20}", reader["Name"],  
                reader["Budget"], reader["StartDate"], reader["Administrator"]);  
         }  
      }  
      Console.WriteLine("{0,-20}{1,-20:C}", "Sum:", parameterBudget.Value);  
   }