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);
        }