private static void AccessSample()
{
using (var accessOperation = new AccessOperation())
{
//NewDatabase
var filePath = Path.Combine(Environment.CurrentDirectory, "sample.accdb");
accessOperation.NewDatabase(filePath);
}
using (var conn = DbConnectionFactory.Default.CreateConnection())
using (var tran = conn.BeginTransaction())
{
try
{
var service = new SampleService(conn);
//CreateDatabase
service.CreateTable(tran);
//AddSampleData
service.AddSampleData(tran);
tran.Commit();
}
catch (Exception)
{
tran.Rollback();
throw;
}
}
using (var conn = DbConnectionFactory.Default.CreateConnection())
{
var service = new SampleService(conn);
//GetAll
var records = service.GetAll();
foreach (var r in records)
{
Console.WriteLine(string.Join(" - ", r.Column1, r.Column2));
}
Console.WriteLine("===============================");
//GetById
var record = service.GetById("2");
Console.WriteLine(string.Join(" - ", record.Column1, record.Column2));
}
}
