最近写的各种Linq实例,to xml,to dataset,to object

Linq to Xml:

===========================================================

<?xml version="1.0" standalone="yes"?><Messages> <!-- Common Error Message --> <Message> <MessageID>9</MessageID> <MessageName>ExitApplicationConfirmation</MessageName> <MessageNumber></MessageNumber> <ClassName></ClassName> <Message>Do you really want to exit?</Message> </Message></Messages> 

C#:

XElement xe = null;XElement Message = null;xe = XElement.Load(mstrStorage);Message = xe.Descendants("Message") .Where(x => (string)x.Element("MessageName") == mstrMessageName && (string)x.Element("MessageNumber") == mintMessageNumber.ToString() && (string)xe.Element("ClassName") == mstrClassName ).SingleOrDefault(); 

VB.NET

Dim xe As XElement = NothingDim Message As XElement = NothingMessage = (From msg In xe...<Message> _ Where msg.<MessageName>.Value = mstrMessageName _ And msg.<MessageNumber>.Value = mintMessageNumber.ToString() _ And msg.<ClassName>.Value = mstrClassName _ Select msg).SingleOrDefault() 

Linq to DataSet

===========================================================

DataRow row = (from s in subInventory.AsEnumerable() where s.Field<string>("Subinventory") == Subinventory select s).Single<DataRow>(); 

Linq to Object

===========================================================

// GetAllSubInventorySpecial 方法返回List<Object> 对象集合 _subinventorySpecial = _inventoryService.GetAllSubInventorySpecial(false); return _subinventorySpecial.Where(x => x.PartNumber == PartNumber && x.Subinventory == Subinventory).SingleOrDefault();