CODE EXAMPLE FOR CSHARP

only specific columns in Linq

using (var context = new LINQEntities())
            {
                var fileCollection = context.FileRepository.Where(a => a.IsDeleted == false).
                    Select(a => new
                    {
                        FilePath = a.FilePath
                    }
                ).ToList();
            }