LINQ : saving files to a database

I want to save a pdf and mp3 file(s) to a SQL Server database and be able to retrieve from it. I'm still startin开发者_JAVA百科g out with LINQ and don't master it yet.

---

You need to convert these into byte arrays (System.Data.Linq.Binary). One line to load

var myMp3 = new Binary(File.ReadAllBytes(mp3Filename));

If you create your database schema (VarBinary in the database) and drag the table over from Server Explorer into the DBML designer, it'll do everything for you.

---

To start off with your going to have a binary field in your database to save the file to.

Are you using LinqToSql, EntityToSql, or? Need some more information...

But once you get an object with a []byte to save the file to then it just a matter of making the appropriate Save() call... but with having some more information it hard to say.

Did you google tutorials?

Here is one that I found: Uploading Binary files or Images using LINQ to SQL

Has example code and sql to generate dummy tables...