//To Get the list of Playable teams
public List <TblTeams> GetPlayableTeams()
{
game_dbContext context = new game_dbContext();
IQueryable <TblTeams> team = context.TblTeams.FromSqlRaw($"SELECT tblTeams.TeamID,tblTeams.TeamName FROM tblTeams JOIN tblPlayer ON tblTeams.TeamName = tblPlayer.team GROUP BY tblTeams.TeamID, tblTeams.TeamName HAVING COUNT(tblPlayer.team) >= 5");
List <TblTeams> lstTeam = team.ToList();
return(lstTeam);
}
