returning byte array from stored procedure using linq to sql

Question

i have a stored procedure which returns single column of datatype image.stored procedure is added to linq to sql class.how can i create byte array from the stored procedure using linq to sql.

stored procedure is

create procedure selecttempimage
@user_id bigint
as
begin
select user_image from Temp_Image where users_id=@user_id
end

linq to sql generated method is

[global::System.Data.Linq.Mapping.FunctionAttribute(Name="dbo.selecttempimage")]
    public ISingleResult<selecttempimageResult> selecttempimage([global::System.Data.Linq.Mapping.ParameterAttribute(DbType="BigInt")] System.Nullable<long> user_id)
{
IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), user_id);
return ((ISingleResult<selecttempimageResult>)(result.ReturnValue));
}

thanks in advance.

Answer 1

This should do it, if your Linq2Sql context is called MyDbDataContext:

using(var context = new MyDbDataContext())
{
    var byte_array = context.selecttempimage(user_id).SingleOrDefault();
    //...do something with byte_array
}

Answer 2

string givenId = "...";

var images = from Temp_Image in db.Users where users_id == givenId select user_image;

List<byte[]> image_byte_arr = new List<byte[]>();

foreach(image in images)
   image_byte_arr.Add((byte[])image.user_image);