FluentNHibernate mapping settings - file storage in SQL Server database?

You can also map Custom i. FileContents).Custom() I've mapped files stored as binary, but they weren't the 'image' type I did a quick google search and found a post with an ImageUserType which you could try to specify instead weblogs.asp.net/ricardoperes/archive/200... edit. This user type looks a lot better: martinwilley.com/net/code/nhibernate/use....

You can also map Customs to N Type types For instance: Map(i => i. FileContents).Custom(); I've mapped files stored as binary, but they weren't the 'image' type. I did a quick google search and found a post with an ImageUserType which you could try to specify instead.

weblogs.asp.net/ricardoperes/archive/200... edit. This user type looks a lot better: martinwilley.com/net/code/nhibernate/use....

You don't need a custom type. Here is a mapping that works for a SQL Server image column named Content: Map(x => x. Content); Here is usage of that mapping: byte content = nhSession.CreateCriteria() .

Add(ac => ac. Id == 3) . SetProjection(Projections.

Property("Content")) .UniqueResult(); ...and here's a way to get it out without a mapping (AttachmentDTO is not a mapped NH class, just a normal class) : nhSession. CreateSQLQuery("select a. Content from Attachments a where a.Id = 1") .

SetResultTransformer(Transformers. AliasToBean(typeof(AttachmentDTO))) .UniqueResult(); Here's the DTO class: public class AttachmentDTO { public int Id { get; set; } public string ContentType { get; set; } public byte Content { get; set; } } Good luck!

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.