Пример #1
0
        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());
        }
Пример #2
0
        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());
        }