-
Notifications
You must be signed in to change notification settings - Fork 3.2k
/
SequentialGuidEndToEndTest.cs
114 lines (91 loc) · 3.58 KB
/
SequentialGuidEndToEndTest.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
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
// Licensed to the .NET Foundation under one or more agreements.
// The .NET Foundation licenses this file to you under the MIT license.
// ReSharper disable InconsistentNaming
namespace Microsoft.EntityFrameworkCore;
#nullable disable
public class SequentialGuidEndToEndTest : IAsyncLifetime
{
[ConditionalFact]
public async Task Can_use_sequential_GUID_end_to_end_async()
{
var serviceProvider = new ServiceCollection()
.AddEntityFrameworkSqlServer()
.BuildServiceProvider(validateScopes: true);
using (var context = new BronieContext(serviceProvider, TestStore.Name))
{
context.Database.EnsureCreatedResiliently();
for (var i = 0; i < 50; i++)
{
await context.AddAsync(
new Pegasus { Name = "Rainbow Dash " + i });
}
await context.SaveChangesAsync();
}
using (var context = new BronieContext(serviceProvider, TestStore.Name))
{
var pegasuses = await context.Pegasuses.OrderBy(e => e.Id).ToListAsync();
for (var i = 0; i < 50; i++)
{
Assert.Equal("Rainbow Dash " + i, pegasuses[i].Name);
}
}
}
[ConditionalFact]
public async Task Can_use_explicit_values()
{
var serviceProvider = new ServiceCollection()
.AddEntityFrameworkSqlServer()
.BuildServiceProvider(validateScopes: true);
var guids = new List<Guid>();
using (var context = new BronieContext(serviceProvider, TestStore.Name))
{
context.Database.EnsureCreatedResiliently();
for (var i = 0; i < 50; i++)
{
guids.Add(
(await context.AddAsync(
new Pegasus
{
Name = "Rainbow Dash " + i,
Index = i,
Id = Guid.NewGuid()
})).Entity.Id);
}
await context.SaveChangesAsync();
}
using (var context = new BronieContext(serviceProvider, TestStore.Name))
{
var pegasuses = await context.Pegasuses.OrderBy(e => e.Index).ToListAsync();
for (var i = 0; i < 50; i++)
{
Assert.Equal("Rainbow Dash " + i, pegasuses[i].Name);
Assert.Equal(guids[i], pegasuses[i].Id);
}
}
}
private class BronieContext(IServiceProvider serviceProvider, string databaseName) : DbContext
{
private readonly IServiceProvider _serviceProvider = serviceProvider;
private readonly string _databaseName = databaseName;
// ReSharper disable once UnusedAutoPropertyAccessor.Local
public DbSet<Pegasus> Pegasuses { get; set; }
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
=> optionsBuilder
.UseSqlServer(SqlServerTestStore.CreateConnectionString(_databaseName), b => b.ApplyConfiguration())
.UseInternalServiceProvider(_serviceProvider);
}
private class Pegasus
{
public Guid Id { get; set; }
public string Name { get; set; }
public int Index { get; set; }
}
protected SqlServerTestStore TestStore { get; private set; }
public async Task InitializeAsync()
=> TestStore = await SqlServerTestStore.CreateInitializedAsync("SequentialGuidEndToEndTest");
public Task DisposeAsync()
{
TestStore.Dispose();
return Task.CompletedTask;
}
}