List users = new List {};
using (var conn = new ForTest_shengbiao0804cEntities())
{
var query = conn.User;
var q = from u in query
where u.CallId == 1
select new { u.CallId, u.Name, u.Email, u.Password, u.Phone, u.Tel };
//foreach (var i in q) //隱藏的查詢
//{
//}
var result = q.ToList();
}
如何將查詢到的值賦給users
var q = from u in query
where u.CallId == 1
select new users { u.CallId, u.Name, u.Email, u.Password, u.Phone, u.Tel };