最近写的各种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 = Nothing Dim Message As XElement = Nothing Message = (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();