public int Create(Models.RoundPlayerCard item)
{
RoundPlayerCard roundPlayerCard = Mapper.ToEntity(item);
_context.RoundPlayerCards.Add(roundPlayerCard);
_context.SaveChanges();
return(roundPlayerCard.Id);
}
public int Create(Models.RoundPlayerCard item)
{
var sqlQuery = @"INSERT INTO RoundPlayerCards (NumberCard, RoundPlayerId, CardId)
VALUES(@NumberCard, @RoundPlayerId, @CardId); SELECT CAST(SCOPE_IDENTITY() as int)";
using (var connection = new SqlConnection(_connectionString))
{
int?id = connection.QuerySingle <int>(sqlQuery, item);
return(id.Value);
}
}
