List method does not return objects

Question

List method does not return objects

Navigation

#1 by (1 votes)

0

Method with EF List

internal List<Arquivo> GetAllArquivo()
    {
        using (var ctx = new TESTEntities())
        {
            var arquivos = (
                    from ver in ctx.ARQUIVO
                    select new Arquivo()
                    {
                        ARQUIVO_GUID = ver.ARQUIVO_GUID,
                        XARQUIVO = ver.XARQUIVO,
                        TAG = ver.TAG,
                        URL = ver.URL,
                        EXTENSAO = ver.EXTENSAO,
                        IS_STREAM = ver.IS_STREAM,
                        ULT_ARQUIVO_VERSAO_GUID = ver.ULT_ARQUIVO_VERSAO_GUID,
                        TIPO_DE_ARQUIVO_GUID = ver.TIPO_DE_ARQUIVO_GUID,
                        DIRETORIO_GUID = ver.DIRETORIO_GUID
                    }
                ).ToList();

            return arquivos;
        }
    }

I want to access the method data to return a specific object: ex:

meuDal.GetAllArquivo().XARQUIVO

But you can not find anything, I have other list methods that work, and that does not.

c# entity-framework

asked by anonymous 10.02.2015 / 12:37

1 answer

Ignore certain values in MySQL How to sum the values of a specific column with the sum () function?

score 1 · Accepted Answer

When you call meuDal.GetAllArquivo() it returns a list of files, if you want to get 1, do meuDal.GetAllArquivo().FirstOrDefault().XARQUIVO

It will return the first record in the list,

If you want a specific one, you can do this:

meuDal.GetAllArquivo().Where(a => a .ARQUIVO_GUID == 'uid').FirstOrDefault().XARQUIVO