static void Main(string[] args) { Console.WriteLine("*************************************************"); Console.WriteLine("** Golf Score Tracker **"); Console.WriteLine("*************************************************"); var logger = NLogBuilder.ConfigureNLog("nlog.config").GetCurrentClassLogger(); using (var db = new GolfScoreContext()) { logger.Debug("Ensuring database is created"); db.Database.EnsureCreated(); TextCSVImporter importer = new TextCSVImporter(@"Data\MyGolfNuts.csv", (ILogger)logger); importer.ImportRound(db, "MyGolfNuts"); } Console.ReadLine(); }
public void ImportRound(GolfScoreContext db, string sourcename) { var sourceAlreadyExists = db.RoundSources.Find(sourcename) != null; if (sourceAlreadyExists) { Log.LogInformation("Source with name {0} already exists", sourcename); return; } RoundSource roundSource = new RoundSource { SourceName = sourcename, ContentType = "text/CSV", Content = File.ReadAllBytes(FileName) }; db.RoundSources.Add(roundSource); db.SaveChanges(); }