public viewMolecularMass(string symbol) : this() { this.Symbol = symbol; using (dcFertilizer dc = new dcFertilizer(connectionString)) { //dc.InstallDataBase(); Molecule mol = dc.GetMolecule(this.Symbol); foreach (ElementMolecule e in mol.ElementMolecules) { this.Elements.Add(new mmElement { Quantity = e.Quantity ?? 0, MolecularMass = e.MolecularMass ?? 0, Symbol = e.Element.Symbol ?? "", PercentWeight = mol.MolecularPercentage(e.Element.Symbol) }); } } }
private static void ImportData(dcFertilizer dc) { LINQtoCSV.CsvContext con = new LINQtoCSV.CsvContext(); List<csvElemet> csvElems = con.Read<csvElemet>(@"C:\LittleApps\Fertilizer\Fertilizer\Data\Elements.csv").ToList(); List<Element> elements = csvElems.Select(e => new Element { AtomicMass = e.Atomic_Weight, AtomicNumber = e.AtomicNumber, Symbol = e.Symbol }).ToList(); dc.Elements.InsertAllOnSubmit(elements); dc.SubmitChanges(); }