|
0
|
1 using System;
|
|
|
2 using System.Linq;
|
|
|
3 using System.Web.UI;
|
|
|
4
|
|
|
5 using BLToolkit.Data;
|
|
|
6 using BLToolkit.Data.Linq;
|
|
|
7
|
|
|
8 namespace Partial.Trust.Asp.Net
|
|
|
9 {
|
|
|
10 using Components;
|
|
|
11
|
|
|
12 public partial class _Default : Page
|
|
|
13 {
|
|
|
14 protected void Page_Load(object sender, EventArgs e)
|
|
|
15 {
|
|
|
16 var da = PersonDataAccessor.CreateInstance();
|
|
|
17 var list = da.GetPersonList();
|
|
|
18
|
|
|
19 Label1.Text = list[0].ContactName;
|
|
|
20
|
|
|
21 var q =
|
|
|
22 from c in new Table<Customers>()
|
|
|
23 where c.CustomerID == list[0].CustomerID
|
|
|
24 select c.ContactName;
|
|
|
25
|
|
|
26 Label2.Text = q.First();
|
|
|
27
|
|
|
28 using (var db = new DbManager())
|
|
|
29 Label3.Text = _compiledQuery(db, list[0].CustomerID).ToList().First();
|
|
|
30 }
|
|
|
31
|
|
|
32 static readonly Func<DbManager,string,IQueryable<string>> _compiledQuery =
|
|
|
33 CompiledQuery.Compile((DbManager db, string id) =>
|
|
|
34 from c in db.GetTable<Customers>()
|
|
|
35 where c.CustomerID == id
|
|
|
36 select c.ContactName);
|
|
|
37 }
|
|
|
38 }
|
