// GET api/GetGames public IQueryable<GameInfo> Get() { string commandText = "SELECT games.id, User1, User2, Board, GameResult, " + "CurrentPlayerIndex, users1.UserName AS User1Name, " + "users2.UserName AS User2Name FROM games " + "JOIN users users1 ON (games.User1 = users1.id) " + "JOIN users users2 ON (games.User2 = users2.id) " + "WHERE games.GameResult = 0 " + "AND (games.User1 = @p0 OR games.User2 = @p1)"; TicTacToeMobileServiceContext dataContext = new Models.TicTacToeMobileServiceContext(); string userKey = this.Request.GetQueryNameValuePairs() .Where(kvp => kvp.Key == "UserKey").First().Value; Services.Log.Info("GetGamesForUser: userkey = " + userKey); var query = dataContext.Database.SqlQuery<GameInfo>( commandText, userKey, userKey); var games = query.ToList(); Services.Log.Info("GetGamesForUser: count = " + games.Count()); return games.AsQueryable<GameInfo>(); }
// GET api/GetGames public IQueryable <GameInfo> Get() { string commandText = "SELECT games.id, User1, User2, Board, GameResult, " + "CurrentPlayerIndex, users1.UserName AS User1Name, " + "users2.UserName AS User2Name FROM games " + "JOIN users users1 ON (games.User1 = users1.id) " + "JOIN users users2 ON (games.User2 = users2.id) " + "WHERE games.GameResult = 0 " + "AND (games.User1 = @p0 OR games.User2 = @p1)"; TicTacToeMobileServiceContext dataContext = new Models.TicTacToeMobileServiceContext(); string userKey = this.Request.GetQueryNameValuePairs() .Where(kvp => kvp.Key == "UserKey").First().Value; Services.Log.Info("GetGamesForUser: userkey = " + userKey); var query = dataContext.Database.SqlQuery <GameInfo>( commandText, userKey, userKey); var games = query.ToList(); Services.Log.Info("GetGamesForUser: count = " + games.Count()); return(games.AsQueryable <GameInfo>()); }