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