linq小实例
2015-03-09 16:32 hf_sun 阅读(133) 评论(0) 编辑 收藏 举报var cus = from u in context.IPPhoneInfo
join r in context.Organization on u.OrgStructure equals r.MinusOraID
where r.ISfalse.Equals(true) && u.IsFault.Equals(false)
select new {
Organizationid = r.Organizationid,
OrganizationName = r.OrganizationName,
IPPhoneInfoID = u.IPPhoneInfoID,
PhoneMAC = u.PhoneMAC,
PhoneModel = u.PhoneModel,
PhoneSN = u.PhoneSN,
PurchasesTime = u.PurchasesTime,
OrgStructure = u.OrgStructure,
PhoneStauts = u.PhoneStauts,
GuaranteeTime = u.GuaranteeTime,
IsFault = u.IsFault
};
var use = from u in context.User
select u;