-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathProgram.cs
More file actions
64 lines (54 loc) · 2.19 KB
/
Program.cs
File metadata and controls
64 lines (54 loc) · 2.19 KB
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
using EntityFrameworkCore.SqlServer.SimpleBulks.BulkDelete;
using EntityFrameworkCore.SqlServer.SimpleBulks.BulkInsert;
using EntityFrameworkCore.SqlServer.SimpleBulks.BulkMerge;
using EntityFrameworkCore.SqlServer.SimpleBulks.BulkUpdate;
using EntityFrameworkCore.SqlServer.SimpleBulks.Demo.Entities;
using Microsoft.EntityFrameworkCore;
using System;
using System.Collections.Generic;
namespace EntityFrameworkCore.SqlServer.SimpleBulks.Demo
{
class Program
{
static void Main(string[] args)
{
using (var dbct = new DemoDbContext())
{
dbct.Database.Migrate();
dbct.BulkDelete(dbct.Set<ConfigurationEntry>().AsNoTracking());
var configurationEntries = new List<ConfigurationEntry>();
for (int i = 0; i < 1000; i++)
{
configurationEntries.Add(new ConfigurationEntry
{
Key = $"Key{i}",
Value = $"Value{i}",
CreatedDateTime = DateTimeOffset.Now,
});
}
dbct.BulkInsert(configurationEntries);
foreach (var row in configurationEntries)
{
row.Key += "xx";
row.UpdatedDateTime = DateTimeOffset.Now;
row.IsSensitive = true;
row.Description = row.Id.ToString();
}
dbct.BulkUpdate(configurationEntries,
x => new { x.Key, x.UpdatedDateTime, x.IsSensitive, x.Description });
configurationEntries.Add(new ConfigurationEntry
{
Key = $"Key{1001}",
Value = $"Value{1001}",
CreatedDateTime = DateTimeOffset.Now,
});
dbct.BulkMerge(configurationEntries,
x => x.Id,
x => new { x.Key, x.UpdatedDateTime, x.IsSensitive, x.Description },
x => new { x.Key, x.Value, x.IsSensitive, x.CreatedDateTime });
}
Console.WriteLine("Finished!");
Console.ReadLine();
}
}
}