entity framework, self-tracking entity and sqlserver file stream

Question

I just start a project where I need to have a WCF services that read and write files.

The architecture is based on DDD using Entity Framework Self-Tracking Entity.

The simple GUI should show a grid with a list of file and then click the row you can download it.

Can I use the file stream sql server 2008 feature with this architecture? Which strategy is the best one to manage this kind of entity?

Thanks.

Ladislav Mrnka · Accepted Answer · 2011-07-14 07:49:07Z

1

Filestream will not help you when using EF. EF doesn't use streaming feature, it loads it as varbinary(max). If you wan to take advantage of filestream you must load it from database with ADO.NET directly and you need a streaming service to pass it back to the client in efficient way.

answered Jul 14, 2011 at 7:49

Ladislav Mrnka

365k60 gold badges666 silver badges673 bronze badges

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

Collectives™ on Stack Overflow

entity framework, self-tracking entity and sqlserver file stream

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related