public Common.DTO.DicEntity getByWord(String Word) { SQLiteDataAdapter SDA = new SQLiteDataAdapter("Select * from Dictionary where Word = \"" + Word + "\"", Conn); if (Conn.State != ConnectionState.Open) { Conn.Open(); } DicDataset Ds = new DicDataset(); SDA.Fill(Ds.Dictionery); Conn.Close(); return(Ds.Dictionery.map().FirstOrDefault()); }
public List <Common.DTO.DicEntity> GetAll() { SQLiteDataAdapter SDA = new SQLiteDataAdapter("Select * from Dictionary", Conn); if (Conn.State != ConnectionState.Open) { Conn.Open(); } DicDataset Ds = new DicDataset(); SDA.Fill(Ds.Dictionery); Conn.Close(); return(Ds.Dictionery.map()); }