protected void Page_Load(object sender, EventArgs e)
{ using (PlaygroundDataContext db =
new PlaygroundDataContext())
{ List<Member> lst = new List<Member>();
var m = (from o in db.Members
where o.UserId == 1
select o).First();
lst.Add(m);
//借用Member類別，承接ExecuteQuery的結果
var n =
db.ExecuteQuery<Member>(@"
select 1 as UserId, 'Jeffrey' as UserName,
'ZZZ' as Code, getdate() as RegTime UNION
select 2 as UserId, 'Ninja' as UserName,
'XXX' as Code, getdate() as RegTime"
).ToArray();
lst.AddRange(n);
var r = (from o in db.Members
where o.UserId == 2
select o).First();
lst.Add(r);
//猜看看，結果是什麼?
foreach (var o in lst)
Response.Write(
string.Format("<li>{0}|{1}|{2}|{3:yyyy/MM/dd HH:mm}" , o.UserId, o.UserName, o.Code, o.RegTime));
}
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{ List<Member> lst = new List<Member>();
using (PlaygroundDataContext db =
new PlaygroundDataContext())
{ var m = (from o in db.Members
where o.UserId == 1
select o).First();
lst.Add(m);
var r = (from o in db.Members
where o.UserId == 2
select o).First();
lst.Add(r);
}
using (PlaygroundDataContext db =
new PlaygroundDataContext())
{ //借用Member類別，承接ExecuteQuery的結果
var n =
db.ExecuteQuery<Member>(@"
select 1 as UserId, 'Jeffrey' as UserName,
'ZZZ' as Code, getdate() as RegTime UNION
select 2 as UserId, 'Ninja' as UserName,
'XXX' as Code, getdate() as RegTime"
).ToArray();
lst.AddRange(n);
}
//猜看看，結果是什麼?
foreach (var o in lst)
Response.Write(
string.Format("<li>{0}|{1}|{2}|{3:yyyy/MM/dd HH:mm}", o.UserId, o.UserName, o.Code, o.RegTime));
Response.End();
}