Entity Framework - Data Access Tips

Question

I am working on a project using EF6 with C#, in one of my classes I have to save a file, example below:

   public partial class Arquivo
    {
        [Key]
        public int ArquivoID { get; set; }

        public string Nome { get; set; }
        public byte[] ArquivoFisico { get; set; }
        public string TipoArquivo { get; set; }
     }

my problem is in the property arquivofisico when I consult data from other classes that are linked to this would not like it to load the property arquivofisico, because I can have files of 5, 10 MB, the memory of my server will burst if there are many classes... I want to access this property only when using a Handler generic to download. Have any hints to do this or I have to use Lazy loading same?

Thanks for the Help.

Answer 1

Have any hints to do this or I have to use Lazy loading same?

Do not materialize the column when selecting. Do as follows:

var arquivos = db.Arquivos
                 .Where(...)
                 .Select(a => new { 
                                    a.ArquivoID, 
                                    a.Nome, 
                                    a.TipoArquivo })
                 .ToList();