Load File using Entity Framework

Question

Right now I have file upload/download through Entity Framework working but I see an issue coming up. In the scenario when i want to get a list of all the files associated with a record, I don't want it to pull the Data property, just the FileId and Name, because the files can be up to 10MB each.

I have LazyLoading disabled so I'm thinking about putting the Data column into another table and only load the data when I want. That way I can just supply a link to a controller with the FileId I want to download. But maybe there is a better way? All suggestions are appreciated. Thanks!

My File entity has the following properties:

FileId
FkRecord
Name
Data

Community · Accepted Answer · 2017-05-23 11:47:55Z

2

you do not need to put data column in another table - just create another entity in the designer and move you [Data] column in it. don't forget to create corresponding table mapping in designer - map you data column to the column in db table.

Also create 1 to 1 association between entities. And you could use navigational properties and do not need to alter you db table!

I found similar discussion: Can I lazy load scalar properties with the ADO.Net Entity Framework?

edited May 23, 2017 at 11:47

CommunityBot

11 silver badge

answered Aug 15, 2011 at 18:50

objectbox

1,2811 gold badge11 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

MisterIsaak Over a year ago

Thanks! This was exactly what I needed, I guess I just wasn't typing in the correct magic search phrases into SO.

Collectives™ on Stack Overflow

Load File using Entity Framework

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related