Example: Simple way to save and fetch binary data to/from files using linqpad

SaveBinaryDataAsFile.linq

//Set Language to "C# Program" in linqPad

void Main()
{
	var peopleWithPics =  TblPersons  
				.Where(p => p.ProfilePicture != null)
				.Select(p => new { p.PersonID, p.ProfilePicture });
 
 	foreach(var p in peopleWithPics) 
	{
  		System.IO.File.WriteAllBytes(
			Path.Combine(@"D:\temp\", p.PersonID.ToString() + ".jpg"), 
   				p.ProfilePicture.ToArray());
   	}
}

SaveFileIntoBinaryColumn.linq

//Set Language to "C# Program" in linqPad

void Main()
{

	var file = System.IO.File.ReadAllBytes(@"D:\temp\4980.jpg");
	
	var person = TblPersons.First(p => p.PersonID == 5025);
	
	person.ProfilePicture = file;
	
	SubmitChanges();
	
}