static void Main(string[] args)
{
string filePath = "Examples/CSV/Santander.csv";
CSVImporter importer = new CSVImporter(new System.IO.FileInfo(filePath));
List <Transaction> transactions = SantanderCSVParser.Parse(importer).ToList();
Console.WriteLine($"Found {transactions.Count} transactions");
string path = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location);
string fullPath = Path.Combine(path, "SQLite", "budjit.db");
var builder = new DbContextOptionsBuilder <BudjitContext>().UseSqlite($"DataSource={fullPath}");
BudjitContext context = new BudjitContext(builder.Options);
context.Database.Migrate();
ITransactionsRepository repo = new TransactionRepository(context);
repo.Create(transactions);
List <Transaction> databaseTransactions = repo.GetAll().ToList();
int count = 1;
foreach (Transaction trans in databaseTransactions)
{
Console.WriteLine($"{count} - {trans.Description}");
count++;
}
Console.ReadLine();
}
private BudjitContext GetContext(DbContextOptions <BudjitContext> options)
{
var context = new BudjitContext(options);
context.Database.OpenConnection();
context.Database.EnsureCreated();
return(context);
}