FilesExpand file tree

master

/

Program.cs

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

105 lines (82 loc) · 2.96 KB

master

/

Program.cs

Copy path

Top

File metadata and controls

• Code
• Blame

105 lines (82 loc) · 2.96 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

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

using System;

using System.Collections.Generic;

using SqlKata;

using SqlKata.Compilers;

using SqlKata.Execution;

using System.Data.SqlClient;

using System.Threading.Tasks;

using System.Linq;

using Newtonsoft.Json;

using Npgsql;

using System.Data;

using Dapper;

using System.Data.SQLite;

using static SqlKata.Expressions;

using System.IO;

namespace Program

{

class Program

{

private class Loan

{

public string Id { get; set; }

public string Name { get; set; }

public List<Installment> Installments { get; set; } = new List<Installment>();

}

private class Installment

{

public string Id { get; set; }

public string LoanId { get; set; }

public int DaysCount { get; set; }

}

static void Main(string[] args)

{

var db = SqlLiteQueryFactory();

var id = db.Query("accounts").InsertGetId<int>(new

{

name = "new Account",

currency_id = "USD",

created_at = DateTime.UtcNow

});

var id2 = db.Select<int>("insert into accounts(name, currency_id, created_at) values ('account 2','usd','2019-01-01 20:00:00');select last_insert_rowid();");

Console.WriteLine($"last id is: {id}");

Console.WriteLine($"last id2 is: {id2.First()}");

}

private static void log(Compiler compiler, Query query)

{

var compiled = compiler.Compile(query);

Console.WriteLine(compiled.ToString());

Console.WriteLine(JsonConvert.SerializeObject(compiled.Bindings));

}

private static QueryFactory SqlLiteQueryFactory()

{

var compiler = new SqliteCompiler();

var connection = new SQLiteConnection("Data Source=Demo.db");

var db = new QueryFactory(connection, compiler);

db.Logger = result =>

{

Console.WriteLine(result.ToString());

};

if (!File.Exists("Demo.db"))

{

Console.WriteLine("db not exists creating db");

SQLiteConnection.CreateFile("Demo.db");

db.Statement("create table accounts(id integer primary key autoincrement, name varchar, currency_id varchar, created_at datetime);");

}

return db;

}

private static QueryFactory SqlServerQueryFactory()

{

var compiler = new PostgresCompiler();

var connection = new SqlConnection(

"Server=tcp:localhost,1433;Initial Catalog=Lite;User ID=sa;Password=P@ssw0rd"

);

var db = new QueryFactory(connection, compiler);

db.Logger = result =>

{

Console.WriteLine(result.ToString());

};

return db;

}

}

}