francesco abbruzzese

ok if both id and name are in the same table you just don't need name, id is enough to retrieve the whole table record. So you can put just the id in your LinQ where clause.

The Linq clause will load the whole DB row, including the BLOB that contains your video.

Once obtained the Binaries of the video you may use it as return value for some action method of a controller As FileResult. 

If you want to display a page that has both the video and othe information, just display the page containing all information and put inside it some plug-in that is able to play videos (for instance a silverlight program) passing to the plugin an url that point to the action method that returns the FileResult with the video inside it.

Hi, thanks ,

 I'm afraid I did not explain what I need clear,

(or I just didn’t understand  your answer   ),

I'm trying to load like in you tube that when I movie is selected a list of movies with  the same subject are  displayed

( I able display movie on my site)

thanks