private void simpleToolStripMenuItem_Click(object sender, EventArgs e)
{
var ctx = new NorthwindDataContext();
var sw = new StringWriter();
ctx.Log = sw;
var employees = from emp in ctx.Employees
where emp.LastName.StartsWith("D")
select emp;
dg.DataSource = employees;
MessageBox.Show(sw.GetStringBuilder().ToString());
}
private void lazyToolStripMenuItem_Click(object sender, EventArgs e)
{
var ctx = new NorthwindDataContext();
var sw = new StringWriter();
ctx.Log = sw;
var employee = (from emp in ctx.Employees
where emp.LastName.StartsWith("Davolio")
select emp).First();
MessageBox.Show(sw.GetStringBuilder().ToString());
sw = new StringWriter();
ctx.Log = sw;
employee.Photo.ToArray();
//var photo = new MemoryStream(employee.Photo.ToArray());
MessageBox.Show(sw.GetStringBuilder().ToString());
}