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