public async Task <Season> CreateAsync() { using (var cmd = m_session.CreateCommand()) { cmd.CommandText = @"INSERT INTO Season OUTPUT inserted.* DEFAULT VALUES"; using (var reader = await cmd.ExecuteReaderAsync()) { if (await reader.ReadAsync()) { var result = await reader.MapToTypeAsync <Season>(); return(result); } } } throw new Exception("failed to create season"); }
public async Task <Team> CreateAsync(Team team) { using (var cmd = m_session.CreateCommand()) { cmd.CommandText = @"INSERT INTO Team (Name) OUTPUT inserted.* VALUES (@name)"; cmd.Parameters.Add("name", SqlDbType.Text).Value = team.Name; using (var reader = await cmd.ExecuteReaderAsync()) { if (await reader.ReadAsync()) { var result = await reader.MapToTypeAsync <Team>(); return(result); } } } throw new Exception("failed to create team"); }
public async Task <SeasonMembership> CreateAsync(long team, long season) { using (var cmd = m_session.CreateCommand()) { cmd.CommandText = @"INSERT INTO SeasonMembership (TeamId, SeasonId) OUTPUT inserted.* VALUES (@team, @season)"; cmd.Parameters.Add("team", SqlDbType.BigInt).Value = team; cmd.Parameters.Add("season", SqlDbType.BigInt).Value = season; using (var reader = await cmd.ExecuteReaderAsync()) { if (await reader.ReadAsync()) { var result = await reader.MapToTypeAsync <SeasonMembership>(); return(result); } } } throw new Exception("failed to create season membership"); }