Linq sample

XML

             ... {
                XDocument doc = XDocument.Load(StockXml);
                var query =
                    from SAList in doc.Descendants("SAList")
                    where ((DateTime)SAList.Element("PublishDate") >= dateStart)
                    select ((string)SAList.Element("Ticker"));

                    foreach (var ticker in query)
                    ...{
                        sb.AppendFormat(StrockUrlFmt, ticker);
                    }

            }

< Reports >
     < SAList >
         < PublishDate > 05/20/2008 </ PublishDate >
        < OtherInfo />
     </ SAList >
     < SAList >
         < PublishDate > 05/20/2008 </ PublishDate >
        < OtherInfo />
</ SAList >

For Stored-Procedure
 

using  System.Data.SqlClient;
using  System.Linq;
... {
DataClassesDataContext ctx = new DataClassesDataContext();   //This class Generate by .dbml
IEnumerable<string> tickList6 = getTickerList(ctx, "Tes", hour, startDate);
        
        
        IEnumerable<string> tickList = (
                                       from c2 in tickList2
                                       select c2
                                       ).Union(
                                       from c3 in tickList3
                                       select c3                                       
                                       ).Union(
                                       from c5 in tickList5
                                       select c5
                                       ).Union(
                                       from c6 in tickList6
                                       select c6
                                       ).Distinct();
}
private  IEnumerable < string >  getTickerList(DataClassesDataContext ctx,  string  source,  int  hour, DateTime startDate)
     ... {
        DateTime endData = startDate.AddDays(1);
        var result = ctx.getLatestNewsList(source, hour); //call stored-procedure
        var tickList = (from res in result
                        where res.Type == "E0" && res.NewsDate >= startDate && res.NewsDate < endData
                        select res.Symbol
                        ).Distinct();
        return tickList;
    }

1.  _NewsItemsSource.Sort((NewsData item1, NewsData item2) => -DateTime.Compare(DateTime.ParseExact(item1.NewsTime, "yyMMdd hh:mm:ss zzz", Data.Global.Current.SystemCulture)
2. dataNoList.AddRange(dp.DataIds.Select((item)=>Math.Abs(item)));
3. CalcDataFilter[] yearAvg = yearNos.Select((item) => new YOYData{
4.                         NumYear = item,
5.                         MaxYear = lastYearNum
6.                     } as CalcDataFilter).ToArray();
7. int nInDay = qsResult.IntraDayData.Select((item) => item.PriceList.Count).Max();
8. dataInDay = qsResult.IntraDayData.Select((item)=>item.PriceList.Count).Max();
9. this.Menu.Data = Enumerable.Select(Data.CompetitorsDataOp.Current.CompetitorsPageInfos, item => item.Title).ToArray();
10. foreach (string callback in callbacks) {
                            page.Dispatcher.BeginInvoke(() => HtmlPage.Window.Invoke(callback, jsonKey, jsonData));
                        }