public Referral GetReferral(string referralTitle) { Referral referral; _dbConnection.Open(); using (var transaction = _dbConnection.BeginTransaction()) { referral = _referralRepository.GetReferral( _dbConnection, referralTitle.ToLower()); transaction.Commit(); } _dbConnection.Close(); return(referral); }