public void ImportDbDataFromJson(string path) { var ctx = new FluentModel(); using (ctx) { var files = Directory.GetFiles(path); var teams = ctx.GetAll<WeaponReport>().ToList(); foreach (var file in files) { var fileText = File.ReadAllText(file); var teamReport = JsonConvert.DeserializeObject<WeaponReport>(fileText); var teamReportDb = ctx.WeaponReports.FirstOrDefault(t => t.weaponName == teamReport.weaponName); if (teamReportDb != null) { teamReportDb.weaponId = teamReport.weaponId; teamReportDb.weaponName = teamReport.weaponName; teamReportDb.manufacturer = teamReport.manufacturer; } else { ctx.Add(teamReport); ctx.SaveChanges(); } } } }
public void UpdateDatabase() { using (var context = new FluentModel()) { var schemaHandler = context.GetSchemaHandler(); this.EnsureDB(schemaHandler); } }