public static Position FindByNumber(int number)
{
var dbContext = new PowerProsDbContext();
return(dbContext.Position.FromSqlRaw("SELECT * FROM pp.Position")
.Where(p => p.Number == number)
.Single());
}
public IEnumerable <TestResponse> GetData()
{
var context = new PowerProsDbContext();
var playerParams = new PlayerParameters()
{
GlobalPlayer = new GlobalPlayer(new GlobalPlayerParameters()
{
FirstName = "Tony",
LastName = "Gwymnn",
PlayerType = PlayerType.Hitter
}),
Year = 1998,
Number = 24
};
var player = new Player(playerParams);
context.Player.Add(player);
context.SaveChanges();
var players = context.Player.ToList();
return(players.Select(p => TestResponse.ForPlayer(p)));
}
