protected VLSystemUserView ExecuteAndGetSystemUserView(DbCommand cmd) { VLSystemUserView _retObject = null; try { cmd.Connection.Open(); using (DbDataReader reader = cmd.ExecuteReader()) { if (reader.HasRows == false) { return(null); } reader.Read(); _retObject = new VLSystemUserView(reader); } } finally { cmd.Connection.Close(); } return(_retObject); }
protected Collection <VLSystemUserView> ExecuteAndGetSystemUserViews(DbCommand cmd) { var collection = new Collection <VLSystemUserView>(); try { cmd.Connection.Open(); using (DbDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { var _object = new VLSystemUserView(reader); collection.Add(_object); } } } finally { cmd.Connection.Close(); } return(collection); }