090706 t understanding of LINQ

///

// a good LINQ problem
///
private void linqquestion ()
{< br> jzdatacontext DB = new jzdatacontext ();
textwriter log = new stringwriter ();
dB. log = log;

ienumerable table = dB. a_users;
var q2 = table. where (u => U. id = 1);
var users1 = q2.toarray ();
response. write (log. tostring ();
// select [t0]. [ID], [t0]. [headimagepath], [t0]. [gender], [t0]. [domainname], [t0]. [themeno], [t0]. [slob_xml], [t0]. [realname], [t0]. [birthday], [t0]. [studylevel], [t0]. [selfcomment], [t0]. [sidelineexperience], [t0]. [sidelineswanttodo], [t0]. [sidelinetime], [t0]. [sidelinecities], [t0]. [moneywant], [t0]. [race], [t0]. [speciality], [t0]. [hasgraduated], [t0]. [collegeid]
// from [DBO]. [a_users] as [t0]
// -- Context: sqlprovider (SQL2000) model: attributedmetamodel build: 3.5.30729.1

Log = new stringwriter ();
DB. log = log;
VaR q = dB. a_users.where (u => U. ID = 1 );
VaR users2 = Q. toarray ();
Response. Write (log. tostring ());
// Select [t0]. [ID], [t0]. [headimagepath], [t0]. [gender], [t0]. [domainname], [t0]. [themeno], [t0]. [slob_xml], [t0]. [realname], [t0]. [birthday], [t0]. [studylevel], [t0]. [selfcomment], [t0]. [sidelineexperience], [t0]. [sidelineswanttodo], [t0]. [sidelinetime], [t0]. [sidelinecities], [t0]. [moneywant], [t0]. [race], [t0]. [speciality], [t0]. [hasgraduated], [t0]. [collegeid]
// From [DBO]. [a_users] as [t0]
// Where [t0]. [ID] = @ P0
// -- @ P0: Input int (size = 0; prec = 0; scale = 0) [1]
// -- Context: sqlprovider (SQL2000) model: attributedmetamodel build: 3.5.30729.1
}