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))); }