public DBQueryStatus(IDBConnection dbConnection, IDBScriptsProvider dBScriptsProvider) { dbConnection.ThrowIfNull(nameof(dbConnection)); _dbConnection = dbConnection; _dBScriptsProvider = dBScriptsProvider; _dbConnection.Open(); }
public DBBackupRestoreCommands(IDBConnection dbConnection, IDBScriptsProvider dBScriptsProvider) { dbConnection.ThrowIfNull(nameof(dbConnection)); _dbConnection = dbConnection; _dBScriptsProvider = dBScriptsProvider; _dbConnection.Open(); }
private void btnSearch_Click(object sender, EventArgs e) { SearchBegin(this, new EventArgs()); string QueryText = tbQuery.Text; QueryText = fmInvIndex.ClearText(QueryText); RussianStemmer RStemmer = new RussianStemmer(); List <string> queryWords = QueryText.Split(' ').ToList().Select(t => RStemmer.Stem(t)).Where(t => t.Length > 2) .OrderBy(t => t).ToList(); lblQueryForIIView.Text = queryWords.Aggregate((l, r) => l + " " + r); pnResponses.Controls.Clear(); if (queryWords.Count == 0) { MessageBox.Show("По данному запросу ничего не найдено"); return; } List <int> resultIDs = new List <int>(); if (openFileDialog.SafeFileName.Split('.').Last() == "ii") { resultIDs = SearchInSimpleInvertedIndex(queryWords); } else { resultIDs = SearchInCompressedInvertedIndex(queryWords); } if (resultIDs == null || resultIDs.Count == 0) { MessageBox.Show("По данному запросу ничего не найдено"); return; } string forQuery = "(" + resultIDs.Select(n => n.ToString()).Aggregate((l, r) => l + "," + r) + ")"; string sql = "SELECT [u].[Text] [URL] FROM [dbo].[Urls] [u] inner join [dbo].[Pages] [p] on [u].[UrlId] = [p].[MainUrl_UrlId] WHERE [p].[Id] in " + forQuery; Connection.Open(); DataTable dt = Connection.ExecuteQuery(sql); Connection.Close(); dgv.DataSource = new DataView(dt); pnResponses.Controls.Add(dgv); SearchEnd(this, new EventArgs()); }
private void LoadDataFromDB(bool ReconnectFlag = true) { if (ReconnectFlag || Connection == null) { if (Connection != null) { Connection.Close(); } Connection = DBConnection.GetInstance(GetConnectionString()); } string sql = "SELECT [Id],[Content] FROM [dbo].[Pages];"; Connection.Open(); DataTable dt = Connection.ExecuteQuery(sql); Connection.Close(); DocumentCorpus.Adapter(dt); }
protected int FindAllCount() { try { if (!dbc.IsOpen) { dbc.Open(); } //Returns an object, not an int logger.LogInformation("FindAllCount complete."); return((int)dbc.Select <TEntity>().Count); } catch (Exception ex) { logger.LogError(ex.Message); return(0); } }
public DBError Open() { return(sqlConnection.Open()); }
public DBError Open() { sqlConnection = factory.GetConnection(); return(sqlConnection.Open()); }