Saving .wav file in SQL Server database

[fahdrashid]

Can somebody plz guide me how can i save a .wav sound file in SQL Server database. One possible that i figured out was to save the address of the folder where i place my sound file and sav the link in the DB, but it is not wanted by the by my course supervisor. They want me to save it in MS SQL Server DB...the whole sound file. Kindly anyone of you help me ASAP.

thnx

Fahd

[sagey]

others on this forum migth disagree but as far as i am concerned saving binary data to a database is (almost) always a bad idea.
For example do a google on storing images in sql server and see how many times people say its a bad idea.

if i were you i would go down the route you thought of. hold the path to the binary in the db.

if you really have to save the wav to the db i think you would need to make the field a byte data type (or something like that) and then convert the wav file to a byte array (using a stream?)

sorry i can't be more help. as i said i wouldn't do it.

[hellswraith]

I don't disagree at all, I 100 percent agree with sagey.