Question

如何查看linq生成的sql

Answer 1

class table
{
public string id
}

private void Window_Loaded(object sender, RoutedEventArgs e)
{
List<table> ls = new List<table>();
for (int i = 0; i < 10; i++)
ls.Add(new table );

int pageSize = 3;
int currentPage = 2;

var linq = (from t in ls.ToArray()
where
(from t2 in ls.ToArray() select t2.id).Take(pageSize * (currentPage - 1)).ToArray().Contains(t.id) == false
select t).Take(pageSize);

foreach (var l in linq)
this.Title += l.id + ",";
}