/
Program.cs
50 lines (42 loc) · 1.55 KB
/
Program.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
using System;
using System.Data.Common;
using DbKeeperNet.Engine;
using DbKeeperNet.Engine.Configuration;
using DbKeeperNet.Extensions.SQLite;
using Microsoft.Data.Sqlite;
using Microsoft.Extensions.DependencyInjection;
using Microsoft.Extensions.Logging;
namespace CoreConsoleApp
{
class Program
{
static void Main(string[] args)
{
const string connectionString = "Data Source=fullframeworkdemo.db3";
var serviceCollection = new ServiceCollection();
serviceCollection.AddDbKeeperNet(c =>
{
c
.UseSQLite(connectionString)
.AddEmbeddedResourceScript("CoreConsoleApp.DatabaseUpgrade.xml,CoreConsoleApp");
});
serviceCollection.AddLogging(c => { c.AddConsole(); });
var serviceProvider = serviceCollection.BuildServiceProvider(true);
using (var scope = serviceProvider.CreateScope())
{
var upgrader = scope.ServiceProvider.GetService<IDatabaseUpdater>();
upgrader.ExecuteUpgrade();
}
using (var c = new SqliteConnection(connectionString))
{
c.Open();
DbCommand cmd = c.CreateCommand();
cmd.CommandText = "select * from DbKeeperNet_SimpleDemo";
DbDataReader reader = cmd.ExecuteReader();
while (reader.Read())
Console.WriteLine("{0}: {1}", reader[0], reader[1]);
}
Console.ReadLine();
}
}
}