While reviewing LINQ TO SQL with a colleague recently I discovered yet another "hickup" in v 1.0 of LINQ TO SQL.

I did a search for uploading an image (or any file) using LINQ TO SQL and could not find a blog or article. Here is a quick note on how to do this. The following code assumes that you have a "FileUpload" control on your webform. I'm using a stored procedure to add a row to my "Users" table. I have a column named "Photo". The sql server datatype for Photo column is "Image".

Earlier this week I ran into a problem with LINQ and building a Dynamic query. The issue is I wanted to build a search string based on the data in my function parameters.