internal void Create(string databaseName, string path) { dBContext.CreateDatabase(databaseName, path); taskQueue.Post(TopicsTable.CreateQuery()); taskQueue.Post(IndicatorsTable.CreateQuery()); }
internal List <string> GetTopicsIdList() { var query = TopicsTable.SelectTopicIds(); var results = dBContext.ExecuteQuery(query); var topicsIds = new List <string>(); for (int i = 0; i < results.Count; i++) { topicsIds.Add(results[i][0]); } return(topicsIds); }
public GrammarDataSet() { _tableGrammar = new GrammarTable(); _tableTopics = new TopicsTable(); _tableRules = new RulesTable(); _tableExamples = new ExamplesTable(); this.Tables.AddRange(new DataTable[] {_tableGrammar, _tableTopics, _tableRules, _tableExamples} ); AddForeignKey(_tableTopics, _tableTopics, Strings.COL_TOPIC_ID, Strings.COL_PARENT_TOPIC_ID, Strings.FK_TOPICS_TOPICS, true, true); AddForeignKey(_tableTopics, _tableRules, Strings.COL_TOPIC_ID, Strings.FK_RULES_TOPICS, true); AddForeignKey(_tableRules, _tableExamples, Strings.COL_RULE_ID, Strings.FK_EXAMPLES_RULES, true); _tableGrammar.DefaultView.Sort = Strings.COL_GRAMMAR_ID; _tableTopics.DefaultView.Sort = "ParentTopicId, Position"; _tableRules.DefaultView.Sort = "TopicId, Position"; _tableExamples.DefaultView.Sort = "RuleId, Position"; this.EnforceConstraints = true; }
internal void Insert(TopicsTable[] result) { var query = TopicsTable.InsertQuery(result); taskQueue.Post(query); }