-
Notifications
You must be signed in to change notification settings - Fork 0
/
Program.cs
35 lines (29 loc) · 983 Bytes
/
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
using System;
using System.IO;
namespace SQLMonkey {
class Program {
static void Main(string[] args) {
var testUser = new TestUser {
age = 23,
id = 1,
name = "boss"
};
var path = Directory.GetParent(
Directory.GetParent(Directory.GetCurrentDirectory()).ToString()
).ToString();
var connectionString =
String.Format(@"
Data Source=(LocalDB)\MSSQLLocalDB;
AttachDbFilename={0}\Database.mdf;
Integrated Security=True"
, path);
var monkey = new SQLMonkey(connectionString);
var users = monkey.retrieve<TestUser>("users");
foreach (var user in users) {
user.age++;
Console.WriteLine(user.age);
monkey.update<TestUser>(user, "users");
}
}
}
}