8

Is it possible to handle (read and write) binary data to SQL Server using Entity Framework 4.0 using streams? (i.e.: not the whole content shipped in a byte array)

An example could be taken from Download and Upload images from SQL Server via ASP.Net MVC which illustrates the way to stream nicely data from SQL Server in an example available for ASP.NET MVC. However it requires direct access to the DB and I am curious whether this could be done using an ORM.

Andrei Rînea
  • 20,288
  • 17
  • 117
  • 166

1 Answers1

6

Unfortunately, this is not supported in Entity Framework 4. You'll need to work directly with the database.

I can't see it happening anytime soon either, since an ORM that didn't materialise objects fully in memory would have a lot of complications.

James

James World
  • 29,019
  • 9
  • 86
  • 120
  • If I am using Oracle 11g Client and Entity framework v4.0.30319, is there any issue to deal with in this case ? What about if we use Entity SQL ? – Jeff Bootsholz Jan 11 '13 at 02:38