public CsvFile GetCsvFile(int id) { using (CsvDataContext cntx = new CsvDataContext()) { return(cntx.CsvFileContents.FirstOrDefault(fileContent => fileContent.Id == id)); } }
public List <CsvFile> GetFiles() { using (CsvDataContext cntx = new CsvDataContext()) { return(cntx.CsvFileContents.ToList()); } }
public void Save(string fileName, byte[] contentBytes) { using (CsvDataContext cntx = new CsvDataContext()) { if (cntx.CsvFileContents.Any(x => x.FileName == fileName)) { throw new Exception($"Csv file with filename {fileName} already exists"); } CsvFile cdFileContent = new CsvFile { Content = contentBytes, FileName = fileName }; cntx.CsvFileContents.Add(cdFileContent); cntx.SaveChanges(); } }