How to store images using Entity Framework Code First CTP 5?

You can't use SQL FILESTREAM in EF. EF is supposed to work on top of different database servers but filestream feature is specific feature of SQL 2008 and newer. You can try to do it old way - use varbinary(max) in your database table and use byte array in your mapped class.

You can't use SQL FILESTREAM in EF. EF is supposed to work on top of different database servers but filestream feature is specific feature of SQL 2008 and newer. You can try to do it old way - use varbinary(max) in your database table and use byte array in your mapped class.

Edit: Little clarification - you can use FILESTREAM in the database but EF will not take advantage of streaming. It will load it as standard varbinary(max).

Just declare your property as byte as Ladislav mentioned. Public class Product { public int Id { get; private set; } public string Name { get; set; } public byte ProductImage { get; set; } } That is pretty much it. If you don't map the property the convention is it maps to a varbinary(max).

If you have an image column in the database already just add Column(TypeName = "image") on the ProductImage property or if you prefer code mapping add this to your OnModelCreating override in the context class: modelBuilder.Entity(). Property(p => p. Image).

HasColumnType("image"); The problem I have with it is that I have not found a way to make the property lazy as I don't necessarily want to load binary data every time I fetch a product. I not sure I recall correctly but Nbernate can do it out of the box.

I always create anothre class like ProductImage with one to one accosiation in order to manage lazy loadin and also Normalize table :) public class ProductImage { public int ProductId { get; private set; } public byte Image { get; set; } }.

Just declare your property as byte as Ladislav mentioned.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.