public static int Create(UserModel user, EntityDecisionOption option, int votepower) => ExecuteScalarInt( @"INSERT INTO entity_decision_votes(guid, user_id, option_id, votepower) VALUES (@guid, @user_id, @option_id, @votepower); SELECT currval('entity_decision_votes_id_seq');" , new { guid = Guid.NewGuid().ToString(), user_id = user.id, option_id = option.id, votepower } );
public static EntityDecisionVote Find(UserModel user, EntityDecisionOption option) => Connection().Query <EntityDecisionVote>( "SELECT * FROM entity_decision_votes WHERE user_id = @user_id AND option_id = @option_id LIMIT 1", new { user_id = user.id, option_id = option.id } ).FirstOrDefault();