ATMLDataAccessLibrary.db.daos.SignalDAO.getTSFLibraries C# (CSharp) Method

        public List<dbTSFLibrary> getTSFLibraries()
        {
            List<dbTSFLibrary> list = new List<dbTSFLibrary>();
            String sql = "SELECT * FROM "
                        + dbTSFLibrary._TABLE_NAME;
            OleDbParameter[] dbParams = {};
            OleDbDataReader reader = ExecuteSqlQuery(sql, dbParams);
            if (reader != null)
            {
                while (reader.Read())
                {
                    dbTSFLibrary lb = new dbTSFLibrary();
                    lb.load(reader);
                    list.Add(lb);
                }
                reader.Close();
                reader.Dispose();
            }
            return list;
        }

 public void LoadSignalModelLibraryCache()
 {
     SignalDAO dao = new SignalDAO();
     List<dbTSFLibrary> list = dao.getTSFLibraries();
     _signalModelLibraryCache.Clear();
     foreach (dbTSFLibrary library in list)
     {
         string xmlns = library.targetNamespace;
         string content = library.content;
         if (string.IsNullOrEmpty(xmlns))
         {
             LogManager.Warn("A namespace does not exist for {0} and therefore not added to the schema cache.", library.libraryName );
         }
         else
         {
             MemoryStream ms = new MemoryStream(Encoding.UTF8.GetBytes(content));
             SignalModelLibrary sml = new SignalModelLibrary(ms);
             _signalModelLibraryCache.Add(xmlns, sml);
         }
     }
 }