public static void MainTest()
{
var connectionPool = new DbConnectionPool(new DbConnectionPoolPolicy(ConfigurationHelper.ConnectionString("TestDb")));
var repo = new Repository <TestEntity>(() => connectionPool.Get());
repo.Insert(new TestEntity
{
Token = "1233",
CreatedTime = DateTime.UtcNow
});
var entity = repo.Fetch(t => t.PKID == 1);
System.Console.WriteLine(entity.Token);
repo.Update(t => t.PKID == 1, t => t.Token, 1);
entity = repo.Fetch(t => t.PKID == 1);
System.Console.WriteLine(entity.Token);
repo.Delete(t => t.PKID == 1);
entity = repo.Fetch(t => t.PKID == 1);
System.Console.WriteLine($"delete operation {(entity == null ? "Success" : "Failed")}");
Console.WriteLine("finished.");
}
public static void MainTest()
{
var connectionPool = new DbConnectionPool(new DbConnectionPoolPolicy(ConfigurationHelper.ConnectionString("Test")));
var repo = new Repository <TestEntity>(() => connectionPool.Get());
repo.Execute("TRUNCATE TABLE dbo.tabTestEntity");
repo.Insert(new TestEntity
{
Token = "1233",
CreatedTime = DateTime.UtcNow
});
var entity = repo.Fetch(t => t.Id == 1);
System.Console.WriteLine(entity.Token);
repo.Update(t => t.Id == 1, t => t.Token, 1);
entity = repo.Fetch(t => t.Id == 1);
System.Console.WriteLine(entity.Token);
var exists = repo.Exist(e => e.Id == 1);
Console.WriteLine($"exists pkid == 1: {exists}");
repo.Delete(t => t.Id == 1);
entity = repo.Fetch(t => t.Id == 1);
System.Console.WriteLine($"delete operation {(entity == null ? "Success" : "Failed")}");
exists = repo.Exist(e => e.Id > 1000);
Console.WriteLine($"exists PKID > 1000: {exists}");
repo.Execute("TRUNCATE TABLE dbo.tabTestEntity");
Console.WriteLine("finished.");
}
