Entity Framework 4.0 BLOB Processing in Stream Mode

Question

Is it possible to process (read and write) binary data on SQL Server using Entity Framework 4.0 using threads? (i.e.: not all content sent to the byte array)

An example can be taken from Uploading and uploading images from SQL Server through ASP.Net MVC , which illustrates how to get good data from SQL Server in an example available for ASP.NET MVC. However, this requires direct access to the database, and I wonder if this can be done using ORM.

Answer 1

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

I also don’t see that this will happen in the near future, since ORM, which does not fully materialize objects, will have many complications.

James