public async Task <IEnumerable <User> > GetAllAsync() { string query = "SELECT * FROM users;"; await _connection.OpenAsync(); var users = await _connection.ExecuteReaderAsync <User>(query); _connection.Close(); return(users); }
private void DisposeConnection() { try { lock (_disposeLock) { using (lock_manager.getLockItem().Write()) { if (_connection != null) { using (_connection) { _connection.Close(); } _connection = null; } CloseConnection(); } } } catch (Exception ex) { Logger.ErrorException("Error disposing database", ex); } }
private void PrepareCurrentConnection(IDatabaseConnection connection) { CurrentConnection = connection; CurrentConnection.Open(); SqlCommon.Status.Set(CurrentConnection); CurrentConnection.Close(); SqlCommon.SqlForm.Text = String.Format("{0} - {1}", connection.Name, Global.FullTitle); SqlCommon.DatabaseContent.ConnectedTo(); SqlCommon.SqlForm.menuWindowNewSame.Enabled = true; }
private static void TestDbConnection(IDatabaseConnection connection) { connection.Open(); connection.SetCommandType(SqormCommandType.Text); string query = "SELECT * FROM users WHERE id >= @id;"; var users = connection.ExecuteReader<User>(query, new ParameterContainer {{ "@id", 1 }}); query = "SELECT * FROM users WHERE id=@id;"; connection.SetCommandType(SqormCommandType.StoredProcedure); connection.Close(); foreach (var user in users) { System.Console.WriteLine(user.ToString()); } }