public long GetId(string screenName) { // synchronized read var sql = "select Id from " + TableName + " where LOWER(ScreenName) = @ScreenName limit 1;"; try { using (Descriptor.AcquireReadLock()) using (var con = Descriptor.GetConnection()) { return(con.Query <long>(sql, new { ScreenName = screenName.ToLower() }) .SingleOrDefault()); } } catch (Exception ex) { throw DatabaseConnectionHelper.WrapException(ex, "GetId", sql); } }
private DatabaseManagement GetValueCore(long id) { // synchronized read var sql = this.CreateSql("Id = @Id"); try { using (Descriptor.AcquireReadLock()) using (var con = Descriptor.GetConnection()) { return(con.Query <DatabaseManagement>(sql, new { Id = id }) .SingleOrDefault()); } } catch (Exception ex) { throw DatabaseConnectionHelper.WrapException(ex, "GetValueCore", sql); } }