OR Designer cannot show picture from image field

  • Hi, all:

    I tried data binding using linq to sql (OR Designer) by drag-drop from AdventureWorkDW2012.mdf , Employee table. All data could be displayed except the employeePhoto column, unlike dataset approach. I wonder if it's just the normal behavior of the technology.Can I show the picture by this approach at all, and how? Thanks in advance to any one for his/her reply. I will really appreciate it.

    Arayametee

  • I have not played with LINQ to SQL much at all and admit I don't know the OR designer. I have seen some of the SQL it generates and, while I understand it'0s very nice in writing your SQL statements for you, they certainly aren't efficient at all. Further, I've never seen a drag-and-drop designer that write SQL to perform well. I've found that there's just no substitute for writing it yourself if you want good performance.

  • Hi, Mr. or Ms. SSCrazy,

    Thank you very much for your sincere concern. You're quite right and I have the same idea as well. But I must confess to you that I am not that good, in fact, very far behind.

    On these days almost all I can do is reading what I can find from MSDN on the matter.

    Any way, at this state I just want to do by this new approach the same thing that I could do before, by dataset approach.

    Although it does seem unprofessional, but the drag-drop has its own

    favors and advantages, and very practical to some degrees.

    So, if you or anyone could throw a light on the matter, I'll really appreciate it.

    Thanks, again.

    Arayametee

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply