copy files from sql to local drive

Question

hey people.. 

I have a table in sql server which contains the info of the files that are uploaded. 

it has the id, name, size, content, created dt and the modified dt of all the files. 

now my task is that i wanna copy the files from the db to my local drive. 

is it possible thru C# console application..

please help..

thanks in advance,

Abinaya