使用.net从MS Access数据库中删除不存在的记录

string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\path\\to\\database.accdb";
using (OleDbConnection connection = new OleDbConnection(connectionString))
{
    // 连接到数据库
    connection.Open();
    
    // 执行删除操作
    // ...
}

string sql = "SELECT * FROM TableName";
using (OleDbCommand command = new OleDbCommand(sql, connection))
{
    using (OleDbDataReader reader = command.ExecuteReader())
    {
        while (reader.Read())
        {
            // 检查记录是否存在于其他数据源中
            // ...
        }
    }
}

string deleteSql = "DELETE FROM TableName WHERE ID = @id";
using (OleDbCommand deleteCommand = new OleDbCommand(deleteSql, connection))
{
    deleteCommand.Parameters.AddWithValue("@id", recordId);
    deleteCommand.ExecuteNonQuery();
}

// 在连接的using语句块结束时自动关闭连接