0

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
  • 360,892
  • 59
  • 660
  • 670
Andrea
  • 803
  • 1
  • 12
  • 27

1 Answers1

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.

Ladislav Mrnka
  • 360,892
  • 59
  • 660
  • 670