-
Notifications
You must be signed in to change notification settings - Fork 0
/
Example.cs
57 lines (36 loc) · 1.66 KB
/
Example.cs
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
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
public class MyModel
{
public long Id { get; set; }
public DateTime Date { get; set; }
}
public class RankData<MyModel>
{
public long Rank { get; set; }
public MyModel Model { get; set; }
}
public class MultipleConcat
{
public void Start()
{
var start = new DateTime(2000, 1, 1);
var end = new DateTime(2000, 1, 2);
var context = new DataConnection(new SQLiteDataProvider(ProviderName.SQLiteClassic), "Data Source=:memory:");
context.CreateTable<Car>();
var fluentMappingBuilder = context.MappingSchema.GetFluentMappingBuilder();
var carBuilder = fluentMappingBuilder.Entity<Car>();
carBuilder.Property(x => x.Id).IsPrimaryKey();
var carTable = context.GetTable<Car>();
var main = (from car in carTable
select new RankData<MyModel>
{
Model = { Id = car.Id, Date = car.DateTime },
Rank = Sql.Ext.RowNumber().Over().PartitionBy(car.Id).OrderBy(car.Id).ToValue()
}).Where(x => x.Rank == 1).Select(x => x.Model).AsSubQuery();
var first = main.Where(x => start <= x.Date && x.Date <= end);
var second = main.Where(x => x.Date < start).OrderByDescending(x => x.Date).Take(1);
var third = main.Where(x => end < x.Date).OrderBy(x => x.Date).Take(1);
var res = first.Concat(second).Concat(third).ToList();
var lastQuery = context.LastQuery;
File.WriteAllText("bla11212.txt", lastQuery);
}
}