FilesExpand file tree

 upsert

/

QueryWithCountTask.cs

Copy path

BlameMore file actions

BlameMore file actions

Latest commit

 

History

History

History

28 lines (26 loc) · 780 Bytes

 upsert

/

QueryWithCountTask.cs

Top

File metadata and controls

• Code
• Blame

28 lines (26 loc) · 780 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

namespace ProfilingApp

{

using System;

using Simple.Data;

class QueryWithCountTask : IProfileTask

{

private readonly dynamic _db = Database.OpenConnection(Properties.Settings.Default.ConnectionString);

public void Run()

{

for (int i = 0; i < 100; i++)

{

GetPostAndPrintTitle(i);

}

}

private void GetPostAndPrintTitle(int i)

{

Future<int> count;

var post = _db.Posts.All()

.WithTotalCount(out count)

.Skip(i)

.Take(1)

.FirstOrDefault();

Console.WriteLine(string.Format("{0}/{1}: {2}", i + 1, count.Value, post.Title));

}

}

}