-
Notifications
You must be signed in to change notification settings - Fork 3.1k
/
TableSplittingSqliteTest.cs
40 lines (32 loc) · 1.1 KB
/
TableSplittingSqliteTest.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
// Licensed to the .NET Foundation under one or more agreements.
// The .NET Foundation licenses this file to you under the MIT license.
using Microsoft.EntityFrameworkCore.TestModels.TransportationModel;
namespace Microsoft.EntityFrameworkCore;
#nullable disable
public class TableSplittingSqliteTest(ITestOutputHelper testOutputHelper) : TableSplittingTestBase(testOutputHelper)
{
public override async Task ExecuteUpdate_works_for_table_sharing(bool async)
{
await base.ExecuteUpdate_works_for_table_sharing(async);
AssertSql(
"""
UPDATE "Vehicles" AS "v"
SET "SeatingCapacity" = 1
""",
//
"""
SELECT NOT EXISTS (
SELECT 1
FROM "Vehicles" AS "v"
WHERE "v"."SeatingCapacity" <> 1)
""");
}
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
modelBuilder.Entity<Engine>().ToTable("Vehicles")
.Property(e => e.Computed).HasComputedColumnSql("1");
}
protected override ITestStoreFactory TestStoreFactory
=> SqliteTestStoreFactory.Instance;
}