一站式网上办事大厅

using Microsoft.EntityFrameworkCore;

using System.Collections.Generic;

public class ApplicationDbContext : DbContext

{

public DbSet Applications { get; set; }

public DbSet Rankings { get; set; }

protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)

{

optionsBuilder.UseSqlServer("YourConnectionString");

}

}

public class Ranking

{

public int Id { get; set; }

public string DepartmentName { get; set; }

public int Score { get; set; }

}

]]>

public class RankingService

{

private readonly ApplicationDbContext _context;

public RankingService(ApplicationDbContext context)

{

_context = context;

}

public List GetTopDepartments(int topCount)

{

return _context.Rankings.OrderByDescending(r => r.Score).Take(topCount).ToList();

}

}

]]>