Mercurial > pub > bltoolkit
diff Demo/Silverlight/Client/MainPage.xaml.cs @ 0:f990fcb411a9
Копия текущей версии из github
author | cin |
---|---|
date | Thu, 27 Mar 2014 21:46:09 +0400 |
parents | |
children |
line wrap: on
line diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/Demo/Silverlight/Client/MainPage.xaml.cs Thu Mar 27 21:46:09 2014 +0400 @@ -0,0 +1,62 @@ +using System; +using System.Linq; +using System.Threading; +using System.Windows.Controls; +using BLToolkit.Data.Linq; + +namespace Client +{ + public partial class MainPage : UserControl + { + public class Data + { + public string Name; + public int Sum; + } + + public MainPage() + { + InitializeComponent(); + + ThreadPool.QueueUserWorkItem(_ => + { + try + { + using (var dm = new DataModel()) + { + var q = + from c in dm.Categories + where !c.CategoryName.StartsWith("Con") + orderby c.CategoryName + select c.CategoryName; + + (from t in dm.Categories + group t by t.CategoryName into g + select new Data + { + Name = g.Key, + Sum = g.Sum(a => a.CategoryID) + }).ToList(); + + var text = string.Join("\n", q.ToArray()); + + Dispatcher.BeginInvoke(() => OutputText.Text = text); + + dm.BeginBatch(); + + dm.Categories.Delete(c => c.CategoryID == -99999); + dm.Categories.Delete(c => c.CategoryID == -999999); + + dm.CommitBatch(); + } + } + catch (Exception ex) + { + Dispatcher.BeginInvoke(() => OutputText.Text = ex.Message); + } + + //new ServiceReference1.TestLinqWebServiceSoap(); + }); + } + } +}