public async Task <Player> Save(Player player)
{
const string query = @"INSERT INTO dbo.Player (Name, ZoneId, ChampionId, GameId)
VALUES
(@Name, @ZoneId, @ChampionId, @GameId);
SELECT SCOPE_IDENTITY();";
PlayerRow row = PlayerRow.FromDomain(player);
int id = row.Id;
using (var conn = new SqlConnection(_connectionStr))
{
id = (await conn.QueryAsync <int>(query, row)).First();
}
return(await GetById(id));
}
